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¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬Èç ......
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24
DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides suppo ......
Ô ÎÄ£ºÆ½·²ËêÔ£ºjiraµÄ°²×°£¨oracleÊý¾Ý¿â£©http://www.trucy.org/blog/ray/archives/000927.html
ÒÔÏÂÊÇ»ùÓÚÔÎĵIJ¹³äÍêÉÆºóµÄÄÚÈÝ£º
JIRAÊÇÒ»¸öÓÅÐãµÄÎÊÌâ(or bugs£¬task£¬improvement£¬new feature  ......
Oracle´´½¨É¾³ýÓû§¡¢½ÇÉ«¡¢±í¿Õ¼ä¡¢µ¼Èëµ¼³ö¡¢...ÃüÁî×ܽá
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace zfmi_temp
tempfile 'D:\oracle\oradata\zfmi\zfmi_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//tempfile²ÎÊý±ØÐëÓÐ
//´´½¨Êý¾Ý±í¿Õ¼ä
create table ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......