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

oracle cast() º¯ÊýÎÊÌâ

¹Ø¼ü×Ö: oracle cast() º¯ÊýÎÊÌâ
SQL> create table t1(a varchar(10));
Table created.
SQL> insert into t1 values ('12.3456');
1 row created.
SQL> select round(a) from t1;
  ROUND(A)
----------
        12
SQL> select round(a,3) from t1;
ROUND(A,3)
----------
    12.346
SQL> select cast(a as int) from t1;
CAST(AASINT)
------------
          12
SQL> select cast(a as number(8,4)) from t1;
CAST(AASNUMBER(8,4))
--------------------
             12.3456
=========================================================
cast ÊǽøÐÐÀàÐÍת»»µÄ, ¿ÉÒÔÕë¶Ô¸÷ÖÖOracleÊý¾ÝÀàÐÍ. Ð޸ĵÄÊÇÓû§µÄÊý¾ÝÀàÐÍ.
roundÖ»ÊÇÐ޸ĵÄÊý¾ÝÏÔʾ¸ñʽ. ¶ÔÊý¾Ý×öËÄÉáÎåÈë. ÀàËÆµÄº¯Êý»¹ÓÐceil(È¡´ËÊý¾ÝµÄ×îСÕûÊý). trunc( È¡Õûº¯Êý.)
¸´ÖÆÄÚÈݵ½¼ôÌù°å
´úÂë:
SQL> select round(12.45) round,trunc(12.45) trunc,ceil(12.45) ceil
  2  from dual
  3  /
     ROUND      TRUNC       CEIL
---------- ---------- ----------
        12         12         13
SQL> select round(12.54) round,trunc(12.54) trnc,ceil(12.54) ceil
  2  from dual
  3  /
     ROUND       TRNC       CEIL
---------- ---------- ----------
        13         12         13
SQL>


Ïà¹ØÎĵµ£º

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ


²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 Î´ÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
 
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ¢£¬
IOPS£º66
¶ÁÈ¡£º90MB/s
дÈ룺82MB/s
 
² ......

×ªÔØoracle rollupºÍcubeº¯ÊýʹÓÃÐĵÃ

ʹØCUBE ROLLUP GROUPING SETS£¨1£©
Ô­ÎÄÒý×Ô£º ¾ÛºÏÊÇÊý¾Ý²Ö¿âµÄ»ù´¡¡£ÎªÁËÌá¸ß¾ÛºÏµÄÐÔÄÜ¡£OracleÌṩÁËGroup By Ìõ¿îµÄÀ©Õ¹¡£
1£® CUBE, ROLLUPÀ©Õ¹
2£® 3¸ögroupingº¯Êý
3£® Grouping setÀ©Õ¹
CUBE ROLLUP ......

ÔÚOracleÖеÄÊ÷ÐβÙ×÷

ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by  pid = prior id
order siblings  by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.na ......

Oracle RAC ÐÞ¸Ä IP µØÖ·


 
IP µØÖ·×öÈçÏÂÐ޸ģº
Public IP 10.85.10.119/121    -- >  10.85.10.219/221
Privite IP 192.168.1.119/121   -- >  192.168.1.219/221
Virtual IP 10.85.10.122/123   --  ......

oracleÀïµÄextendµÄÒâ˼

oracleÀïµÄextendµÄÒâ˼
À©Õ¹ÒÑÖªµÄÊý×é¿Õ¼ä£¬Àý£º
DECLARE
TYPE CourseList IS TABLE OF VARCHAR2(10);
courses CourseList;
BEGIN
-- ³õʼ»¯Êý×éÔªËØ£¬´óСΪ3
courses := CourseList( 'Biol 4412 ', 'Psyc 3112 ', 'Anth 3001 ');
-- ΪÊý×éÔö¼ÓÒ»¸öÔªËØ£¬Êý×é´óСΪ4£¬Ä©Î²µÄÔªËØÎªNULL
courses.EXTEN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ