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

oracleµÄÊý¾Ý¿â½á¹¹£¿

¸Õ½Ó´¥oracle£¬ÓеãÃÉ
ÒÔǰÔÚ×öÍøÕ¾µÄʱºò£¬ÓÃsql2000,¸ø¿Í»§½¨Á¢Ò»¸öÊý¾Ý¿â,data1,Ö®ºó½¨Á¢Ò»¸öÓû§user1£¬°Ñdata1µÄȨÏÞ¸øuser1ºó£¬¾Í¿ÉÒÔÁ˵Ä
½á¹¹ÊÇ£ºÊý¾Ý¿â(date1)
                ±í tab1
                  ×Ö¶Î id,username,pwd,levels,Tusername
                ±í news
                  ×Ö¶Î id,title,infos,content
                ±í partd
                  ×Ö¶Î id,partd,title

ÊÇÕâÑùµÄ½á¹¹¿´×Åͦ·½±ãµÄ

×öoracleµÄʱºò£¬±ðÈ˺ÍÎÒ˵ûÓÐÊý¾Ý¿â£¬¶¼ÊÇÓû§£¿
¸øÎҵĸоõÊÇ£º
ÏȽ¨Á¢Ò»¸öÓû§Ouser1
Ö®ºóÔÚÕâ¸öÓû§Ï½¨Á¢±íOtab1
                      ×Ö¶Î id,username,pwd,levels,Tusername
                    ±í news
                      ×Ö¶Î id,title,infos,content
ÊÇÕâÑùµÄÂð£¿
»¹Óбí¿Õ¼ä

ËùÓÐµÄ±í¶¼ÔÚ±í¿Õ¼äÀ֮ºóÓû§¹ÜÀí±í¿Õ¼ä£¿
ÄÇÕâ¸ö ±í¿Õ¼ä ÊDz»ÊǾÍÊÇÊý¾Ý¿âµÄ¸ÅÄҲÊÇÒª ÏȽ¨Á¢±í¿Õ¼ä£¬Ö®ºó ²ÅÄܽ¨Á¢±í£¿



oracleÊý¾Ý¿âÊÇÖ¸Ò»×éλÓÚ´ÅÅÌÉϵÄÊý¾ÝÎļþµÄ¼¯ºÏ
oracleʵÀýÊÇÖ¸Ò»×éºǫ́½ø³ÌºÍÒ»×éÄÚ´æ×é¼þ


Ïà¹ØÎÊ´ð£º

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ