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

OracleÖа󶨱äÁ¿µÄÎÊÌâ

ÔÚ´¥·¢Æ÷µÄÓï·¨ÖУ¬create trigger trg¡­¡­when £¨new.id>3£© ÔÚÅж¨Ìõ¼þÖУ¬newÇ°Ãæ²»¼ÓðºÅ£¬¹â±È½ÏÁ½¸öÊýµÄÒýÓþͿÉÒÔÅжϴóСÁËÂð£¿ÄѵÀ²»ÊÇÓ¦¸Ã±È½ÏÖ¸ÏòµÄÖµÂð£¿
...²»ÊǺÜÃ÷°×Â¥Ö÷µÄÒâ˼
oracle ¹æ¶¨ÔÚ´¥·¢Æ÷()Ìõ¼þÀïµÄnewºÍoldÇ°²»ÄܼÓ:·ûºÅ

ÎÒÒ²²»ÊǺÜÃ÷°×LZµÄÒâ˼£¬ÎÒ¾õµÃÎÒÃdz£ÓõÄÊÇÐм¶´¥·¢Æ÷£¬¾ÍÊÇÿÐнøÐбȽϣ¬Ö»Òª·ûºÏÌõ¼þ¾Í´´½¨¸ÃÐеĴ¥·¢Æ÷£¬ÁíÍâÔÚwhenºóÃæµÄÀ¨ºÅÄÚ£¬newºÍold²»±Ø¼Ó:£¬µ«ÊÇÆäËûµÄµØ·½¶¼ÊÇÒª¼ÓµÄ£¬ÎÒÈÏΪÊÇÕâÑùµÄ

ÎÒ¾õµÃÕâÊÇÒ»ÖÖÓï·¨¸ñʽ°É!ÔÚ´¥·¢Æ÷µÄÍ·²¿¼´whenµÄÓï¾äÖеÄnewºÍoldÓë´¥·¢Æ÷ÌåÖеģºnew ºÍ£ºoldʵ¼ÊɽÊÇÒ»ÑùµÄ£¬Ö»ÊÇÔÚÍ·²¿²»ÓüÓðºÅ£¬¾ÍÊÇÕâÑùÒ»Öֹ涨¡£Ò²Ðí»¹ÓбðµÄÉîÒ⣬µ«ÖÁÉÙÕâÑùÀí½â»¹ÊÇ˵µÃ¹ýÈ¥µÄ¡£

ÔÚwhenºóÃæµÄÀ¨ºÅÄÚ£¬newºÍold²»±Ø¼Ó:£¬µ«ÊÇÆäËûµÄµØ·½¶¼ÊÇÒª¼Ó

ÎÒÈÏΪwhenÀïÃæÒ²Òª¼ÓðºÅ£¬ÕâÑù²ÅÊDZȽÏÁ½¸ö±äÁ¿µÄÖµ


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ