oracle ´¥·¢Æ÷
Create [or replace] trigger [ģʽ.]´¥·¢Æ÷Ãû
Before| after |instead of insert|delete|(update of ÁÐÃû)
{insert|delete|(update of ÁÐÃû) }
On ±íÃû|ÊÓͼ|ģʽÃû|Êý¾Ý¿âÃû
[for each row]
When Ìõ¼þ
PL/SQL¿é
˵Ã÷£º
For each rowµÄÒâÒåÊÇ£ºÔÚÒ»´Î²Ù×÷±íµÄÓï¾äÖУ¬Ã¿²Ù×÷³É¹¦Ò»Ðоͻᴥ·¢Ò»´Î£»²»Ð´µÄ»°£¬±íʾÊÇ±í¼¶´¥·¢Æ÷£¬ÔòÎÞÂÛ²Ù×÷¶àÉÙÐУ¬¶¼Ö»´¥·¢Ò»´Î(ÈçÒ»´Îupdate »á¸üжàÌõÊý¾Ý,µ«ÊÇÖ»Ö´ÐÐÒ»´Î)£»
WhenÌõ¼þµÄ³öÏÖ˵Ã÷ÁË£¬ÔÚDML²Ù×÷µÄʱºòÒ²ÐíÒ»¶¨»á´¥·¢´¥·¢Æ÷£¬µ«ÊÇ´¥·¢Æ÷²»Ò»¶¨»á×öʵ¼ÊµÄ¹¤×÷£¬±ÈÈçwhen ºóµÄÌõ¼þ²»ÎªÕæµÄʱºò£¬´¥·¢Æ÷Ö»ÊǼòµ¥µØÌø¹ýÁËPL/SQL¿é£»
ÆäÖÐÖ»ÓÐupdate ¿ÉÒÔÖ¸¶¨ÁÐÃû.
instead of ÊÇÔÚÊÓͼÉ϶¨ÒåµÄ´¥·¢Æ÷,ÇÒÖ»ÄÜÔÚÐм¶´¥·¢Æ÷ÀïÃæÊ¹ÓÃ.ÒòΪÊÓͼ¶Ô±íµÄÔöɾ¸ÄÖ»ÄÜ»ùÓÚµ¥±í,ʹÓýÏÉÙ.
On ±íÃû|ÊÓͼ|ģʽÃû|Êý¾Ý¿âÃû °´ÕÕ¶ÔÏó²»Í¬,ÓÖ¿É·ÖΪģʽ´¥·¢Æ÷(ģʽÃû),Êý¾Ý¿â´¥·¢Æ÷(database)
Ïà¹ØÎĵµ£º
´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶¨ ......
½ñÌìͬÊÂÓöµ½ÁËÒ»¸öÎÊÌ⣬ÔÒòÊÇrownumµÄÎÊÌâ¡£
ÏÂÃæ×ªÒ»ÆªÎÄÕ£º
¶ÔÓÚOracleµÄrownumÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>£¬>=£¬=£¬between……and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ£¨<¡¢& lt;=¡¢£¡=£©£¬²¢·Ç˵ÓÃ>£¬>=£¬=£¬between……and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖË ......
Oracle Database 11g A Beginner's Guide
Oracle Database 11g SQL
Oracle Database 11g SQL: Tuning Work Shop
Oracle Database 11g SQL: Tuning Work Shop Practices and Solutions
Oracle Essentials: Oracle D ......
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó ......
HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨È ......