È«ÃæѧϰORACLE SchedulerÌØÐÔ(3)ʹÓÃPrograms
¶þ¡¢Ê¹ÓÃPrograms
¡¡¡¡ÔÚÂÛ̳ÖÐż¶û¼û¹ýÓÐÈËÌÖÂÛÈçºÎÔÚORACLEÖÐÖ´ÐвÙ×÷ϵͳÃüÁ»òÊÇORACLEÊý¾Ý¿âÍâµÄÓ¦Óá£Ó¦¸Ã˵ÔÚ9i¼°Ö®Ç°µÄ°æ±¾ÖУ¬ËäȻ˵²¢·ÇÍêÈ«ÎÞ·¨ÊµÏÖ£¨Æäʵ»¹ÊÇÓжàÖÖ·½Ê½Äܹ»±äÏàʵÏֵģ©£¬²»¹ý¸´ÔÓµÄʵÏÖ·½Ê½ÈÃDBAʹ¾¢ÁËÁ¦£¬ÉË͸ÁËÐÄ£¬·Ñ¾¢ÁËʶù¡£
¡¡¡¡½øÈë10g°æ±¾Ö®ºó£¬¾ÍÍêÈ«²»±ØÈç´Ë·ÑÉñ£¬ÒòΪÓÐÁËDBMS_SCHEDULER£¬ÒòΪÓÐÁËPROGRAM¡£
2.1 ´´½¨Programs
¡¡¡¡Scheduler ÖеÄProgram¶ÔÏó²¢²»Êdz£¹æÒâÒåÉϵÄ"³ÌÐò"»ò"Ó¦ÓÃ"£¬¶ø¾ÍÊÇÒ»¸ö"¶ÔÏó"£¬ÓÉDBA¶¨ÒåµÄ£¬¾ßÓÐÖ´ÐÐijÏÄܵÄÌØÊâ¶ÔÏó¡£ProgramÖÐʵ¼ÊÖ´ÐеIJÙ×÷¿ÉÒÔ·ÖΪÏÂÁÐÈýÖÖÀàÐÍ£º
PL/SQL BLOCK £º±ê×¼µÄpl/sql´úÂë¿é£»
STORED PROCEDURE £º±àÒëºÃµÄPL/SQL´æ´¢¹ý³Ì£¬»òÕßJava´æ´¢¹ý³Ì£¬ÒÔ¼°ÍⲿµÄc×Ó³ÌÐò£»
EXECUTEABLE £ºORACLEÊý¾Ý¿âÖ®ÍâµÄÓ¦Ó㬱ÈÈç²Ù×÷ϵͳÃüÁîµÈµÈ¡£
¡¡¡¡´´½¨ProgramsʹÓÃDBMS_SCHEDULER.CREATE_PROGRAM¹ý³Ì£¬¸Ã¹ý³ÌÖ§³ÖµÄ²ÎÊýÈçÏ£º
JSSWEB> desc dbms_scheduler.create_program;
Parameter Type Mode Default?
------------------- -------------- ---- --------
PROGRAM_NAME VARCHAR2 IN
PROGRAM_TYPE VARCHAR2 IN
PROGRAM_ACTION VARCHAR2 IN
NUMBER_OF_ARGUMENTS BINARY_INTEGER IN Y
ENABLED BOOLEAN IN Y
OMMENTS &nb
Ïà¹ØÎĵµ£º
OracleOraHome92Agent
OracleOraHome92ClientCache
OracleOraHome92HTTPServer
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
·Ö±ðÊÇ:
Agent´úÀí, OEMÈý²ã¹ÜÀíʱÓëOMS½øÐеǼǴ¦¹µÍ¨;
¿Í»§¶ËÐÅÏ¢Cache;
ÌṩWeb·þÎñ;
BP»ú֪ͨ·þÎñ,±ÈÈçÊý¾Ý¿âÓ ......
ÎÒÃÇ¿ÉÄÜÔÚOracle DB10g Öлᾳ£Óöµ½OEM²»ÄÜÕý³£Ê¹ÓõÄÎÊÌâ,µ¼ÖÂÎÊÌâµÄÔÒò²»¾¡Ïàͬ,
µ«×îºó¾ø´ó¶àÊýÎÊÌâ¿ÉÒÔͨ¹ýemca Õâ¸öÃüÁîÀ´½â¾ö,ÏêϸµÄ˵Ã÷¿ÉÒԲ鿴Á¬»ú°ïÖú,
ÏÂÃæ¸ø³öһЩ³£ÓõÄÃüÁî,¼°ÊµÀý²½Öè.
´´½¨Ò»¸öEM×ÊÁÏ¿â
emca -repos create
Öؽ¨Ò»¸öEM×ÊÁÏ¿â
emca -repos r ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- -- ......
OracleÈÕÆÚº¯Êý¼¯½õ(Ò»)
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
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_ch ......
SQL> with tt as
2 (
3 select 'haha' string from dual union
4 select '123' from dual union
5 select 'haha12' from dual union
6 select 'haha[]' from dual union
7 select '12@@' from dual union
8 select ......