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

ORACLE´¦ÀíÈÕÆÚ´óÈ«

ÔÚoracleÖд¦ÀíÈÕÆÚ´óÈ«
  TO_DATE¸ñʽ  
Day:  
dd number 12  
dy abbreviated fri  
day spelled out friday  
ddspth spelled out, ordinal twelfth  
Month:  
mm number 03  
mon abbreviated mar  
month spelled out march  
Year:  
yy two digits 98  
yyyy four digits 1998  
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59....  
12Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 1:00:00 - 12:59:59 ....  
1.  
ÈÕÆÚºÍ×Ö·ûת»»º¯ÊýÓ÷¨£¨to_date,to_char£©  
2.  
select to_char( to_date(222,'J'),'Jsp') from dual  
ÏÔʾTwo Hundred Twenty-Two  
3.  
ÇóijÌìÊÇÐÇÆÚ¼¸  
select to_char(to_date('2002-08-26','yyyy-mm-dd'),'day') from dual;  
ÐÇÆÚÒ»  
select to_char(to_date('2002-08-26','yyyy-mm-dd'),'day','NLS_DATE_LANGUAGE = American') from dual;  
monday  
ÉèÖÃÈÕÆÚÓïÑÔ  
ALTER SESSION SET NLS_DATE_LANGUAGE='AMERICAN';  
Ò²¿ÉÒÔÕâÑù  
TO_DATE ('2002-08-26', 'YYYY-mm-dd', 'NLS_DATE_LANGUAGE = American')  
4.  
Á½¸öÈÕÆÚ¼äµÄÌìÊý  
select floor(sysdate - to_date('20020405','yyyymmdd')) from dual;  
5. ʱ¼äΪnullµÄÓ÷¨  
select id, active_date from table1  
UNION  
select 1, TO_DATE(null) from dual;  
×¢ÒâÒªÓÃTO_DATE(null)  
6.  
a_date between to_date('20011201','yyyymmdd') and to_date('20011231','yyyymmdd')  
ÄÇô12ÔÂ31ºÅÖÐÎç12µãÖ®ºóºÍ12ÔÂ1ºÅµÄ12µã֮ǰÊDz»°üº¬ÔÚÕâ¸ö·¶Î§Ö®Äڵġ£  
ËùÒÔ£¬µ±Ê±¼äÐèÒª¾«È·µÄʱºò£¬¾õµÃto_char»¹ÊDZØÒªµÄ  
7. ÈÕÆÚ¸ñʽ³åÍ»ÎÊÌâ  
ÊäÈëµÄ¸ñʽҪ¿´Äã°²×°µÄORACLE×Ö·û¼¯µÄÀàÐÍ, ±ÈÈç: US7ASCII, date¸ñʽµÄÀàÐ;ÍÊÇ: '01-Jan-01'  
alter system set NLS_DATE_LANGUAGE = American  
alter session set NLS_DATE_LANGUAGE


Ïà¹ØÎĵµ£º

Oracle trunc º¯ÊýµÄʹÓÃ

OracleµÄtrunc º¯ÊýÒ»°ãÓÃÀ´ ¶ÔÈÕÆÚºÍʱ¼ä½øÐнØÈ¡¡£
 
1¡¢Êý×Ö´¦Àí ¡£½ØÈ¡
 
 select trunc(5.75),trunc(5.75,1),trunc(5.75,-1),trunc(556.234,-2) from dual;
 
 
Êä³ö:
TRUNC(5.75) TRUNC(5.75,1) TRUNC(5.75,-1) TRUNC(556.234,-2)
----------- ------------- -------------- ----- ......

oracleÉèÖÃSGA

Ê×ÏÈÒÔsysdbaÉí·ÝµÇ¼
sqlplus connect system/orcl as sysdba;
È»ºóÐ޸IJÎÊý
1.sga_target²»ÄÜ´óÓÚsga_max_size£¬¿ÉÒÔÉèÖÃΪÏàµÈ¡£
2.SGA¼ÓÉÏPGAµÈÆäËû½ø³ÌÕ¼ÓõÄÄÚ´æ×ÜÊý±ØÐëСÓÚ²Ù×÷ϵͳµÄÎïÀíÄÚ´æ¡£
alter system set sga_target=150M scope=spfile;
alter system set sga_max_size=150M scope=spfile;
//Êý¾Ý¿â ......

ORACLEµÝ¹éͳ¼ÆËùÓÐ×ÓËï»ú¹¹£¡

select bid from t_branch c start with c.upbid  ='11000000'  connect by prior c.bid=c.upbid
˵Ã÷£º
1¡¢Í³¼ÆÄ³¸ö»ú¹¹ÏÂËùÓеÄ×ÓËï»ú¹¹¡£Èçͳ¼Æ±±¾©»ú¹¹ÏµÄ×ÓËï»ú¹¹£¬°üÀ¨£º³¯ÑôÇø»ú¹¹¡¢º£µíÓªÏú»ú¹¹¡¢¡¢¡¢ÇàÁúÇÅÏç»ú¹¹¡¢¡¢¡¢¡¢Ò»Ö±µ½×îµ×²ãµÄ»ú¹¹¡£
2¡¢upbidÊÇÖ¸Éϼ¶»ú¹¹µÄID¡£º£µíÇø»ú¹¹ID(bid)µÄÉϼ¶»ú ......

×Ô¶¯Íê³ÉOracle¿Í»§¶ËµÄ°²×°¼°ÆäÅäÖÃ


¡¡¡¡Ò»¡¢ÎÊÌâµÄÌá³ö
¡¡¡¡Ä¿Ç°µÄºÜ¶àÊý¾Ý¿âÓ¦ÓóÌÐòÊÇʹÓÃORACLEÊý¾Ý¿â¿ª·¢µÄclient/serverģʽ¡£ÖÚËùÖÜ
Öª£¬Ê¹ÓôËÖÖģʽÐèÒªÔÚÖÕ¶ËÉϰ²×°ORACLE¿Í»§¶ËÈí¼þ¡£Ó¦ÓóÌÐò¿ÉÒÔʹÓÃInstallShieldÈí¼þ´ò°ü³É°²×°³ÌÐò£¬ÓÉÓû§×ÔÐа²×°¡£µ«
ORACLE¿Í»§¶ËÈí¼þÒ»°ãÐèÒªÓо­ÑéµÄ¿ª·¢ÈËԱͨ¹ýÈË»ú½»»¥µÄ·½·¨°²×°£¬°²×°Íê³Éºó»¹ÐèÔ ......

linux×Ô¶¯Æô¶¯ oracle½Å±¾

×î½ü£¬ORACLEϵͳ»ù±¾µ÷ÊÔͨ¹ý£¬ÊÇʱºòÉèÖÃORACLEËæRHEL×Ô¶¯Æô¶¯Óë¹Ø±Õ·þÎñµÄʱºòÁË£¬Ö®ËùÒÔ°ÑÕâ¸öÈÎÎñ·ÅÔÚ×îºóÀ´×ö£¬ÊÇÒòΪÎÒ¾õµÃÕâ¸öÓ¦¸Ã²»»áºÜÄÑ£¬µ«ÕæÕýʵʩÆðÀ´£¬»¹ÊÇÓöµ½Á˸ö²»Ð¡µÄÕϰ­
дºÃ½Å±¾£¬×¢²áºÃ·þÎñÖ®ºó£¬¾­²âÊÔ£¬ORACLE¿ÉÒÔËæRHELÆô¶¯¶øÆô¶¯£¬µ«²»ÄÜËæÏµÍ³¹Ø±Õ¶ø¹Ø±Õ¡£ÔÚÍøÉÏÕҴ𰸣¬·¢ÏÖ¼¸ºõËùÓеÄÉèÖùý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ