Join ile Update
UPDATE t1
SET t1.data =
(SELECT t2.data
FROM t2
WHERE t1.a=t2.a
AND t1.b=t2.b
AND t1.c=t2.c
AND t2.d=1
and t2.e='01062012'
AND t1.f=t2.f
AND t1.h=t2.h
--and rownum=1
)
WHERE t1.d=0
AND t1.e='01062012'
and t1.i=0;
DBA SCHEDULER JOB
DBA SCHEDULER JOB OLUŞTURMA BEGIN SYS.DBMS_SCHEDULER.CREATE_JOB ( job_name => 'isci', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN islemi_yapacak_prosedur; END;', job_class => 'DEFAULT_JOB_CLASS', repeat_interval => 'FREQ=DAILY; byhour=7', enabled => true, comments => 'Bu program gunluk olarak calisacak'); END; /******* Değiştirme ******/ BEGIN DBMS_SCHEDULER.set_attribute ( NAME => 'ISCI', ATTRIBUTE => 'repeat_interval', VALUE => 'FREQ=DAILY; byhour=9'); END; BEGIN dbms_scheduler.DISABLE ('ISCI'); END; /******* Çalıştırma ve Durdurma ******/ BEGI...
Yorumlar
Yorum Gönder