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

oracleÖеÄupdateÓï¾ä¸üжà¸ö×Ö¶Î

ÎÒÔÚÒ»¸ö±íµÄtriggerÖÐÓÃupdate bill_na set a1 = 's' ,a2 ='b' where ......
µ±ÎÒ´¥·¢Õâ¸ötriggerºó a1µÄÖµ±äΪ¡®s¡¯Ô­À´ÊÇ¡®a¡¯µ«ÊÇa2Öµ»¹'g',ÔÚwhereÌõ¼þÏ£¬
Ò²¾ÍÊÇ˵һ¸öÀ¸Î»¸üÐÂÁËÒ»¸öûÓУ¬²»ÖªµÀΪʲô£¬ÕâÑùÒ²ÄÜÌá½»Âð¡£

ÒýÓÃ
ÎÒÔÚÒ»¸ö±íµÄtriggerÖÐÓÃupdate bill_na set a1 = 's' ,a2 ='b' where ......
µ±ÎÒ´¥·¢Õâ¸ötriggerºó a1µÄÖµ±äΪ¡®s¡¯Ô­À´ÊÇ¡®a¡¯µ«ÊÇa2Öµ»¹'g',ÔÚwhereÌõ¼þÏ£¬
Ò²¾ÍÊÇ˵һ¸öÀ¸Î»¸üÐÂÁËÒ»¸öûÓУ¬²»ÖªµÀΪʲô£¬ÕâÑùÒ²ÄÜÌá½»Âð¡£

ÁíÒ»¸ö¿ÉÄÜÊÇ£¬Äã¸üÐÂÁË£°Ìõ¼Ç¼£¬Òª¸üÐÂa1ÁеÄÔ­ÖµÒÔǰ¾ÍÊÇ's'¡£

²»ºÃÒâ˼£¬²»ÊÇÎÒ¿´´íÁË£¬Ó¦¸ÃÊÇÆäËüµØ·½ÓиıäËüµÄÖµ¡£


Ïà¹ØÎÊ´ð£º

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

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ