ORACLE NUMBERÀàÐÍÏê½â
1>.NUMBERÀàÐÍϸ½²£º
Oracle number datatype Óï·¨£ºNUMBER[(precision [, scale])]
¼ò³Æ£ºprecision --> p
scale --> s
NUMBER(p, s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+126
±£´æÔÚ»úÆ÷ÄÚ²¿µÄ·¶Î§£º 1 ~ 22 bytes
ÓÐЧΪ£º´Ó×ó±ßµÚÒ»¸ö²»Îª0µÄÊýËãÆðµÄλÊý¡£
sµÄÇé¿ö£º
s > 0
¾«È·µ½Ð¡ÊýµãÓÒ±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ <= p¡£
s < 0
¾«È·µ½Ð¡Êýµã×ó±ßs룬²¢ËÄÉáÎåÈ롣Ȼºó¼ìÑéÓÐЧλÊÇ·ñ <= p + |s|¡£
s = 0
´ËʱNUMBER±íʾÕûÊý¡£
eg:
Actual Data Specified As Stored As
----------------------------------------
123.89 NUMBER 123.89
123.89 NUMBER(3) 124
123.89 NUMBER(6,2) 123.89
123.89 NUMBER(6,1) 123.9
123.89 NUMBER(4,2) exceeds precision (ÓÐЧλΪ5, 5 > 4)
123.89 NUMBER(6,-2) 100
.01234 NUMBER(4,5) .01234 (ÓÐЧλΪ4)
.00012 NUMBER(4,5) .00012
.000127 NUMBER(4,5) .00013
.0000012 NUMBER(2,7) .0000012
.00000123 NUMBER(2,7) .0000012
1.2e-4 NUMBER(2,5) 0.00012
1.2e-5 NUMBER(2,5)  
Ïà¹ØÎĵµ£º
ÎÊÌâÃèÊö£º
µ±Êý¾Ý¿âµÄ×Ö·û¼¯ÎªÖÐÎÄʱ£¬timestampÀàÐ͵Ä×Ö¶ÎΪÒÔϸñʽ£º
04-3ÔÂ -10 03.57.41.631000 ÏÂÎç
ÎÒÔÚÓÃJDOM½«Êý¾Ýµ¼³öΪXMLʱ£¬timestampÀàÐÍ×ֶεÄÖµ·´ÉúÁ˱仯£¬±ä³ÉÁËһϸñʽ
<CREATE_DATE>2010-3-4.15.57. 30. 505000000</CREATE_DATE>
½â¾ö·½°¸£º
ÔÚ²éѯ¸Ã×Ö¶ÎʱÊ×ÏÈÓÃto_char£¨£©º¯Êý½ ......
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......
ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
1¡¢ÎﻯÊÓͼµÄÀàÐÍ£ºON DEMAND¡¢ON COMMIT
&n ......
Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in&nb ......