oracle±£´æÐ¡ÊýµãǰΪ"0"µÄÎÊÌâ
ÔÚ´¦ÀíÊý¾Ýʱ·¢ÏÖÒ»¸öÎÊÌ⣬Oracle¶ÔÓÚСÓÚ1µÄСÊý£¬Ð¡ÊýµãÇ°ÃæµÄ0ÊDz»ÏÔʾµÄ¡£
SQL> create table t1_number (num number);
Table created
SQL> insert into t1_number values(0.3268);
1 row inserted
SQL> insert into t1_number values(0.57965686);
1 row inserted
SQL> insert into t1_number values(52345234.5686);
1 row inserted
SQL> insert into t1_number values(4.552686);
1 row inserted
SQL> commit;
Commit complete
SQL> column num format 99999999999.9999999999999
SQL> select * from t1_number;
NUM
--------------------------
.3268000000000
.5796568600000
52345234.5686000000000
4.5526860000000
ʹÓÃPL/SQL DEV¹¤¾ß²é¿´Ê±ÊÇÓÐÇ°ÃæµÄ0µÄ
ͨ¹ýcolumn num format 000000000000.99999999999ÉèÖÃÒ²¿ÉÒÔÏÔÊ¾Ç°ÃæµÄ0
µ«ÊÇÕâЩ¶¼Ö»ÊÇÏÔʾµÄ½á¹û£¬¶ø²»ÊÇÊý¾Ý¿â±£´æ½á¹û
SQL> column num format 00000000000.9999999999999
SQL> select * from t1_number;
NUM
--------------------------
00000000000.3268000000000
00000000000.5796568600000
00052345234.5686000000000
00000000004.5526860000000
00000000005.2920000000000
SQL> select substr(num,1,1) from t1_number;
SU
--
.
.
5
4
5
¿ÉÒÔ¿´µ½£¬ÎÞÂÛÇ°Ãæ³öÏÖ¶àÉÙλ£¬Í¨¹ýsubstrº¯Êý»ñÈ¡µÄµÚһλÈÎÈ»ÊÇ'.'
ÎÞÂÛÔõôת»»£¬Ö»Òª×îÖÕÊä³ö½á¹ûÊÇÊýÖµÐ͵ģ¬Ð¡Êýµã
Ïà¹ØÎĵµ£º
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
oracleÊý¾Ý¿âͨ¹ý¿ØÖÆÎļþ±£³ÖÊý¾Ý¿âµÄÍêÕûÐÔ£¬Ò»µ©¿ØÖÆÎļþ±»ÆÆ»µÊý¾Ý¿â½«ÎÞ·¨Æô¶¯£¬Òò´Ë½¨Òé²ÉÓöà·¿ØÖÆÎļþ»òÕß±¸·Ý¿ØÖÆÎļþµÄ·½·¨¡£
¿ØÖÆÎļþÊÇÊý¾Ý¿â½¨Á¢µÄʱºò×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÎļþ£¬Ö»ÄÜͨ¹ýʵÀý½øÐÐÐ޸ģ¬Èç¹ûÊÖ¶¯Ð޸ĵϰ»áÔì³É¿ØÖÆÎļþÓëÎïÀíÐÅÏ¢²»·ûºÏ£¬´Ó¶øµ¼ÖÂÊý¾Ý¿â²»ÄÜÕý³£¹¤×÷¡£
oracleÊý¾Ý¿âͨ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
Oracle 11gÓÚ2007Äê7ÔÂ11ÈÕÃÀ¹ú¶«²¿Ê±¼ä11ʱ£¨±±¾©Ê±¼ä11ÈÕ22ʱ£©Õýʽ·¢²¼£¬11gÊǼ׹ÇÎĹ«Ë¾30ÄêÀ´·¢²¼µÄ×îÖØÒªµÄÊý¾Ý¿â°æ±¾£¬¸ù¾ÝÓû§µÄÐèÇóʵÏÖÁËÐÅÏ¢ÉúÃüÖÜÆÚ¹ÜÀí£¨Information Lifecycle Management£©µÈ¶àÏС£
Ò»£®ÐÂÌØÐÔÌá¸Ù
1.Êý¾Ý¿â¹ÜÀí²¿·Ö
¡ôÊý¾Ý¿âÖØÑÝ(Database Replay)&nb ......