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

oracle ÖеÄINTERVAL º¯ÊýÏê½â

INTERVAL YEAR TO MONTHÊý¾ÝÀàÐÍ
OracleÓï·¨:
INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]
¸ÃÊý¾ÝÀàÐͳ£ÓÃÀ´±íʾһ¶Îʱ¼ä²î, ×¢Òâʱ¼ä²îÖ»¾«È·µ½ÄêºÍÔÂ. precisionΪÄê»òÔµľ«È·Óò, ÓÐЧ·¶Î§ÊÇ0µ½9, ĬÈÏֵΪ2.
eg:
INTERVAL '123-2' YEAR(3) TO MONTH    
±íʾ: 123Äê2¸öÔÂ, "YEAR(3)" ±íʾÄêµÄ¾«¶ÈΪ3, ¿É¼û"123"¸ÕºÃΪ3ΪÓÐЧÊýÖµ, Èç¹û¸Ã´¦YEAR(n), n<3¾Í»á³ö´í, ×¢ÒâĬÈÏÊÇ2.
INTERVAL '123' YEAR(3)
±íʾ: 123Äê0¸öÔÂ
INTERVAL '300' MONTH(3)
±íʾ: 300¸öÔÂ, ×¢Òâ¸Ã´¦MONTHµÄ¾«¶ÈÊÇ3°¡.
INTERVAL '4' YEAR    
±íʾ: 4Äê, ͬ INTERVAL '4-0' YEAR TO MONTH ÊÇÒ»ÑùµÄ
INTERVAL '50' MONTH    
±íʾ: 50¸öÔÂ, ͬ INTERVAL '4-2' YEAR TO MONTH ÊÇÒ»Ñù
INTERVAL '123' YEAR    
±íʾ: ¸Ã´¦±íʾÓдíÎó, 123¾«¶ÈÊÇ3ÁË, µ«ÏµÍ³Ä¬ÈÏÊÇ2, ËùÒԸô¦Ó¦¸Ãд³É INTERVAL '123' YEAR(3) »ò"3"¸Ä³É´óÓÚ3СÓÚµÈÓÚ9µÄÊýÖµ¶¼¿ÉÒÔµÄ
INTERVAL '5-3' YEAR TO MONTH + INTERVAL '20' MONTH =
INTERVAL '6-11' YEAR TO MONTH
±íʾ: 5Äê3¸öÔ + 20¸öÔ = 6Äê11¸öÔÂ
Óë¸ÃÀàÐÍÏà¹ØµÄº¯Êý:
NUMTODSINTERVAL(n, 'interval_unit')
½«nת»»³Éinterval_unitËùÖ¸¶¨µÄÖµ, interval_unit¿ÉÒÔΪ: DAY, HOUR, MINUTE, SECOND
×¢Òâ¸Ãº¯Êý²»¿ÉÒÔת»»³ÉYEARºÍMONTHµÄ.
NUMTOYMINTERVAL(n, 'interval_unit')
interval_unit¿ÉÒÔΪ: YEAR, MONTH
eg: (Oracle Version 9204, RedHat Linux 9.0)
SQL> select numtodsinterval(100,'DAY') from dual;
NUMTODSINTERVAL(100,'DAY')                                                     
---------------------------------------------------------------------------    
+000000100 00:00:00.000000000                    &nb


Ïà¹ØÎĵµ£º

¼×¹ÇÎÄÍÆ³öOracleÆóÒµ¹ÜÀíÆ÷11g£¨Ò»£©

OracleÆóÒµ¹ÜÀíÆ÷11gÌṩҵ½ç×îÈ«ÃæµÄÒµÎñÇý¶¯ÐÍIT¹ÜÀí¹¦ÄÜ£¬ÓÐÖúÓÚͨ¹ý¼¯³ÉʽIT¹ÜÀí·½·¨£¬×î´óÏ޶ȵØÌá¸ßÆóÒµÃô½ÝÐÔºÍЧÂÊ¡£
¡¡¡¡OracleÆóÒµ¹ÜÀíÆ÷11gÒýÈëÁË£º
¡¡¡¡ÒµÎñÇý¶¯ÐÍÓ¦ÓùÜÀí - ʹITϵͳÄܹ»¸ü¿ìµØÏìÓ¦ÓÅÏÈÒµÎñ£¬Í¨¹ý¹ÜÀíÃæÏòÓû§ÌåÑéºÍÉÌÎñ½»Ò׵ĹؼüÖ¸±ê£¬Ìṩ¸ü¸ßµÄÉÌÒµ¼ÛÖµ¡£
¡¡¡¡¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀ ......

[轉]oracle ·Ö頁

·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐз­Ò³µÄԭʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN >= 21¿ØÖÆ·ÖÒ³²éѯµÄÿҳµÄ·¶Î§¡£
ÉÏÃæ¸ø³öµÄÕâ¸ö·ÖÒ³²éѯÓï¾ä£¬ÔÚ´ó¶à ......

oracleÈÕÆÚʱ¼äº¯Êý´óÈ«

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê               ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ