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

ORACLEµÄ×Ö¶ÎÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ½¨±íµÄʱºò ÏëÔÚORACLEÖдæÈëÒ»¸ötextÎı¾ ÓÐ5000×ÖÒÔÉÏ ÒªÓÃʲôÀàÐÍ¿ÉÒÔ´æÈëvarchar2²»Ðа¡
CLOB »ò NCLOB ÀàÐÍ

CLOBÀàÐÍ



End_rbody_65102918//-->
¸Ã»Ø¸´ÓÚ2010-04-30 16:05:10±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








Adebayor
(°¢µÂ)

µÈ¡¡¼¶£º



#4Â¥ µÃ·Ö£º10»Ø¸´ÓÚ£º2010-04-30 22:28:35


ÒýÓÃ
ÎÒÔÚ½¨±íµÄʱºò ÏëÔÚORACLEÖдæÈëÒ»¸ötextÎı¾ ÓÐ5000×ÖÒÔÉÏ ÒªÓÃʲôÀàÐÍ¿ÉÒÔ´æÈëvarchar2²»Ðа¡

varchar2µÄ³¤¶ÈÓÐÏÞÖÆ ×î´ó32767×Ö½Ú
Ó¦¸ÃʹÓÃCLOBÀàÐÍ

clob¿ÉÒÔµÄ

CLOB

varchar2ÔÚ±íÖУ¬×î¶à´æ´¢4000¸ö×Ö½Ú£»ÔÚPLSQLÖУ¬¿ÉÒÔÓÐ32767¸ö×Ö½Ú


CLOBÀàÐÍ

ÒýÓÃ

CLOB

varchar2ÔÚ±íÖУ¬×î¶à´æ´¢4000¸ö×Ö½Ú£»ÔÚPLSQLÖУ¬¿ÉÒÔÓÐ32767¸ö×Ö½Ú


varchar2 ²¢²»ÊÇ×î¶à4000¸ö×Ö½Ú£¬Òª¿´ÄãµÄÊý¾ÝÒ³ÊǶàÉÙ£¿Èç¹ûÉèΪ256K,ÄÇôÄãµÄvarchar2×î¶à¿ÉÒÔ´ïµ½250¶àK,Ò²¾ÍÊÇ˵²»Äܳ¬¹ýÊý¾ÝÒ³µÄ´óС

colb

ѧϰÁË£¡

ѧϰÁË


Ïà¹ØÎÊ´ð£º

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 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ