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

Oracle ¿ª·¢³£¼ûÎÊÌâ

 1£®Êýѧº¯Êý
¢Ù¾ø¶ÔÖµ 
l  S£ºselect abs(-1) value
l  O£ºselect abs(-1) value from dual
¢ÚÈ¡Õû(´ó) 
l  S£ºselect ceiling(-001) value 
l  O£ºselect ceil(-001)   value from dual
¢ÛÈ¡Õû£¨Ð¡£© 
l  S£ºselect floor(-001) value   
l  O£ºselect floor(-001) value from dual
¢ÜÈ¡Õû£¨½ØÈ¡£©
l  S£ºselect cast(-002 as int)   value  
l  O£ºselect trunc(-002) value from dual 
¢ÝËÄÉáÎåÈë
l  S£ºselect round(23456,4) value     23460
l  O£ºselect round(23456,4) value from dual 2346
¢ÞeΪµ×µÄÃÝ 
l  S£ºselect Exp(1) value          l  O£ºselect Exp(1) value from dual  
¢ßÈ¡eΪµ×µÄ¶ÔÊý
l  S£ºselect log(7182818284590451) value      
l  O£ºselect ln(7182818284590451) value from dual;  
¢àÈ¡10Ϊµ×¶ÔÊý
l  S£ºselect log10(10) value         
l  O£ºselect log(10,10) value from dual;   
¢áȡƽ·½
l  S£ºselect SQUARE(4) value   
l  O£ºselect power(4,2) value from dual  
¢âȡƽ·½¸ù l  S£ºselect SQRT(4) value   
l  O£ºselect SQRT(4) value from dual  
ÇóÈÎÒâÊýΪµ×µÄÃÝ
l  S£ºselect power(3,4) value      
l  O£ºselect power(3,4) value from dual  
È¡Ëæ»úÊý
l  S£ºselect rand() value  
l  O£ºselect sys.dbms_random.value(0,1) value from dual;
È¡·ûºÅ
l  S£ºselect sign(-8) value    -1
l  O£ºselect sign(-8) value from dual  -1
2£®ÊýÖµ±È½Ï
¢ÙÇ󼯺Ï×î´óÖµ l  S£ºselect max(value) value from 
    (select 1 value union
    select -2 value union
    select 4 value union
  &n


Ïà¹ØÎĵµ£º

SQLÓïÑÔ»ù´¡¿¼ºË(Ò»)(oracle)

 1.ÀûÓÃÏÂÃæµÄ½Å±¾´´½¨BOOK£¬READER ºÍ BORROW ±í£¬²¢Íê³ÉºóÃæµÄÁªÏµ¡£
CREATE TABLE BOOK(
    NO CHAR(8) PRIMARY KEY,
    TITLE VARCHAR2(50) NOT NULL,
    AUTHOR VARCHAR2(20) ,
    PUBLISH VARCHAR2(20),
    PUB_DA ......

oracle »Ö¸´±íµ½ÒÔǰµÄij¸ö״̬

 select * from sys.smon_scn_time;
--scn Óëʱ¼äµÄ¶ÔÓ¦¹ØÏµ
ÿ¸ô5·ÖÖÓ£¬ÏµÍ³²úÉúÒ»´Îϵͳʱ¼ä±ê¼ÇÓëscnµÄÆ¥Åä²¢´æÈësys.smon_scn_time±í¡£
select * from student as of scn 592258
¾Í¿ÉÒÔ¿´µ½ÔÚÕâ¸ö¼ì²éµãµÄ±íµÄÀúÊ·Çé¿ö¡£
È»ºóÎÒÃǻָ´µ½Õâ¸ö¼ì²éµã
insert into student  select * from student a ......

oracle ÊÓÆµ±Ê¼Ç3(insert¡¢update¡¢delete)

Ò»,INSERT
1.ΪÁ˲»´òÂÒÔ­À´µÄ±íµÄÊý¾Ý,ËùÒÔ±¸·ÝÔ­À´µÄÊý¾Ý.
create table emp2 as select * from emp
create table emp3 as select * from emp
create table dept2 as select * from dept
create table salgrade2 as select * from salgrade
2.²é¿´±íµÄÉè¼ÆÇé¿ö:desc dept2;±íʾ²é¿´±ídept2µÄÉè¼ÆÇé¿ö.
3.²åÈëÊý¾Ýµ ......

110¸öoracle³£Óú¯Êý×ܽá

 1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH ......

oracleË÷ÒýµÄÈÏʶ

 
 
   
 
       Ë÷Òý( Index )Êdz£¼ûµÄÊý¾Ý¿â¶ÔÏó£¬ËüµÄÉèÖúûµ¡¢Ê¹ÓÃÊÇ·ñµÃµ±£¬¼«´óµØÓ°ÏìÊý¾Ý¿âÓ¦ÓóÌÐòºÍDatabase µÄÐÔÄÜ¡£ËäÈ»ÓÐÐí¶à×ÊÁϽ²Ë÷ÒýµÄÓ÷¨£¬ DBA ºÍ Developer ÃÇÒ²¾­³£ÓëËü´ò½»µÀ£¬µ«±ÊÕß·¢ÏÖ£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ