ORACLE JOB ÉèÖÃ
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ä¸ô£¬µ±intervalÉèÖÃΪnullʱ£¬¸ÃjobÖ´ÐнáÊøºó£¬
¾Í±»´Ó¶ÓÁÐÖÐɾ³ý¡£¼ÙÈç ÎÒÃÇÐèÒª¸ÃjobÖÜÆÚÐÔµØÖ´ÐУ¬ÔòÒªÓÑsysdate£«m’±íʾ¡£
1:ÿ·ÖÖÓÖ´ÐÐ
Interval => TRUNC(sysdate,'mi') + 1/ (24*60) »ò Interval => sysdate+1/1440
2:ÿÌ춨ʱִÐÐ
ÀýÈ磺ÿÌìµÄÁ賿1µãÖ´ÐÐ
Interval => TRUNC(sysdate) + 1 +1/ (24)
3:ÿÖܶ¨Ê±Ö´ÐÐ
ÀýÈ磺ÿÖÜÒ»Á賿1µãÖ´ÐÐ
Interval => TRUNC(next_day(sysdate,'ÐÇÆÚÒ»'))+1/24
4:ÿÔ¶¨Ê±Ö´ÐÐ
ÀýÈ磺ÿÔÂ1ÈÕÁ賿1µãÖ´ÐÐ
Interval =>TRUNC(LAST_DAY(SYSDATE))+1+1/24
5:ÿ¼¾¶È¶¨Ê±Ö´ÐÐ
ÀýÈçÿ¼¾¶ÈµÄµÚÒ»ÌìÁ賿1µãÖ´ÐÐ
Interval => TRUNC(ADD_MONTHS(SYSDATE,3),'Q') + 1/24
6:ÿ°ëÄ궨ʱִÐÐ
ÀýÈ磺ÿÄê7ÔÂ1ÈÕºÍ1ÔÂ1ÈÕÁ賿1µã
Interval => ADD_MONTHS(trunc(sysdate,'yyyy'),6)+1/24
7:ÿÄ궨ʱִÐÐ
ÀýÈ磺ÿÄê1ÔÂ1ÈÕÁ賿1µãÖ´ÐÐ
Interval =>ADD_MONTHS(trunc(sysdate,'yyyy'),12)+1/24
¶þ£º
ÔÚÒ»¸öÌض¨µÄʱ¼ä¼ä¸ôºó£¬Öظ´ÔËÐиÃÈÎÎñ¡£
ÔÚÌض¨µÄÈÕÆÚºÍʱ¼äÔËÐÐÈÎÎñ¡£
ÈÎÎñ³É¹¦Íê³Éºó£¬ÏÂÒ»´ÎÖ´ÐÐÓ¦¸ÃÔÚÒ»¸öÌض¨µÄʱ¼ä¼ä¸ôÖ®ºó¡£
µÚÒ»ÖÖµ÷¶ÈÈÎÎñÐèÇóµÄÈÕÆÚËã·¨±È½Ï¼òµ¥£¬¼´'SYSDATE+n',ÕâÀïnÊÇÒ»¸öÒÔÌìΪµ¥Î»µÄʱ¼ä¼ä¸ô¡£±í1¸ø³öÁËһЩÕâÖÖʱ¼ä¼ä¸ôÉèÖõÄÀý×Ó¡£
±í1 һЩ¼òµ¥µÄinterval²ÎÊýÉèÖÃÀý×Ó
ÃèÊö
Interval²ÎÊýÖµ
ÿÌìÔËÐÐÒ»´Î
'SYSDATE + 1'
ÿСʱÔËÐÐÒ»´Î
'SYSDATE + 1/24'
ÿ10·ÖÖÓÔËÐÐÒ»´Î
'SYSDATE + 10/£¨60*24£©'
ÿ30ÃëÔËÐÐÒ»´Î
'SYSDATE + 30/(60*24*60)'
ÿ¸ôÒ»ÐÇÆÚÔËÐÐÒ»´Î
Ïà¹ØÎĵµ£º
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐÐ ......
ÅäÖÃÉí·ÝÑéÖ¤
OracleΪÓû§ÕË»§ÌṩÈýÖÖÉí·ÝÑéÖ¤·½·¨£º
(1)ÃÜÂëÑéÖ¤
µ±Ò»¸öʹÓÃÃÜÂëÑéÖ¤»úÖƵÄÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµØÊý¾Ý¿âÓû§£¬²¢ÇÒÌṩÓë¸ÃÓû§ÔÚÊý¾Ý¿âÖд洢µÄÃÜÂëÏàÆ¥ÅäµÄÃÜÂë¡£
(2)ÍⲿÑéÖ¤
µ±Ò»¸öÍⲿÑé֤ʽÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµÄ ......
¡¡²Ù×÷·ûÓÅ»¯
¡¡¡¡IN ²Ù×÷·û
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
¡¡¡¡µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
¡¡¡¡ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£ ......
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from ......