08 2018 档案

Oracle create program and job for scheduler jobs
摘要：PROCEDURE PROC_START_WF_JOB(IN_WF_PARAM IN OUT PROC_WF_PARAM_TYPE) AS V_RUNCNT NUMBER(8); V_PROGRAMNAME VARCHAR2(30); V_JOBNAME VARCHAR2(30); V_PROCNA 阅读全文
posted @ 2018-08-30 15:14 Ayumie 阅读(307) 评论(0) 推荐(0) 编辑
Stop_Disable_Drop_Scheduler_JOB
摘要：SELECT * FROM DBA_SCHEDULER_JOBS t WHERE OWNER='TEST';SELECT * FROM DBA_SCHEDULER_PROGRAMS WHERE OWNER='TEST';--1.stop jobs and enable/disable jobsBEG 阅读全文
posted @ 2018-08-30 11:06 Ayumie 阅读(356) 评论(0) 推荐(0) 编辑
Oracle left join
摘要：TABLE1 100 ROWS TABLE2 1000 ROWS TABLE1 LEFT JOIN TABLE2 RESULT: MIN ROWS= 100 MAX ROWS=100*1000 (TABLE1的每行记录都匹配TABLE2的1000行数据,类似主表和明细表) 阅读全文
posted @ 2018-08-01 16:50 Ayumie 阅读(874) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示