oracle internal number Êý¾ÝÀàÐÍ´æ´¢
ת×Ô£ºhttp://ilonng.blog.sohu.com/130335741.html
oracleµÄnumberÀàÐÍÊÇÒ»ÖÖÈí¼þÊý¾ÝÀàÐÍ£¬ÔÚoracleÈí¼þ±¾ÉíÖÐʵÏÖ£¬ÎÒÃDz»ÄÜʹÓùÌÓÐÓ²¼þ²Ù×÷½«Á½¸önumberÀàÐÍÏà¼Ó£¬ÕâÒªÔÚÈí¼þÖÐÄ£Ä⣬number ÀàÐ͵ÄÄÚ²¿±àÂëÊÇ2¡£oracle´æ´¢Ò»¸öÊýµÄʱ£¬»á´æ´¢¾¡¿ÉÄÜÉÙµÄÄÚÈÝÀ´±íʾÕâ¸öÊý£¬Îª´ËËü»á´æ´¢ÓÐЧÊý×Ö¡¢ÓÃÓÚÖ¸¶¨Ð¡ÊýµãλÖõÄÒ»¸öÖ¸Êý£¬ÒÔ¼°ÓйØÊýÖµ·ûºÅµÄÐÅÏ¢£¨Õý»òÕ߸º£©¡£Òò´Ë£¬ÊýÖаüº¬µÄÓÐЧÊý×ÖÔ½¶à£¬Õ¼ÓõĴ洢¿Õ¼ä¾ÍÔ½´ó¡£
oracleµ×²ã´æ´¢numberÀàÐͲÉÓÃÏÂÃæµÄÕâÖÖÐÎʽ£º
sign bit/exponent,digit1,digit2,…,digit20
sign bit/exponentΪ±ê־룬digit1...digit20ΪÊýֵ룬¿É¼ûnumber×î¶àÕ¼¾Ý21¸ö×Ö½Ú¡£
Ò»¸öÊýÊÇ¿ÉÒÔʹÓÿÆÑ§¼ÆËã·¨À´ÕýÈ·±íʾµÄ£¬Èç10=1*power(10,1)£¬-101=-1.01*power(10,2)£¬0.2=2*power(10,-1)¡£oracle¾ÍÊÇͨ¹ýÕâ¸öÔÀíÀ´´æ´¢Êý¾Ý£¬Ëü½«ÈκÎÒ»¸öËü¿ÉÒÔ±íʾµÄÊý¾Ýת»»³ÉÒ»¸ö·ûºÅλ¡¢Ò»¸öÖ¸Êý¡¢Ò»¸öÓÐЧÊýÀ´´æ´¢£¬¾Ù¸öÀý×Ó£¬123ÔÚoracleÖÐÊÇÕâÑùÀ´´æ´¢µÄ£¬+(1.23*power(100,1))£¬¼´ËüÊÇÒÔ100Ϊ¿ÆÑ§¼ÆËã·¨µÄÖ¸Êý»ùÊý£¬ÎªÊ²Ã´ÕâÑùÒÔ¼°ÔõôÀ´´æ´¢£¬Çë¿´ÏÂÃæ¡£
´æ´¢Êý¾ÝµÄµÚÒ»¸ö×Ö½ÚÊDZê־룬Õâ¸ö×Ö½ÚÀïÃæ»á·´Ó³³öÕâ¸öÊý×ֵķûºÅλÒÔ¼°±íʾÕâ¸öÊý×ÖµÄÖ¸ÊýµÄ·ûºÅλ¡£²ÉÓÿÆÑ§¼ÆÊý·¨£¬ÈκÎÒ»¸öʵÊýS¶¼¿ÉÒÔÃèÊöΪA.B×power(100,N)£¬A±íʾÕûÊý²¿·Ö£¨¿ÉÄÜÊÇÕýÊý£¬¿ÉÄÜÊǸºÊý£©£¬B±íʾСÊý²¿·Ö£¬¶øN±íʾ10µÄÖ¸Êý²¿·Ö¡£ÄÇôoracleÔõôÓÃÒ»¸ö×Ö½ÚÀ´±íʾÕâЩÐÅÏ¢ÄØ£¿
1¡¢ÄÃÕâ¸ö×Ö½ÚµÄ×î¸ßλÀ´±íʾÕý¸º£¬0±íʾ¸ºÊý£¬1±íʾÕýÊý¡£Óɴ˿ɼû£¬Õâ¸öÊý×ÖÔÚ128Õâ¸ö²¿·Ö±»Ò»ÇÐΪ2·Ý£¬Èç¹ûÕâ¸öÊý×Ö´óÓÚ128£¬ÄÇôÕâ¸öÊý¾ÍÊÇÕýÊý£¬Èç¹ûÕâ¸öÊý×ÖСÓÚ128£¬ÄÇôÕâ¸öÊý×Ö¾ÍÊǸºÊý£¬Èç¹ûÕâ¸öÊý×ÖµÈÓÚ128£¬ÄÇôÕâ¸öÊý×Ö¾ÍÊÇ0£¬È磺
15:16:24 WATER@ lake>select 1,dump(1) from dual;
1 DUMP(1)
---------- ------------------
1 Typ=2 Len=2: 193,2
ÕâÀïµÄµÚÒ»¸ö×ֽڵıê־λÊÇ193£¬´óÓÚ128£¬¹ÊÆäΪÕýÊý£¬ÁíÍâ¿ÉÒÔ¿´µ½£¬ÕâÀﻹÓиöÆ«ÒÆÁ¿Îª65£¬193=128+65+0¡£
15:16:30 WATER@ lake>select -1,dump(-1) from dual;
-1 DUMP(-1)
---------- -----------------------
&
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
oracle ÖÁ½ñûÓÐÍÆ³öÕë¶Ôwin7µÄ°æ±¾£¬ÎÞÄÎ֮ϲéÑ¯ÍøÂç£¬ÍøÉÏ´óϺ±íʾÐÞ¸Ärefhost.xmlÎļþ¼´¿É¡£
½øÈë×Ô¼ºÊµÕ½½×¶Î£¬´Óoracle¹Ù·½ÏÂÔØoracle 10g for vista and windows2K8 x86°æ(for windowsÊÇÖ§³ÖvistaÄں˵ģ¬win7µÄÄÚºËÓë2008ÒÔ¼°vistaµÄÄÚºËÊÇÒ»Ñù)¡£
Ïȵã»÷°²×°£¬ÔÚ°²×°µÄ°æ±¾¼ì²âʱÌáʾĿǰoracle²»Ö§³ÖversionΪ6 ......
ORACLEµÄ¿ØÖÆÎļþÊÇÊý¾Ý¿âµÄ·Ç³£ÖØÒªµÄÎļþ£¬Ëü±£´æ×ÅÊý¾Ý¿âµÄÁ¬½ÓʵÀý(instance)ºÍdatabaseµÄÒ»¸öÇÅÁº£¬Ëü¶¨ÒåÁ˵±Ç°Êý¾Ý¿âÎïÀíÐÅÏ¢µÄ״̬¡£Òò´Ë¿ØÖÆÎļþ¶ÔÓÚÒ»¸öÊý¾Ý¿âÀ´ËµÊǷdz£ÖØÒªµÄ£¬ÔÚijЩʱºòÎÒÃÇÐèÒªÖØÐ´´½¨¿ØÖÆÎļþ£º
1¡£µ±¿ØÖÆÎļþ¶ªÊ§µÄʱºò£¬²¢ÇÒûÓÐ×î½üµÄÎļþCopy±¸·Ý£¨Ò»°ãÔÚ½¨¿âÍê³ÉºóµÄÉú³ÉÒ»¸ö´´½¨Con ......
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
¡¡¡¡ÒÔsystemÉí·ÝµÇ½Êý¾Ý¿â£¬²é¿´ v$optionÊÓͼ£¬Èç¹ûÆäÖÐPartitionΪTRUE£¬ÔòÖ§³Ö·ÖÇø¹¦ÄÜ£»·ñÔò²»Ö§³Ö¡£PartitionÓлùÓÚ·¶Î§¡¢¹þÏ£¡¢×ÛºÍÈýÖÖÀàÐÍ¡£ÎÒÃÇÓõıȽ϶àµÄÊǰ´·¶Î§·ÖÇøµÄ±í¡£
¡¡¡¡ÎÒÃÇÒÔÒ»¸ö2001Ä꿪ʼʹÓõÄÁôÑÔ°æ×öÀý×Ó½²Êö·ÖÇ ......
µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ ......