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

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ÖØ½¨ÃÜÂëÎļþ


[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 ......

JDBC ¼òµ¥µÄOracleÁ¬½Ó

/*Ö÷ÒªÊÇΪÁË¿´ÇåÁ¬½ÓÂß¼­£¬ËùÒÔ°ÑÒì³£Exception*/
import java.sql.*;
public class TestJDBC {
    public static void main(String[] args) throws Exception {
        ResultSet rs = null;
        Statement stmt = null;
  ......

Oracle µÈ´ýʼþ


µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ