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

oracle method

--single line method
select ascii('A') Big_A from dual;
select chr(65) A, chr(122) z, chr(223) ch3 from dual;
select concat('sigo','way') from dual;
select initcap('sigoway') from dual;
select instr('ababab','a',-1,2), instr('ababab','a',1,3) from dual;
select instrb('ababab','a',1,3) from dual;
select length('sigoway') from dual;
select lengthb('sigoway') from dual;
select upper('sigoway') , lower('SIGOWAY') from dual;
select lpad('Sigoway',10,'0'), lpad('Sigoway',5,'0') , rpad('Sigoway',10,'0'), rpad('Sigoway',5,'0') from dual;
select ltrim('Sigoway','Sigo'), rtrim('Sigoway','way') from dual;
select replace('Sigoway','go','og') from dual;
select substr('sigoway',3,2), substr('sigoway',3) from dual;
select soundex('hello') from dual;
select translate('Sigoway','og','ab') , translate('Sigoway','go','ab') from dual;
select trim(' sigoway ') from dual;
select abs(-1) from dual;
select acos(0.5), acos(1), acos(-1) from dual;
select cos(0.5), cos(1), cos(-1) from dual;
select asin(0.5), asin(1), asin(-1) from dual;
select sin(0.5), sin(1), sin(-1) from dual;
select ceil(-1) from dual;
select trunc(10.12345,4) ,round(10.12345,4)  from dual;
select to_char(round(sysdate), ' yyyy-mm-dd  hh24:mi:ss')
           ,to_char(trunc(sysdate), 'yyyy-mm-dd hh24:mi:ss')
 from dual;
select  to_char(Round (sysdate),  ' Q ' ) Rnd_Q
           ,to_char(Round (sysdate),  ' Month ' ) Rnd_Month
           ,to_char(Round (sysdate),  ' WW ' ) Rnd_Week
           ,to_char(Round (sysdate),  ' W ' ) Rnd_Week_again
           ,to_char(Round (sysdate),  ' DDD ' ) Rnd_day
           ,to_char(Round (sysdate),  ' DD ' ) Rnd


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracleϵͳ¹ÜÀíºÍϵͳ×ÊÁÏ»ñÈ¡µÄһЩ»ù±¾ÃüÁî

×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æÖ®Ê±.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ