-- 删除重复记录
DELETE FROM mytable t1 WHERE ROWID > (SELECT MIN (ROWID) FROM mytable t2 WHERE t1. key = t2.key);
DELETE FROM mytable t1 WHERE ROWID > (SELECT MIN (ROWID) FROM mytable t2 WHERE t1. key = t2.key);
-- 查看被锁的表
SELECT S.SID, O.OBJECT_NAME, S.USERNAME, S.OSUSER FROM V$LOCKED_OBJECT L, V$SESSION S, USER_OBJECTS O WHERE S.SID = L.SESSION_ID AND O.OBJECT_ID = L.OBJECT_ID;
-- 当前日期
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;
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;