Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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)


Ïà¹ØÎĵµ£º

oracleµÄ·ÖÒ³¼¼Êõ

      ֮ǰÔÚÏîÄ¿ÖÐÓõ½µÄ·ÖÒ³¶¼ÊǼٷÖÒ³£¬Ò²¾ÍÊÇÏÈ´ÓÊý¾Ý¿âÖаÑËùÓеÄÊý¾Ý¶¼²éѯ³öÀ´È»ºóÔÚ°ó¶¨Ê±½øÐзÖÒ³¡£ÕâÊÇÒ»ÖÖ¼Ù·ÖÒ³£¬Ð§Âʽϵͣ¬Ç°¼¸ÌìÌýÆäËûÏîÄ¿×é˵ËûÃÇҪʹÓÃÊý¾Ý¿âµÄ´æ´¢¹ý³ÌÀ´ÊµÏÖ·ÖÒ³£¬¸Ð¾õºÜÒÉ»ó£¬ÄѵÀʹÓÃÊý¾Ý¿â»¹¿ÉÒÔʵÏÖ·ÖÒ³¹¦ÄÜ£¿ÏÐÀ´ÎÞÊ£¬¾Í´ÓÍøÉÏËÑÁËËÑ×ÊÁÏ£¬¹ûÈ»£¬ÔÚoracl ......

ORACLE SQLÓÅ»¯ ORACLEÖ´Ðмƻ®

Last login: Mon Feb  8 14:13:19 2010 from 192.168.1.249
ipnet
-bash-3.00$
-bash-3.00$ ipnet
-bash: ipnet: command not found
-bash-3.00$ su - oracle
Password:
eastcsu: incorrect password
-bash-3.00$ eastcom
-bash: eastcom: command not found
-bash-3.00$ su - oracle
Password:
[oracl ......

Oracle ¹«²¼ Java ·¢Õ¹²ßÂÔ

¼×¹ÇÎÄÒѾ­Íê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄHotSpot ......

oracle 10g °²×°¹ý³Ì

ÔڵǼemµÄʱºò¡£
²é¿´Ò»Ï emctl status dbconsole
ÕÒµ½urlµØÖ·
ÔÚÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄʱºò³öÏÖ
oracle 10g remoteoperationexception error wrong password for user
¿ÉÒÔÔÚ
×é²ßÂÔ -- >±¾µØ²ßÂÔ -->Óû§È¨ÀûÖ¸. -- >×÷ΪÅú´¦Àí×÷ÒµµÇ¼ÖмÓÈëÕâ¸öÓû§
¼´¿É. ......

java¶àÏ̱߳£´æoracleµÄblob×Ö¶ÎÔÚ±¾µØÉú³ÉͼÏñ

ǰЩÈÕ×ÓÕÛÌÚµÄÔÚÏßÅÄÕÕ£¬ÓÉÓÚÖ»ÊǸüÐÂblob×ֶΣ¬Ã»ÓÐÔÚ±¾µØ±£´æÕÕÆ¬£¬µ¼Ö¿ͻ§ÅÄÄÔÃÅÏëÒªµÄʱºò²»ÄÜÂíÉÏÄóöÀ´¡£Ã»ËµµÄË­Èù˿ÍÊÇÉϵÛÄØ£¬×ö°É¡£Ê¹ÓÃÏ̳߳ش´½¨Èý¸öÏß³ÌÈÃ×Ô¶¨Ò»¸öÏß³ÌÄ¿±ê¹²Ïí£¨Ò²¾ÍÊǰѱíÀïµÄ¼Ç¼·Ö³Én×éͬʱִÐе¼³ö£©¡£³ÌÐòºÜ¼òµ¥£¬Ò»¹²ËĸöÀàºÍÒ»¸öojdbc14.jar°ü¡£ÓÉÓÚsqlÓï¾äд´íÁËÔì³É¶à¸öÏ̶߳ÔÒ»¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ