Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄÏúÊÛÕæÐÄÕæÒâµÄÔ­ÒâÓë´ó¼Ò·ÖÏíoracleµÄÒ»ÇУ¬ÎÒÕâ±ß²»ÊÇÇþµÀ£¬ÊÇoracle×ÊÉî×Ü´úÀí£¨ÖйúÈí¼þÓë¼¼Êõ·þÎñ¹É·ÝÓÐÏÞ¹«Ë¾£©£¬Ï£Íû´ó¼ÒÓйºÂòoracleÒâÔ¸µÄʱºò¼ÇµÃÎÒ£¨ÕÔÌìÊæ   15010529916£©£¬ÎһᾡÎÒËùÄܵİïÖú´ó¼Ò¡£
   ×î½üÓкܶàÈËÎÊÎÒoracleµÄ¹ºÂò·½Ê½£ºÔÚÕâÀïÎÒÏë²ûÊöµÄÊÇÉÌÎñÉϵĹºÂò· ......

Oracle 10g´´½¨·ÖÇø±í¼°Ë÷Òý»¯±í

http://blog.sina.com.cn/s/blog_3fed8ad60100bydo.html
 1¡¢Ê×ÏÈÀûÓÃsystemÕÊ»§´´½¨ÐµķÖÇø£º
my_space1, my_space2(ÀûÓÃÍøÒ³¿ØÖÆÌ¨´´½¨±í¿Õ¼äÒÔ¼°ÓôúÂë´´½¨)¡£
ÔÚʵ¼Ê¹¤×÷ÖУ¬²»Í¬µÄÇø¿ÉÒÔλÓÚ²»Í¬µÄÎïÀí´ÅÅÌÖУ¬²ÅÓÐÕæÕý·ÖÇøµÄЧ¹û¡£
È»ºó£ºÓÃscottÕÊ»§´´½¨·¶Î§·ÖÇø±í£º
create table t1(
id number(5) pri ......

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

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

Oracle´æ´¢¹ý³Ì

 Oracle´æ´¢¹ý³Ì¹¦ÄÜÇ¿´ó£¬ËûÖ÷ÒªµÄ×÷ÓÃÓÐÒÔϼ¸µã:
1.¿ÉÒÔÅúÁ¿Ö´ÐÐsqlÓï¾ä£¬ÌṩÄÚÖõÄÊÂÎñÖ§³Ö£¬Í¬Ê±Äܹ»Ìá¸ßÊý¾Ý¿â²Ù×÷µÄЧÂÊ¡£
2.¿Í»§¶Ë³ÌÐòÒÀ¾Ý´æ´¢¹ý³ÌÃûÀ´µ÷Óã¬Ìṩ³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
3.Ìṩ¸´ÔÓµÄSQLÓï¾äÂß¼­Ö§³Ö¡£
Óï·¨½á¹¹°üÀ¨¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£
1£©²»´ø²ÎÊý£º
Create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ