ORACLE的几个系统级函数

oracle中的几个系统级函数

1.随机数

dbms_random.value(value1,value2)

SELECT to_char(dbms_random.value(1,3000000),'FM9999990.00') FROM dual;
SELECT to_char(dbms_random.value(1,300000),'FM9999999') FROM dual;
SELECT to_char(dbms_random.value(1,3000),'FM9999999') FROM dual;

2.打印堆栈信息

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

3.console输出

DBMS_OUTPUT.PUT_LINE(value1)

4.创建Job

DBMS_SCHEDULER.CREATE_JOB(JOB_NAME,
						  JOB_TYPE,
						  JOB_ACTION,
						  START_DATE,
						  REPEAT_INTERVAL,
						  ENABLED,
						  AUTO_DROP,
						  COMMENTS )