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 ѧϰÁË£¡ ѧϰÁË
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......