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

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

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ×ÅʾÀý´úÂëд¶¼²»¶ÔÄØ£¿ÎÒ»¹ÏëÎʵÄÊÇÄܲ»ÄÜÔÚsqlplusÏÂÃæÓÃinsert²åÈëÕâÀàÐ͵ÄÊý¾ÝÄØ£¿Èç¹û¿ÉÒÔÔõÃ´Ð´ÄØ£¿Ð»Ð»£¬Çë¸ßÊÖÖ¸½Ì£¡
vc£¬ÎÒ²»ÖªµÀÐв»ÐС£Èç¹ûÄãÓÃjava£¬ÎҸҿ϶¨Äܹ»²Ù×÷lob¡£ÒòΪÒÔǰһ¸öÏîÄ¿¾ÍÓùý£¬µ«¼ÇµÃ ²»ÊǺͺÜÇå³þÁË¡£
ºÃÏñÓÃjava²Ù×÷´ó¶ÔÏóǰÏÈÒª²åÈëÒ»¸öoracleµÄemptyÀàÐÍ£¬È»ºóÔÙ¶ÔÆä½øÐÐÐ޸쬲¢ÇÒÒª²éѯ³öÏÈǰ²åÈëµÄempty¼Ç¼£¬²¢Ëø¶¨¸ÃÐУ¬È»ºóÔÙ²åÈëlob¡£


¾É°æ±¾µÄoracle£¬blobÐèÒªÏÈinsert Ò»¸ö empty blob£¬È»ºóÈ¡µ½¼Ç¼µÄID£¬È»ºóÔÙupdate¡£¡£¡£¡££¨javaÏ£©c²»»á²»¶®àÞ¡£¡£¡£

ÎÒÒ²ÊÇÏȲåÈë¿ÕµÄÔÙUpdateµÄ£¬µ«»¹ÊDz»Ðа¡£¬ÎÒÓõÄÊÇ11gµÄ£¬ÓÐûÓлáVCµÄ°¡£¿

Assembly code:
¾É°æ±¾µÄoracle£¬blobÐèÒªÏÈinsert Ò»¸ö empty blob£¬È»ºóÈ¡µ½¼Ç¼µÄID£¬È»ºóÔÙupdate¡£¡£¡£¡££¨javaÏ£©c²»»á²»¶®àÞ¡£¡£¡£


2Â¥µÄ½éÉÜÒ»ÏÂаæµÄoracleÊÇÔõô´¦ÀílobµÄ£¬Äã˵µÄаæÊÇ11gÂð£¿

¿ÉÒÔ°ÑCLOBÀàÐÍת³ÉVARCHAR2ÀàÐÍ
»ñÈ¡Îı¾ DBMS_LOB.SUBSTR(col1,n,pos)  
  ÈçDBMS_LOB.SUBSTR(col1,10,1)±íʾ´ÓµÚ1¸ö×Ö½Ú¿ªÊ¼È¡³ö10¸ö×Ö½Ú


ÒýÓÃ
Assembly code¾É°æ±¾µÄoracle£¬blobÐèÒªÏÈinsert Ò»¸ö empty blob£¬È»ºóÈ¡µ½¼Ç¼µÄID£¬È»ºóÔÙupdate¡£¡£¡£¡££¨javaÏ£©c²»»á²»¶®àÞ¡£¡£¡£

2Â¥µÄ½éÉÜÒ»ÏÂаæµÄoracleÊÇÔõÃ


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

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

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