Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄº£Á¿´æ´¢¼¼Êõ

ÏÂÎçÈ¥²Î¼ÓÒ»¸öOracleÓйغ£Á¿Êý¾Ý´æ´¢¼¼ÊõµÄÅàѵ½²×ùÁË¡£
µØÖ·ÔÚ¹ãÖÝÊÐÁÖºÍÎ÷·101ºÅÌìºÓÇø¼Æ¾­´óÂ¥Î÷²àÈýÂ¥¡£
Åàѵ·¢Æð»ú¹¹Îª£º¹ãÖÝÖÐî£ÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾¡£
 
ÏÂÃæ¾Í¼òÒª×ܽáÒ»ÏÂËùÌýµ½µÄһЩ¶«Î÷£¬Ò²ËãÊÇѧµ½µÄÕâЩ¼¼Êõ¡£²»¹ýÓеĶ«Î÷²»ÖªµÀ×ܽáµÄ¶Ô²»¶Ô£¬ÔÝÇÒàñàðÍÌÔæ°É¡£
 
OracleµÄ´æ´¢¼¼Êõ
´óÌåÉÏ· ......

Oracle 9iµÄÊý¾ÝÀàÐÍ

 
 Oracle 9i¹²ÌṩÁË16ÖÖ±êÁ¿Êý¾ÝÀàÐÍ£¬Èç±í7.4Ëùʾ¡£
±í7.4 Oracle 9iµÄ±êÁ¿Êý¾ÝÀàÐÍ
Ãû³Æ
º¬Òå
Char
ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
varchar2
ÓÃÓÚÃèÊö±ä³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=4000×Ö½Ú
nchar
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
nvarchar2
ÓÃÀ´´æ´¢Un ......

Oracle´æ´¢¹ý³Ì

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