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

oracle±£´æÐ¡ÊýµãǰΪ"0"µÄÎÊÌâ

 ÔÚ´¦ÀíÊý¾Ýʱ·¢ÏÖÒ»¸öÎÊÌ⣬Oracle¶ÔÓÚСÓÚ1µÄСÊý£¬Ð¡ÊýµãÇ°ÃæµÄ0ÊDz»ÏÔʾµÄ¡£
 
SQL> create table t1_number (num number);
Table created
 
SQL> insert into t1_number values(0.3268);
1 row inserted
 
SQL> insert into t1_number values(0.57965686);
1 row inserted
 
SQL> insert into t1_number values(52345234.5686);
1 row inserted
 
SQL> insert into t1_number values(4.552686);
1 row inserted
 
SQL> commit;
Commit complete
 
SQL> column num format 99999999999.9999999999999
SQL> select * from t1_number;
 
                       NUM
--------------------------
            .3268000000000
            .5796568600000
    52345234.5686000000000
           4.5526860000000
 
 
 
    ʹÓÃPL/SQL DEV¹¤¾ß²é¿´Ê±ÊÇÓÐÇ°ÃæµÄ0µÄ
    ͨ¹ýcolumn num format 000000000000.99999999999ÉèÖÃÒ²¿ÉÒÔÏÔÊ¾Ç°ÃæµÄ0
 
    µ«ÊÇÕâЩ¶¼Ö»ÊÇÏÔʾµÄ½á¹û£¬¶ø²»ÊÇÊý¾Ý¿â±£´æ½á¹û
 
SQL> column num format 00000000000.9999999999999
SQL> select * from t1_number;
 
                       NUM
--------------------------
 00000000000.3268000000000
 00000000000.5796568600000
 00052345234.5686000000000
 00000000004.5526860000000
 00000000005.2920000000000
 
SQL> select substr(num,1,1) from t1_number;
 
SU
--
.
.
5
4
5
 
    ¿ÉÒÔ¿´µ½£¬ÎÞÂÛÇ°Ãæ³öÏÖ¶àÉÙλ£¬Í¨¹ýsubstrº¯Êý»ñÈ¡µÄµÚһλÈÎÈ»ÊÇ'.'
 
 
    ÎÞÂÛÔõôת»»£¬Ö»Òª×îÖÕÊä³ö½á¹ûÊÇÊýÖµÐ͵ģ¬Ð¡Êýµã


Ïà¹ØÎĵµ£º

oracle ÒÆ¶¯¸ßˮλ£º

²é¿´±íµÄ´óС£»
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
Ê×ÏÈ
create table TEST_1228 as select * from user_tables;
insert into TEST_1228  select * from TEST_1228 ;
insert into TEST_1228  select * from TEST_1228 ;
i ......

OracleÊý¾Ý¿âÓαê

OracleÊý¾Ý¿âÓαêʹÓ÷½·¨
2009-12-30 15:27
SQLÊÇÓÃÓÚ·ÃÎÊOracleÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬ËüͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼­, ÏÂÃæÔÚ±¾ÎÄÖн«¶ÔÓαêµÄʹÓýøÐÐһϽ²½â,Ï£Íû¿ÉÒԺʹó¼Ò¹²Í¬Ñ§Ï°½ø²½¡£ 
¡¡¡¡Óαê×ÖÃæÀí½â¾ÍÊÇÓζ¯µÄ¹â±ê¡£ÓαêÊÇSQLµÄÒ»¸öÄڴ湤×÷Çø£¬ÓÉϵͳ»òÓû§ÒÔ±äÁ¿µÄÐÎ ......

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁе͍Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......

ORACLE LOB×Ö¶Î ²»ÄÜÓÃunion ²éѯ

lob×ֶβ»ÄÜ×ögroup   by£¬¶øunionÖÐÐèҪʹÓÃgroup   by¹ýÂ˵ôÖØ¸´¼Í¼£¬ËùÒÔ²»ÐР¡£ ÓÃunion  all¾Í¿ÉÒÔÁË¡£
Áí£ºunion ºÍ union allÇø±ð£º
       UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖØ¸´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖØ¸´µÄ¼Ç¼ÔÙ·µ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ