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)
---------- -----------------------
&
Ïà¹ØÎĵµ£º
[oracle@dba01 dbs]$ orapwd file=/oracle/app/oracle/product/10.2.0/db_1/dbs/orapworcl password=oracle entries=20 force=y
[oracle@dba01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 13:07:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Con ......
/*Ö÷ÒªÊÇΪÁË¿´ÇåÁ¬½ÓÂß¼£¬ËùÒÔ°ÑÒì³£Exception*/
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws Exception {
ResultSet rs = null;
Statement stmt = null;
......
µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ ......