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

oracle for update

³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿
ÊÂÎñ½áÊøºó½âËø

»òÕ߻Ự½áÊø£¬ÊÂÎñ×Ô¶¯½áÊø

³ÌÐò½áÊøÊ±£¬Ö»ÒªÁ¬½ÓÖжϣ¬Ôò»á»°×Ô¶¯½áÊø
Èç¹ûûÓÐÌá½»£¬×Ô¶¯»Ø¹ö

ÒýÓÃ
³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿


»áµÄ£¬Ó¦ÓóÌÐò½áÊøµÄʱºò£¬session¹Ø±Õ£¬¿Í»§¶ËÓëoracle·þÎñÁ¬½ÓÖжϣ¬ÕâÑùµÄ»°£¬ÊÂÎñ»á×Ô¶¯»Ø¹ö£¡

ÒýÓÃ
³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿


ÊÂÎñÖÕֹʱ½âËø£¬ÊÂÎñÖÕÖ¹£¬¿ÉÒÔÊÇÏÔʾµÄcommit£¬rollback¡£ »òÕßһЩ¶¯×÷»áÒþʽµÄÖÕÖ¹ÊÂÎñ£¬±ÈÈçsession¶Ïµô£¬»áÒþʽµÄrollback£¬ Ö´ÐÐÁËddlÓï¾ä »áÒþʽµÄcommit


Ïà¹ØÎÊ´ð£º

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

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

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

Oracle Ëø±í

ͨ¹ýPLSQL Developer½øÐÐÊý¾Ý²Ù×÷
1,select * from table1                  ¼ìË÷Õý³£
2,select * from table1 for update      ±íÖ±½ÓËÀËø,ÎÞ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ