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)
Ïà¹ØÎĵµ£º
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
select s.username,
decode(l.type,'TM','TABLE LOCK',
'TX','ROW LOCK',
& ......
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 ......
ǰ̨UI½ø³Ì£¨VC6±àд£©½«UTF-8ÖÐÎÄ·¢¸øºǫ́·þÎñ³ÌÐò£¨Linux GCC£©£¬ºǫ́ÔÙдÈëoracleÊý¾Ý¿â£¬È»ºóǰ̨ÔÙͨ¹ýºǫ́½«Êý¾ÝÈ¡³ö£¬²¢ÏÔʾ£»ºǫ́ûÓÐ×ö±à½âÂëת»»£¬Ç°Ì¨ÔòÔÚVCĬÈϵÄGBKÓëUTF-8Ö®¼ä×÷ת»»¡£
¿ªÊ¼Ê±ÏµÍ³³öÏÖÂÒÂ룬ºóÀ´Í¨¹ýÉèÖÃLinuxÒ»¸ö»·¾³±äÁ¿¡¢ÖØÆôºǫ́½ø³ÌÎÊÌâ½â¾ö£¨ÎÊÌâÊÇÔø¾³¢ÊÔ¹ý¸ü¸Ä¸Ã»·¾³±äÁ¿£¬µ«ÂÒÂëÒÀ ......
.Frm644 { display:none; }
¡¡¡¡1¡£ÒѾ¼ìÑéµÄÓï¾äºÍÒÑÔÚ¹²Ïí³ØÖеÄÓï¾äÖ®¼äÒªÍêȫһÑù
¡¡¡¡2¡£±äÁ¿Ãû³Æ¾¡Á¿Ò»ÖÂ
¡¡¡¡3¡£ºÏÀíʹÓÃÍâÁª½Ó
¡¡¡¡4¡£ÉÙ
Óöà²ãǶÌ×
¡¡¡¡5¡£¶àÓò¢·¢
¡¡¡¡
¡¡¡¡Óï¾äµÄÓÅ»¯²½ÖèÒ»°ãÓУº
¡¡¡¡1¡£µ÷ÕûsgaÇø£¬Ê¹µÃsgaÇøµÄÊÇÓÃ×îÓÅ¡£
¡¡
¡¡2¡£sqlÓï¾ä±¾ÉíµÄÓÅ»¯£¬¹¤¾ßÓÐexplain,sql trace ......