¹ØÓÚOracle ½Ì³Ì
ÄÇλÓÐOracle 10g µÄÊÓÆµ½Ì³Ì°¡,¹²Ïíһϣ¬Ð»Ð»ÁË
ÍøÉÏÓÐС²¼ÀÏʦµÄOracle ÊÓÆµ½Ì³Ì. ¾Ý˵²»´í.
ÎÒ»¹ÊDZȽÏϲ»¶¿´Êé..
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
С²¼²¥¿Í,
WWW.BOOBOOKE.COM
Hi,
[url=http://www.gougou.com/][/url]
ÊäÈëoracle ÊÓÆµ½Ì³Ì
¼ÇÏÂѧϰÏÂ~ http://www.boobooke.com/bbs/index.php
ҪʲôÊÓÆµ½Ì³ÌÁË£¬Âò±¾ºÃÊ飬×Ô¼ºµçÄÔ×°¸ö¶Ô×ÅÊ鯴ÃüÇÃÃüÁ
ΨһµÄÒź¶ÊÇû°ì·¨¶ÍÁ¶Ð§ÂʵÄÎÊÌ⣬ÒòΪûÓÐÄÇô´óÊý¾ÝÁ¿µÄ¿â
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......