Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³£¼ûÎÊÌâ

´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ¡£
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡ ......

Oracle¸ß¼¶¼¼ÇÉ

1.ÔÚɾ³ýÒ»¸ö±íÖеÄÈ«²¿Êý¾Ýʱ£¬ÐëʹÓÃTRUNCATE TABLE ±íÃû;ÒòΪÓÃDROP TABLE£¬DELETE * from ±íÃûʱ£¬TABLESPACE±í¿Õ¼ä¸Ã±íµÄÕ¼Óÿռ䲢δÊÍ·Å£¬·´¸´¼¸´ÎDROP£¬DELETE²Ù×÷ºó£¬¸ÃTABLESPACEÉϰÙÕ׵Ŀռä¾Í±»ºÄ¹âÁË¡£
¡¡¡¡
¡¡¡¡2.having ×Ó¾äµÄÓ÷¨
¡¡¡¡
¡¡¡¡having ×Ó¾ä¶Ô group by ×Ó¾äËùÈ·¶¨µÄÐÐ×é½øÐпØÖÆ,having ×Ó ......

ORACLE ALERT

Oracle EBS AlertÔÚOracle EBSÖÐÓ¦Ó÷dz£¹ã·º,Ö÷Òª¼¯ÖÐÔÚ¶¨ÆÚ֪ͨºÍÌáÐÑ,ʼþÀàµÄ֪ͨºÍÌáÐÑ,ÀýÈç:
1)ij¸öÖ°Ô±¹ýÉúÈÕ,µ«ÊÇÈËÁ¦×ÊÔ´²¿ÃÅÏ£Íû·¢¸ö×£ºØµÄÓʼþ,¾Í¿ÉÒÔͨ¹ýAlert½øÐÐ֪ͨףºØ;
2)ÔÚDBA¼ì²âϵͳÊÇ·ñÕý³£ÔËתµÄ¹ý³ÌÖÐ,Èç¹ûij¸ö±í¿Õ¼ä¿ìÂúÁË,¿ÉÒÔ½¨Á¢Alert½øÐÐ֪ͨ¹ÜÀíÔ±;
3)¿ÉÒÔ½øÐÐÌáÐÑEBSÖеÄËùÓÐÈËÔ±,µ±È»Ò²¿ ......

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ºÅ