怎样调用Oracle中DBMS

2025-03-19 10:47:32
推荐回答(1个)
回答1:

exec dbms_....

SQL> exec dbms_stats.gather_table_stats('CLARK','TT');

PL/SQL 过程已成功完成。

或者有些直接使用select

SQL> select dbms_random.value() randomval from dual
2 ;

RANDOMVAL
----------
.265415762

SQL> select dbms_random.string('a',10) randomstr from dual;

RANDOMSTR
--------------------------------------------------------------------------------
MklhdTxYgf