摘要:
--所有下级 SELECT SAP_ORGAN_CODE FROM SAP_ORGAN_LEVEL CONNECT BY PRIOR SAP_FATHER_ORGAN_CODE= SAP_ORGAN_CODE START WITH SAP_FATHER_ORGAN_CODE='SU01';
阅读全文
posted @ 2016-07-05 17:02
琥珀玲珑
阅读(527)
推荐(0)
编辑
摘要:
--去重DELETE FROM DEPR_MONTHS_LIST AWHERE (A.ASSET_ID,A.DEPR_DATE,A.UNIT_COST_ID) IN(SELECT B.ASSET_ID,B.DEPR_DATE,B.UNIT_COST_ID FROM DEPR_MONTHS_LIST
阅读全文
posted @ 2016-07-05 17:01
琥珀玲珑
阅读(274)
推荐(0)
编辑
摘要:
--正在执行的sqlselect b.sid,b.username,b.serial#,spid,paddr,sql_text,b.machine from v$process a,v$session b,v$sqlarea cwhere a.addr=b.paddr and b.sql_hash_
阅读全文
posted @ 2016-07-05 16:59
琥珀玲珑
阅读(102)
推荐(0)
编辑
摘要:
--创建job DECLARE JOBID NUMBER; BEGIN --JOBID:=4003; DBMS_JOB.SUBMIT(JOBID,'DECLARE RETURNVALUE VARCHAR2(2); BEGIN PAC_WITHDRAWINGDEPR.ALL_ACCOUNTDEPREC
阅读全文
posted @ 2016-07-05 16:59
琥珀玲珑
阅读(224)
推荐(0)
编辑