Oracle 10g schedule jobµÄ³£ÓòÙ×÷
OracleÊý¾Ý¿â10g schedule jobµÄ³£ÓòÙ×÷:
-- job ȨÏÞ
grant create job to somebody;
-- job ´´½¨
begin
dbms_scheduler.create_job (
job_name => 'AGENT_LIQUIDATION_JOB',
job_type => 'STORED_PROCEDURE',
job_action => 'AGENT_LIQUIDATION.LIQUIDATION', --´æ´¢¹ý³ÌÃû
start_date => sysdate,
repeat_interval => 'FREQ=MONTHLY; INTERVAL=1; BYMONTHDAY=1;BYHOUR=1;BYMINUTE=0;BYSECOND=0', -- °´Ô£¬¼ä¸ôΪ1¸ö(ÔÂ),ÿÔÂ1ºÅ,Á賿1µã
comments => 'Ö´ÐдúÀíÉÌÇå·Ö³ÌÐò'
);
end;
/
-- job Ö´ÐÐʱ¼ä²âÊÔ
DECLARE
start_date date;
return_date_after date;
next_run_date date;
BEGIN
start_date := sysdate;--to_timestamp_tz('10-OCT-2004 10:00:00','DD-MM-YYYY HH24:MI:SS');
return_date_after := start_date;
FOR i IN 1..10 LOOP
DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING('FREQ=MONTHLY; INTERVAL=1; BYMONTHDAY=1;BYHOUR=1;BYMINUTE=0;BYSECOND=0',start_date, return_date_after, next_run_date);
DBMS_OUTPUT.PUT_LINE('next_run_date: ' || to_char(next_run_date,'yyyy-mm-dd HH24:MI:SS'));
return_date_after := next_run_date;
END LOOP;
END;
/
-- job ²éѯ
select owner, job_name, state from dba_scheduler_jobs;
select job_name, state from user_scheduler_jobs;
-- job ÆôÓÃ
begin
dbms_scheduler.enable('BACKUP_JOB');
end;
/
-- job ÔËÐÐ
begin
dbms_scheduler.run_job('COLA_JOB',TRUE); -- true´ú±íͬ²½Ö´ÐÐ
end;
/
-- job Í£Ö¹(²»Ì«ºÃÓÃ)
begin
dbms_scheduler.stop_job(job_name => 'COLA_JOB',force => TRUE);
end;
/
-- job ɾ³ý(¶ÔÍ£jobÀ´ËµºÃÓÃ)
begin
dbms_scheduler.drop_job(job_name => 'COLA_JOB',force => TRUE);)
end;
/
Ïà¹ØÎĵµ£º
¡¾°¸ÀýÒ»¡¿
ÌâÄ¿£º
--´¥·¢Æ÷£º
--Ìí¼ÓÔ±¹¤ÐÅÏ¢,Á÷Ë®ºÅ×÷Ϊ×Ô¶¯±àºÅ(ͨ¹ýÐòÁÐÉú³É),
--²¢ÇÒÅжÏÈç¹û¹¤×ÊСÓÚ0,Ôò¸ÄΪ0;Èç¹û´óÓÚ10000,Ôò¸ÄΪ10000¡£
CREATE TABLE emp2(
e_id NUMBER,
e_no NUMBER,
e_name VARCHAR2(20),
e_sal NUMBER
)
SELECT * from emp2;
CREATE SEQUENCE seq_trg_id;
INSERT INTO emp2(e_i ......
ÕÒ²»µ½ÔÌûÁË ¾ÍÌùÕâÀï°É£¡
ÔÚÏò´ó¼ÒÏêϸ½éÉÜOracle֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂOracle xmltypeÊÇʲô£¬Oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ----
xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃæ½«½éÉÜOracle
xmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐOracle xmltypeÊý¾Ý ......
¾²âÊÔ£¬ÔÚOracleÖУ¬¶ÔÓÚnullºÍ¿Õ×Ö·û´®'',webMethods JDBC Adapter ²éѯ³öÀ´¶¼»áÏÔʾnull.
¶øÔÚSQL SERVERÖУ¬»á·Ö±ðÏÖʵΪnullºÍ¿Õ×Ö·û´®¡£
º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ ......
Oracle
1£¬shutdownÖ®ºó£¬ÈçºÎÆô¶¯Êý¾Ý¿âʵÀý£¿
ͨ¹ýCMDÃüÁî·û sqlplus "sys/password as
sysdba"£¬»áÁ¬µ½Ò»¸ö¿ÕÏÐʵÀý£¬ÕâÑù¿ÉÔÙÓÃstartupÃüÁî¡£
2£¬×°ÁËÊý¾Ý¿âÖ®ºó£¬ÓÃÁËshutdown£¬ºóÓÃÁËstartupµÈÆô¶¯Ö®ºó£¬¿ÉÓÃsql
plusºÍÍøÒ³·½Ê½Á¬oracle¡£µ«ÓÃjdbcÁ¬½Ó³ö´í£¿
ÊǼàÌýÆ÷ûÆô¶¯£ºD:\oracle\product\10.1.0\Db_1\ ......
SGA ÖеÄÁíÍâÒ»¸öÖØÒª½á¹¹Êǹ²Ïí³Ø¡£¹²Ïí³Ø´æ´¢ÁËÓ¦ÓÃÖ´ÐÐÐèÒªµÄPL/SQL¿é½á¹¹£¬SQLÓï¾äµÄÎı¾¡¢SQL±àÒëºóµÄ¿É
Ö´ÐдúÂ롢ϵͳÊý¾Ý×ÖµäµÈ¡£
Ç¡µ±µÄ¹²Ïí³Ø³ß´çÉèÖý«¼õÉÙϵͳ¸÷ÖÖ×ÊÔ´µÄʹÓá£Ê×ÏÈ£¬¶ÔÓÚSQL¡¢PL/SQL À´Ëµ£¬¹²Ïí³ØÌṩÁËÔËÐÐ״̬ϵÄÁÙʱ
´æ´¢µã£¬ºóÐøÖ´ÐеÄSQLºÍPL/SQL½«Ê ......