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

ÏÖÔÚ¿´Ïà¹ØµÄRAC½á¹¹µÄÎÄÕ»¹²»Ì«Àí½â¡£
ÏÖÔÚ¿´Õâ¸ö¾ÍºÜÇå³þÆäÖеÄÒâ˼ÁË¡£
oracle clusterware Ö÷ÒªÓÐÒÔÏÂÖ÷Òª²¿¼þ£º
CSS: ¼¯ÈºÍ¬²½·þÎñ
Ö÷Òª¹ÜÀíÕû¸ö¼¯ÈºÄÚ¸÷¸ö½Úµã¼äµÄÇé¿ö£¬°üÀ¨½ÚµãµÄÌí¼ÓºÍ¼õÉÙ¡£ÓëÖ®¶ÔÓ¦µÄÊÇocssd ½ø³Ì£¬Èç¹û¸Ä½ø³Ì³öÏÖ¹ÊÕϽ«»áµ¼Ö½ڵãÖØÆô¡£Èç¹ûʹÓÃÁ˵ÚÈý·½µÄclusterware£¬css ͨ¹ýµÚÈý·½clus ......

ÔÚ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ѧϰ±Ê¼Ç16

PL/SQL
 
¿é½á¹¹
DECLARE
         ÉùÃ÷²¿·Ö
BEGIN
         ¿ÉÖ´Ðв¿·Ö
EXCEPTION
         Òì³£´¦Àí²¿·Ö
END;
 
Àý£º
Ê×ÏÈÎÒÃÇ¿´Ò»¸ö¼òµ¥Ö®Àý×Ó,ÏÂÃæÕâ¸öÀý×ÓÊÇͳ¼Æ´Ó1 ......

Oracle£º1 not in (null)¼ìË÷²»³ö½á¹û

in/not   inÔÚÅжÏNULLʱÓõÄÓë=/<>Ò»ÑùµÄ·½Ê½£¬¼´±ØÐëÓÃis   nullÀ´Åжϣ¬·ñÔòʼÖÕΪʧ°Ü¡£  
  Óï¾ä  
  select   'true'   from   dual   where   (1,2)   not   in   ((2,3),(2,null));  
  ³É¹¦µÄÔ­ÒòÔÚÓÚÅж϶þÔªÖµÊ±Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ