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+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨
oracle ´æ´¢´óÎı¾Ò»Ö±ÊÇÒ»¸ö¼¬ÊÖµÄÎÊÌâ¡£
Ò»¡¢´æÊý¾Ý¿â£º
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
//¶¨Òå±äÁ¿
java.sql.Connection conn; //Êý¾ ......
DBVERIFY¹¤¾ßµÄÖ÷ҪĿµÄÊÇΪÁ˼ì²éÊý¾ÝÎļþµÄÎïÀí½á¹¹£¬°üÀ¨Êý¾ÝÎļþÊÇ·ñË𻵣¬ÊÇ·ñ´æÔÚÂß¼»µ¿é£¬ÒÔ¼°Êý¾ÝÎļþÖаüº¬ºÎÖÖÀàÐ͵ÄÊý¾Ý¡£
DBVERIFY¹¤¾ß¿ÉÒÔÑéÖ¤ONLINE»òOFFLINEµÄÊý¾ÝÎļþ¡£²»¹ÜÊý¾Ý¿âÊÇ·ñ´ò¿ª£¬¶¼¿ÉÒÔ·ÃÎÊÊý¾ÝÎļþ¡£
1.¿ÉÒÔʹÓðïÖú²é¿´dbvµÄÃüÁî²ÎÊý
C:\>dbv help=y
DBVERIFY: Release 11. ......
ÔÚORACLE Êý¾Ý¿âµÄ¿ª·¢»·¾³ºÍ²âÊÔ»·¾³ÖУ¬Êý¾Ý¿âµÄÈÕ־ģʽºÍ×Ô¶¯¹éµµÄ£Ê½Ò»°ã¶¼ÊDz»ÉèÖõģ¬ÕâÑùÓÐÀûÓÚϵͳӦÓõĵ÷Õû£¬Ò²ÃâµÄÉú³É´óÁ¿µÄ¹éµµÈÕÖ¾Îļþ½«´ÅÅ̿ռä´óÁ¿µÄÏûºÄ¡£µ«ÔÚϵͳÉÏÏߣ¬³ÉΪÉú²ú»·¾³Ê±£¬½«ÆäÉèÖÃΪÈÕ־ģʽ²¢×Ô¶¯¹éµµ¾ÍÏàµ±ÖØÒªÁË£¬ÒòΪ£¬ÕâÊDZ£Ö¤ÏµÍ³µÄ°²È«ÐÔ£¬ÓÐЧԤ·ÀÔÖÄѵÄÖØÒª´ëÊ©¡£ÕâÑù£¬Í¨¹ý¶¨Ê ......
ÎÒÃÇ¿ÉÄÜÔÚOracle DB10g Öлᾳ£Óöµ½OEM²»ÄÜÕý³£Ê¹ÓõÄÎÊÌâ,µ¼ÖÂÎÊÌâµÄÔÒò²»¾¡Ïàͬ,
µ«×îºó¾ø´ó¶àÊýÎÊÌâ¿ÉÒÔͨ¹ýemca Õâ¸öÃüÁîÀ´½â¾ö,ÏêϸµÄ˵Ã÷¿ÉÒԲ鿴Á¬»ú°ïÖú,
ÏÂÃæ¸ø³öһЩ³£ÓõÄÃüÁî,¼°ÊµÀý²½Öè.
´´½¨Ò»¸öEM×ÊÁÏ¿â
emca -repos create
ÖØ½¨Ò»¸öEM×ÊÁÏ¿â
emca -repos r ......
Oracle 10g ĬÈϰ²×°´øÀ´µÄÓû§Ãû/ÃÜÂë
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enter ......