Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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)  


Ïà¹ØÎĵµ£º

oracle merge into Ó÷¨Ïê½â


ת×Ô£ºhttp://hi.baidu.com/magus163/blog/item/a4f783178e39ef00c93d6de6.html
¡¾ÕâƪÎÄÕÂÀý×Ó½²½âµÄ±È½ÏÏêϸ£¬ÎÒ¾Íת¹ýÀ´ÁË¡¿
Oracle9iÒýÈëÁËMERGEÃüÁî,ÄãÄܹ»ÔÚÒ»¸öSQLÓï¾äÖжÔÒ»¸ö±íͬʱִÐÐinsertsºÍupdates²Ù×÷. MERGEÃüÁî´ÓÒ»¸ö»ò¶à¸öÊý¾ÝÔ´ÖÐÑ¡ÔñÐÐÀ´updating»òinsertingµ½Ò»¸ö»ò¶à¸ö±í.
Oracle 10gÖÐMERGEÓÐÈ ......

Oracle ϵͳ³£¼û´íÎó


p580  ÎÄƽ
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
    ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000ÄêÇ°ºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøҳǶÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡ ......

Oracleʱ¼ä¼ÆËã

ÈÕÆÚ¸ñʽ²ÎÊý   º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY    ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD   ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW   ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......

OracleÊý¾Ý¿â·ÖÇø±í²Ù×÷·½·¨


OracleÊý¾Ý¿â·ÖÇø±í²Ù×÷·½·¨
(2009-10-19 16:20:45)
±êÇ©£º
ÔÓ̸
 
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬ÄÜ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÖÜÏê½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£ÄÜ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁÄܵ½TB¼¶¡£ËäÈ»´æ´¢ ......

dzÎöoracleÊý¾Ý¿âµÄÓŵã


oracleÊý¾Ý¿âµÄÓŵãÒ»£º
ORACLE7.XÒÔÀ´ÒýÈëÁ˹²ÏíSQLºÍ¶àÏßË÷·þÎñÆ÷Ìåϵ½á¹¹¡£Õâ¼õÉÙÁËORACLEµÄ×ÊÔ´Õ¼Ó㬲¢ÔöÇ¿ÁËORACLEµÄÄÜÁ¦£¬Ê¹Ö®Ôڵ͵µÈíÓ²¼þƽ̨ÉÏÓýÏÉÙµÄ×ÊÔ´¾Í¿ÉÒÔÖ§³Ö¸ü¶àµÄÓû§£¬¶øÔڸߵµÆ½Ì¨ÉÏ¿ÉÒÔÖ§³Ö³É°ÙÉÏǧ¸öÓû§¡£
oracleÊý¾Ý¿âµÄÓŵã¶þ£º
ÌṩÁË»ùÓÚ½ÇÉ«(ROLE)·Ö¹¤µÄ°²È«±£ÃܹÜÀí¡£ÔÚÊý¾Ý¿â¹ÜÀí¹¦ÄÜ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ