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

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±£Áô×Ö

²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
 OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬Èç ......

oracle systemÃÜÂëÍü¼Ç½â¾ö

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 ·ÖÇø±íµÄ½¨Á¢·½·¨ 

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö· ......

Oracle ²é¿´Óû§È¨ÏÞÒÔ¼°Ë÷Òý

1.²é¿´ËùÓÐÓû§
     select * from all_users; -------²é¿´ËùÓеÄÓû§
     select * from user_users; --------²é¿´µ±Ç°Óû§
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
     select * from user_sys_privs; --------²é¿´µ±Ç°Óû§µÄȨÏÞ
3.²é¿´½ÇÉ«Ëù°üº¬µÄȨÏÞ
&nb ......

ÐÞ¸ÄOracle 10g SGA ´óС

ʹÓÃ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_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ