oracleÖÐclobµÄÎÊÌâ
¡£netÖÐ
Êý¾Ý±íÖеÄÒ»¸ö×Ö¶Î clobÀàÐ͵ġ£¡£ÎÒ²åÈë×Ö·û´®¶àµÄʱºò£¬±¨×Ö·û¹ý¶àµÄÒì³£¡£
Ôõô½â¾ö¡£¡£Ð»Ð»
Äã°ÑÒª²åÈë¸Ã×ֶεÄÄÚÈÝ´æµ½Ò»¸ö±äÁ¿ÖУ¬È»ºóÔÙÓÃSQL²åÈë¡£
x:='.......................';
insert into tb(col) values (x);
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÏÖÓÐÒ»¸ö´æ·ÅÁ˿ռäÊý¾ÝµÄ±í£¬ÎÒÏëͨ¹ýsql³ÌÐò£¬°ÑÀïÃæµÄ×ø±êÐÅÏ¢¶Á³öÀ´£¬ÄÄλ°ïæ¸øÐ´¶Î³ÌÐò°É¡£
Çë°ÑÄãµÄ ±í½á¹¹¡¢²âÊÔÊý¾Ý¡¢ºÍ×îÖյĽá¹û Ìù³öÀ´£¬ÕâÑùÁýͳ£¬Ôõô°ïÄã¡£¡£¡£¡£
ÌùÊý¾ÝÉÏÀ´!
ÒýÓÃ
ÌùÊý¾ÝÉÏ ......
ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
s1 a b c
1 a a a
2 b b b
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......