ORACLE³£Óù¦ÄÜ
-- ɾ³ýÖØ¸´¼Ç¼
DELETE from mytable t1 WHERE ROWID > (SELECT MIN (ROWID) from mytable t2 WHERE t1. key = t2.key);
-- µ±Ç°ÈÕÆÚ
SELECT TO_CHAR(SYSDATE, 'yyyy-MM-dd') from DUAL;
-- ÉÏÔµ±Ç°ÈÕÆÚ
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,
-1), 'yyyy-MM-dd') from DUAL;
-- ÏÂÔµ±Ç°ÈÕÆÚ
SELECT
TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'yyyy-MM-dd') from DUAL;
--
ÉÏÔÂÊ×Ìì
SELECT TO_CHAR(ADD_MONTHS(LAST_DAY(SYSDATE) + 1,
-2),'yyyy-MM-dd') from DUAL;
-- ÉÏÔÂÔÂÄ©
SELECT
TO_CHAR(LAST_DAY(ADD_MONTHS(LAST_DAY(SYSDATE) + 1, -2)),'yyyy-MM-dd') from DUAL;
-- µ±ÔÂÊ×Ìì
SELECT
TO_CHAR(ADD_MONTHS(LAST_DAY(SYSDATE) + 1, -1), 'yyyy-MM-dd') from DUAL;
-- µ±ÔÂÔÂÄ©
SELECT
TO_CHAR(LAST_DAY(ADD_MONTHS(LAST_DAY(SYSDATE) + 1, -1)),'yyyy-MM-dd') from DUAL;
-- ÏÂÔÂÊ×Ìì
SELECT
TO_CHAR(ADD_MONTHS(LAST_DAY(SYSDATE) + 1, 0), 'yyyy-MM-dd') from DUAL;
-- ÏÂÔÂÔÂÄ©
SELECT
TO_CHAR(LAST_DAY(ADD_MONTHS(LAST_DAY(SYSDATE) + 1, 0)), 'yyyy-MM-dd') from DUAL;
-- ½ñÄêÊ×Ìì
SELECT TO_CHAR(TRUNC(SYSDATE,'Y'), 'yyyy-MM-dd') from DUAL;
Ïà¹ØÎĵµ£º
Oracle°æ±¾µÄÇø±ðÓÐÄÇЩ
http://database.51cto.com/art/201004/196494.htm
http://database.51cto.com
2010-04-23 15:20 ØýÃû »¥ÁªÍø ÎÒÒªÆÀÂÛ(
0
)
ͻ񻣼
ÒÔϵÄÎÄÕÂÖ÷ÒªÊǶÔOracle°æ±¾µÄÇø±ðµÄ¼òÊö£¬Èç¹ûÄã¶ÔÆäµÄÏà¹ØÄÚÈݸÐÐËȤµÄ
»°£¬ÒÔϵÄÎÄÕÂÖ÷Òª¾ÍÊÇ¶ÔÆäÏà¹ØÄÚÈÝµÄ ......
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......
INTERVAL YEAR TO MONTHÊý¾ÝÀàÐÍ
OracleÓï·¨:
INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]
¸ÃÊý¾ÝÀàÐͳ£ÓÃÀ´±íʾһ¶Îʱ¼ä²î, ×¢Òâʱ¼ä²îÖ»¾«È·µ½ÄêºÍÔÂ. precisionΪÄê»òÔµľ«È·Óò, ÓÐЧ·¶Î§ÊÇ0µ½9, ĬÈÏֵΪ2.
eg:
INTERVAL '123-2' YEAR(3) TO MONTH & ......
create or replace type mytype IS TABLE OF varchar2(20);
declare type1 mytype :=mytype('1','2','3','4');
i number:=1;
var_str varchar(20):='liaomin';
begin
type1.EXTEND;
type1(type1.COUNT):=var_str;
loop
dbms_output.put_line(type1(i));
i:=i+1;
exit when i=type1.count+1; ......
Oracle group by¼°ÆäÈô¸ÉÏà¹Øº¯ÊýµÄһЩ˵Ã÷
http://blog.csdn.net/roland_wg/archive/2009/07/03/4319323.aspx
OracleµÄgroup by³ýÁË»ù±¾Ó÷¨ÒÔÍ⣬»¹ÓÐ3ÖÖÀ©Õ¹Ó÷¨£¬·Ö±ðÊÇrollup¡¢cube¡¢grouping sets¡£
¼ÙÉèÓÐÒ»¸ö±ítest£¬ÓÐA¡¢B¡¢C¡¢D¡¢E5ÁС£
1£© Èç¹ûʹÓÃgroup by rollup(A,B,C)£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP BY ......