Oracle，在DBMS_STATS.GATHER_SCHEMA_STATS中选择

Question

我想在DBMS_STATS.GATHER_SCHEMA_STATS中使用选择查询，但是我编写的代码返回一个错误。

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS((select sys_context( 'userenv','current_schema') from dual));

查询:从dual中选择sys_context( 'userenv'，'current_schema')；返回模式名称。

这是我的错误：

Error starting at line : 1 in command -
BEGIN DBMS_STATS.GATHER_SCHEMA_STATS((select sys_context( 'userenv','current_schema') from dual)); END;
Error report -
ORA-06550: line 1, column 39:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:

   ( - + case mod new not null <an identifier>
   <a double-quoted delimited-identifier> <a bind variable>
   continue avg count current exists max min prior sql stddev
   sum variance execute forall merge time timestamp interval
   date <a string literal with character set specification>
   <a number> <a single-quoted SQL string> pipe
   <alternatywnie oznaczany literał napisowy ze specyfikacją zestawu znaków>
   <alternatywn
ORA-06550: line 1, column 96:
PLS-00103: Encountered the symbol ")" when expecting one of the following:

   . , @ ; for <an identifier>
   <a double-quoted delimited-identifier> group having intersect
   minus order partition start subpartition union where connect

06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

Answer 1

你太接近了。不需要使用SELECT .. FROM DUAL

使用以下代码：

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(sys_context( 'userenv','current_schema'));

干杯！！