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

OracleÈÕÆÚº¯Êý¼¯½õ(¶þ)

OracleÈÕÆÚº¯Êý¼¯½õ(¶þ)
¶þ¡¢³£ÓÃʱ¼äº¯Êý
1.trunc(sysdate,'Q') ±¾¼¾¶ÈµÚÒ»Ìì
SQL> select trunc(sysdate,'Q') from dual;
TRUNC(SYSDATE,'Q')
------------------
2007-4-1
2.trunc(sysdate,'D') ±¾ÖܵĵÚÒ»Ìì(ÖÜÈÕ)
SQL> select trunc(sysdate,'D')from dual;
TRUNC(SYSDATE,'D')
------------------
2007-5-27
3.last_day(sysdate) ±¾ÔÂ×îºóÒ»Ìì
SQL> select last_day(sysdate) from dual;
LAST_DAY(SYSDATE)
-----------------
2007-5-31 15:20:3
4.add_months(sysdate,2) ÈÕÆÚsysdateºóÍÆ2¸öÔÂ
SQL> select add_months(sysdate,2) from dual;
ADD_MONTHS(SYSDATE,2)
---------------------
2007-7-29 15:21:14
5.next_day(sysdate,2) ÈÕÆÚsysdateÖ®ºóµÄµÚÒ»ÖÜÖÐ,µÚ2(Ö¸¶¨ÐÇÆÚµÄµÚ¼¸Ìì)ÊÇʲôÈÕÆÚ
SQL> select next_day(sysdate,2) from dual;
NEXT_DAY(SYSDATE,2)
-------------------
2007-6-4 15:22:10
6.Months_between(f,s) ÈÕÆÚfºÍs¼äÏà²îÔÂÊý
SQL> select months_between(sysdate,to_date('2007-04-12','yyyy-mm-dd'))from dual;
MONTHS_BETWEEN(SYSDATE,TO_DATE
------------------------------
1.56909908900836
7.µÃµ½SYSDATE+5ËùÔÚµÄÔ·Ý
SQL> SELECT to_char(SYSDATE+5,'mon','nls_date_language=american') from dual;
TO_CHAR(SYSDATE+5,'MON','NLS_D
------------------------------
jun
8.current_date()·µ»Øµ±Ç°»á»°Ê±ÇøÖеĵ±Ç°ÈÕÆÚ¡£
9.select dbtimezone from dual;
10.extract()ÕÒ³öÈÕÆÚ»ò¼ä¸ôÖµµÄ×Ö¶ÎÖµ
SQL> select extract(month from sysdate) "This Month" from dual;
This Month
----------
5
SQL> select extract(year from sysdate) "This year" from dual;
This year
----------
2007
SQL> select extract(month from add_months(sysdate,2)) " Month" from dual;
Month
----------
7
==================================================================


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle vs. SQL ͬÒå´Êsynonym ±ðÃû alias

oracle ͬÒå´Ê synonym ΪÊý¾Ý¿â¶ÔÏó½¨Á¢Í¬Òå´Êºó,µ±dba¶ÔÊý¾Ý¿â¶ÔÏó(table,view,ÐòÁÐ)×öÁËÒ»¸ö¼òµ¥¸Ä¶¯Ö®ºó,ÈçÃû×Ö»òÕ߽ṹ¸Ä±ä,Ôò²»ÐèÒªÖØÐ¸ü¸Ä²¢±àÒëÓ¦ÓÃ.ÔÚÊý¾Ý¿â×ÖµäÖÐÓж¨Òå,²»ÐèÒª½øÐÐÈκδ洢.
oracle±ðÃûalias,With as¡¡Éú³ÉÒ»¸öÁÙʱ±í£¬¶ÔÓÚ¸´ÔÓµÄÊý¾Ý²éѯ£¬¿ÉÒÔ¼õÉÙ×ÊÔ´ÏûºÄ¡¢Ìá¸ßÐÔÄÜ¡£9iÒýÈë¡£
with alias ......

ORACLE¹éµµÄ£Ê½µÄÉèÖÃ

ÔÚORACLE Êý¾Ý¿âµÄ¿ª·¢»·¾³ºÍ²âÊÔ»·¾³ÖУ¬Êý¾Ý¿âµÄÈÕ־ģʽºÍ×Ô¶¯¹éµµÄ£Ê½Ò»°ã¶¼ÊDz»ÉèÖõģ¬ÕâÑùÓÐÀûÓÚϵͳӦÓõĵ÷Õû£¬Ò²ÃâµÄÉú³É´óÁ¿µÄ¹éµµÈÕÖ¾Îļþ½«´ÅÅ̿ռä´óÁ¿µÄÏûºÄ¡£µ«ÔÚϵͳÉÏÏߣ¬³ÉΪÉú²ú»·¾³Ê±£¬½«ÆäÉèÖÃΪÈÕ־ģʽ²¢×Ô¶¯¹éµµ¾ÍÏàµ±ÖØÒªÁË£¬ÒòΪ£¬ÕâÊDZ£Ö¤ÏµÍ³µÄ°²È«ÐÔ£¬ÓÐЧԤ·ÀÔÖÄѵÄÖØÒª´ëÊ©¡£ÕâÑù£¬Í¨¹ý¶¨Ê ......

ÀûÓÃTOADʵÏÖEXCELÊý¾ÝÔÚoracleµÄµ¼Èëµ¼³ö


ÀûÓÃTOADʵÏÖEXCELÊý¾ÝÔÚoracleµÄµ¼Èëµ¼³ö
1.´ÓORACLEÊý¾Ý¿âµ¼³ö³ÉΪEXCELÎļþ
ÀûÓÃTOADÁ¬½ÓÉÏÊý¾Ý¿â£¬·ÃÎÊij¸ö±í£¬ÎÒ±¾»úÊÇÑ¡Öбí“OA_USER”
ÓÒ¼ü“Save as...”
ΪÁ˽â¾öÖÐÎÄÂÒÂëÎÊÌ⣬ËùÒÔÑ¡ÔñÀàÐÍΪ"XLS Instance"£¬Èç¹û´æÔÚ³¤Êý×ÖÐÍ×Ö·û´®±»¸Ä±äµÄÎÊÌ⣬
ÇëÑ¡ÖГString Fields as S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ