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

Oracle to_dateµÄʹÓ÷½·¨

Oracle to_dateµÄʹÓ÷½·¨ ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì  
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Сʱ¼Æ
HH24 Сʱ£¬°´24Сʱ¼Æ  
MI ·Ö  
SS Ãë  
MM Ô  
Mon Ô·ݵļòд  
Month Ô·ݵÄÈ«Ãû  
W ¸ÃÔµĵڼ¸¸öÐÇÆÚ
WW ÄêÖеĵڼ¸¸öÐÇÆÚ
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷  
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval ’7’ MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡¡select sysdate - interval ’7’ hour from dual  
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7ÌìµÄʱ¼ä  
¡¡¡¡select sysdate - interval ’7’ day from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7ÔµÄʱ¼ä  
¡¡¡¡select sysdate,sysdate - interval ’7’ month from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7ÄêµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval ’7’ year from dual
¡¡¡¡Ê±¼ä¼ä¸ô³ËÒÔÒ»¸öÊý×Ö  
¡¡¡¡select sysdate,sysdate - 8 *interval ’2’ hour from dual
2.ÈÕÆÚµ½×Ö·û²Ù×÷
¡¡¡¡select sysdate,to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from dual  
¡¡¡¡select sysdate,to_char(sysdate,’yyyy-mm-dd hh:mi:ss’) from dual  
¡¡¡¡select sysdate,to_char(sysdate,’yyyy-ddd hh:mi:ss’) from dual
¡¡¡¡select sysdate,to_char(sysdate,’yyyy-mm iw-d hh:mi:ss’) from dual  
¡¡¡¡²Î¿¼oracleµÄÏà¹Ø¹ØÎĵµ(ORACLE901DOC/SERVER.901/A90125/SQL_ELEMENTS4.HTM#48515)  
3. ×Ö·ûµ½ÈÕÆÚ²Ù×÷  
¡¡¡¡select to_date(’2003-10-17 21:15:37’,’yyyy-mm-dd hh24:mi:ss’) from dual  
¡¡¡¡¾ßÌåÓ÷¨ºÍÉÏÃæµÄto_char²î²»¶à¡£
4. trunk/ ROUNDº¯ÊýµÄʹÓÃ
¡¡¡¡select trunc(sysdate ,’YEAR’) from dual
¡¡¡¡select trunc(sysdate ) from dual
¡¡¡¡select to_char(trunc(sysdate ,’YYYY


Ïà¹ØÎĵµ£º

oracle³£Óþ­µäSQL²éѯ

oracle³£Óþ­µäSQL²éѯ
³£ÓÃSQL²éѯ£º
 
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
 
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
 
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ ......

ORACLE³£ÓÃÊýÖµº¯Êý¡¢×ª»»º¯Êý¡¢×Ö·û´®º¯Êý½éÉÜ


µ¥Öµº¯ÊýÔÚ²éѯÖзµ»Øµ¥¸öÖµ£¬¿É±»Ó¦Óõ½select£¬where×Ӿ䣬start withÒÔ¼°connect by ×Ó¾äºÍhaving×Ӿ䡣
(Ò»).ÊýÖµÐͺ¯Êý(Number Functions)
    ÊýÖµÐͺ¯ÊýÊäÈëÊý×ÖÐͲÎÊý²¢·µ»ØÊýÖµÐ͵ÄÖµ¡£¶àÊý¸ÃÀຯÊýµÄ·µ»ØÖµÖ§³Ö38λСÊýµã£¬ÖîÈ磺COS, COSH, EXP, LN, LOG,
SIN, SINH, SQRT, TAN, and TANH Ö ......

oracleÐÐÁÐת»»

/* 
ÔÚʵ¼ÊʹÓÃsql¹¤×÷ÖÐ×Ü»áÅöµ½½«Ä³Ò»ÁеÄÖµ·Åµ½±êÌâÖÐÏÔʾ.¾ÍÊÇ×Ü˵µÄÐÐÁÐת»»»òÕß»¥»». 
±ÈÈçÓÐÈçÏÂÊý¾Ý: 
ID NAME       KECHENG              CHENGJI 
-- ---------- --------------- ......

Oracle Procedure Êý×é²ÎÊýµÄÓ¦ÓÃ

Òò¹¤×÷ÐèÒª£¬Êý¾Ý¿âÓÉPostgreSQL תΪOracle 10g¡£ÓÉÓÚ֮ǰµÄÂß¼­¼¸ºõ¶¼·Ö²¼ÓÚ´æ´¢¹ý³Ì£¬ËùÒÔ¶à´úÂëµÄÐÞ¸ÄÏà¶ÔÀ´Ëµ½ÏС¡£
Òò¶ÔOracle Êý×é²ÎÊýµÄת»»»¨ÁËЩʱ¼ä£¬ËùÒԼǼÏÂÀ´£¬·ÖÏíһϡ£ÑÔ¹éÕý´«£º
Èç¹ûÈë²ÎΪ×Ö·û´®Êý×é¡¢ÕûÐÎÊý×é»òÕßGUIDÊý×éµÈµÈ£¬²¢ÇÒ°ÑËü×÷Ϊһ¸ö²éѯÌõ¼þ£¬ÓÐÁ½ÖÖ·½·¨¿ÉÒÔ×öµ½¡£ÎÒ²ÉÓÃÁËpackage£¬º ......

OracleÊý¾Ý¿âÖÐÖÐÎĺº×ÖÏÔʾÂÒÂëÎÊÌâ

OracleÊý¾Ý¿âÖÐÖÐÎĺº×ÖÏÔʾÂÒÂëÎÊÌâ
Õª Òª
×Ö·û¼¯µÄÉèÖò»µ±ÊÇÓ°ÏìORACLEÊý¾Ý¿âºº×ÖÏÔʾµÄ¹Ø¼üÎÊÌâ¡£±¾ÎÄ´Óʵ¼ù¾­Ñé³ö·¢£¬½éÉÜÁËORACLE¹ØÓÚ×Ö·û¼¯µÄ·ÖÀà¡¢¹¹³É¼°É趨·½·¨£¬·ÖÎöÁËORACLEÊý¾Ý¿âºº×ÖÏÔʾÂÒÂëµÄ³£¼ûÏÖÏó¼°Ô­Òò£¬²¢Õë¶Ô¸÷ÖÖÏÖÏó¼°Ô­ÒòÌá³öÁËÐÐÖ®ÓÐЧµÄ½â¾ö°ì·¨¡£
¹Ø¼ü×Ö: ORACLE ×Ö·û¼¯ ÖÐÎÄ ÂÒÂë ½â¾ö UTF ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ