oracle Êä³öÎÊÌ⣡
SQL> create table temp
2 ( tempid number
3 );
±íÒÑ´´½¨¡£
SQL> insert into temp(tempid)
2 values('111111111111111111111111111');
ÒÑ´´½¨ 1 ÐС£
SQL> select *
2 from temp;
TEMPID
----------
1.1111E+26
ÒÑÑ¡Ôñ 1 ÐС£
SQL> set numformat 9999999999999999999999.999999999999999999;
SQL> select *
2 from temp;
TEMPID
------------------------------------------
##########################################
ÎÒÊdzõѧÕß ,ÕâÊÇÔõô»ØÊ°¡£¡£¡ÊÇʲôûÓÐÉèÖÃÄØ??
°Ñ tempid µÄÀàÐ͸ÄΪ varchar2 ¾Í¿ÉÒÔÁ˵õ½ÄãÏñÒªµÄ½á¹ûÁË
Êý¾Ý£º111111111111111111111111111
¸ñʽ£º9999999999999999999999
¿É¼ûÕâÀï9µÄ¸öÊýÌ«ÉÙÁË£¬¸Ä³É£º9999999999999999999999999999999999999999999999(±È1µÄ¸öÊý¶à£©£¬¾ÍOKÁË
ͬÒâһ¥£¬½«×Ö¶ÎÀàÐ͸ÄΪ varchar2
SQL> set numf 9.9999EEEE
Õâ¸öÊDzéѯ¹¤¾ßµÄÎÊÌâ Èç¹ûʹÓÃob¾ÍûÕâÖÖÎÊÌâÁË object browser
set numformat 9999999999999999999999.999999999999999999;
Õâ¾ä¸Ä³É£º set numv 30 ¾ÍÐÐÁË£¡
kan kan
Êý¾ÝÀàÐ͵ÄÎÊÌâ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸö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
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......