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


×ܽáÁËÒ»ÏÂɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ­±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ­±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......

ORACLE 10 (¸¶Ê×ê¿)ѧϰ±Ê¼Ç µÚ2½Ú ÃüÁî¡£

ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......

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ÖеÄËùÓÐÈËÔ±,µ±È»Ò²¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ