Oracleѧϰ±Ê¼ÇÖ®ÈÕÆÚº¯Êý
OracleÈÕÆÚº¯Êýѧϰʱ£¬Ôڽ̳ÌÓм¸¸öʵÀýÈçÏ£º
Months_between(’01-sep-95’, ’11-jan-94’)
½á¹ûÊÇ£º19.6774194
Add_months ÔÚÖ¸¶¨µÄÔ·ÝÉÏÃæÔö¼ÓÏàÓ¦µÃÔ·Ý
ÀýÈ磺
Add_months(’11-jan-94’, 6)
½á¹ûÊÇ£º11-jul-94
Next_day ¼ÆËã¹æ¶¨Èͮ򵀼óÒ»¸öÌØ¶¨ÈÕÆÚ
ÀýÈ磺
Next_day(’01-sep-95’, ‘Friday’ )
½á¹ûÊÇ£º
08-sep-95
Last_day Ö¸Õâ¸öÔÂ×îºóÒ»Ìì
ÀýÈ磺
Last_day(’01-feb-95’)
È»¶øÔÚSQL*plusÊäÈëÕâЩº¯ÊýÖ´ÐÐʱ£¬È´×ܵò»µ½ÕýÈ·µÄ½á¹û£¬ÒòΪÈÕÆÚµÄ¸ñʽÎÞ·¨Ê¶±ð¡£ÕýÈ·µÄÓ÷¨Ó¦¸ÃÈçÏ£º
select MONTHS_BETWEEN('24-2ÔÂ-2010','24-2ÔÂ-2010') from dual¡£ÕâÑùдºÜ²»·½±ã£¬ÎªÁ˱ÜÃâ³öÏÖÕâÑùµÄÎÊÌ⣬ÔÚ×Ô¼ºÊéдÈÕÆÚʱ£¬×îºÃÓÃ×Ô¼ºÏ²»¶µÄ·½Ê½Êéд£¬²¢ÓÃto_dateº¯ÊýÖ¸¶¨¸ñʽÈ磺
select MONTHS_BETWEEN(to_date('20100224','yyyymmdd'),to_date('20100524','yyyymmdd')) from dual
ÕâÀïÉæ¼°µ½Ò»¸öto_dateº¯Êý£¬Ëü½«ÊäÈëµÄ×Ö·û´®ÐòÁУ¬×ª»»ÎªÖ¸¶¨¸ñʽµÄÈÕÆÚº¯Êý£¬ÓÉ´Ë¿ÉµÃÆäËü¸üÎªÈ«ÃæµÄʵÀýΪ£¨ÒÔϲ¿·ÖÕª×Ôhttp://blog.csdn.net/sxpyrgz£©£º
1.ADD_MONTHS
Ôö¼Ó»ò¼õÈ¥Ô·Ý
SQL> select to_char(add_months(to_date('199912','yyyymm'),2),'yyyymm') from dual;
TO_CHA
------
200002
SQL> select to_char(add_months(to_date('199912','yyyymm'),-2),'yyyymm') from dual;
TO_CHA
------
199910
2.LAST_DAY
·µ»ØÈÕÆÚµÄ×îºóÒ»Ìì
SQL> select to_char(sysdate,'yyyy.mm.dd'),to_char((sysdate)+1,'yyyy.mm.dd') from dual;
TO_CHAR(SY TO_CHAR((S
---------- ----------
2004.05.09 2004.05.10
SQL> select last_day(sysdate) from dual;
LAST_DAY(S
----------
31-5ÔÂ -04
3.MONTHS_BETWEEN(date2,date1)
¸ø³ödate2-date1µÄÔ·Ý
SQL> select months_between('19-12ÔÂ-1999','19-3ÔÂ-1999') mon_between from dual;
MON_BETWEEN
-----------
9
SQL>selectmonths_between(to_date('2000.05.20','yyyy.mm.dd'),to_date('2005.05.20','yyyy.mm.dd')) mon_betw from dual;
MON_BETW
---------
-60
×¢£ºSELECT months_between(SYSDATE, sysdate) same,
months_between(SYSDATE, add_months(sysdate, -1)) big,
months_between(SYSDATE, add_months(sysdate
Ïà¹ØÎĵµ£º
²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬Èç ......
1.ÓÃOracleÓû§µÇ½Linux·þÎñÆ÷;
2.ÔÚÖÕ¶Ë´°¿ÚÊäÈë sqlplus /nolog
[oracle@hylinux ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 7ÔÂ 29 14:26:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
& ......
oracle ·ÖÇø±íµÄ½¨Á¢·½·¨
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö· ......
1.²é¿´ËùÓÐÓû§
select * from all_users; -------²é¿´ËùÓеÄÓû§
select * from user_users; --------²é¿´µ±Ç°Óû§
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
select * from user_sys_privs; --------²é¿´µ±Ç°Óû§µÄȨÏÞ
3.²é¿´½ÇÉ«Ëù°üº¬µÄȨÏÞ
&nb ......
ʹÓÃSYSÓû§ÒÔSYSDBAÉí·ÝµÇ¼ϵͳ
²é¿´ÐÞ¸Äǰsga_max_size£¬sga_target´óС
show parameter sga_max_size;
show parameter sga_target;
Ð޸IJÎÊý
alter system set sga_max_size=1600m scope=spfile;
alter system set sga_target=1600m scope=spfile;
²é¿´Ð޸ĺósga_max_size£¬sga_target´óС
show parameter sga_ ......