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)  
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://hi.baidu.com/magus163/blog/item/a4f783178e39ef00c93d6de6.html
¡¾ÕâƪÎÄÕÂÀý×Ó½²½âµÄ±È½ÏÏêϸ£¬ÎÒ¾Íת¹ýÀ´ÁË¡¿
Oracle9iÒýÈëÁËMERGEÃüÁî,ÄãÄܹ»ÔÚÒ»¸öSQLÓï¾äÖжÔÒ»¸ö±íͬʱִÐÐinsertsºÍupdates²Ù×÷. MERGEÃüÁî´ÓÒ»¸ö»ò¶à¸öÊý¾ÝÔ´ÖÐÑ¡ÔñÐÐÀ´updating»òinsertingµ½Ò»¸ö»ò¶à¸ö±í.
Oracle 10gÖÐMERGEÓÐÈ ......
p580 ÎÄƽ
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000ÄêÇ°ºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøҳǶÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡ ......
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......
OracleÊý¾Ý¿â·ÖÇø±í²Ù×÷·½·¨
(2009-10-19 16:20:45)
±êÇ©£º
ÔÓ̸
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬ÄÜ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÖÜÏê½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£ÄÜ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁÄܵ½TB¼¶¡£ËäÈ»´æ´¢ ......
oracleÊý¾Ý¿âµÄÓŵãÒ»£º
ORACLE7.XÒÔÀ´ÒýÈëÁ˹²ÏíSQLºÍ¶àÏßË÷·þÎñÆ÷Ìåϵ½á¹¹¡£Õâ¼õÉÙÁËORACLEµÄ×ÊÔ´Õ¼Ó㬲¢ÔöÇ¿ÁËORACLEµÄÄÜÁ¦£¬Ê¹Ö®Ôڵ͵µÈíÓ²¼þƽ̨ÉÏÓýÏÉÙµÄ×ÊÔ´¾Í¿ÉÒÔÖ§³Ö¸ü¶àµÄÓû§£¬¶øÔڸߵµÆ½Ì¨ÉÏ¿ÉÒÔÖ§³Ö³É°ÙÉÏǧ¸öÓû§¡£
oracleÊý¾Ý¿âµÄÓŵã¶þ£º
ÌṩÁË»ùÓÚ½ÇÉ«(ROLE)·Ö¹¤µÄ°²È«±£ÃܹÜÀí¡£ÔÚÊý¾Ý¿â¹ÜÀí¹¦ÄÜ ......