06 2012 档案

oracle建表时按天分区的自动生成语句
摘要：DECLARE V_SQL VARCHAR2(1000); V_SQL_HEAD VARCHAR2(100); V_SQL_TAIL VARCHAR2(10); V_DAY VARCHAR2(8); CURSOR C_CUR IS SELECT TO_CHAR((TO_DATE('2012-01', 阅读全文
posted @ 2012-06-29 16:44 wingsless 阅读(5216) 评论(2) 推荐(0)
如何在存储过程中自动添加分区
摘要：declare v_sql varchar2(1000); TABLE_NAME VARCHAR2(100); I_DAY VARCHAR2(8) := '20120611'; I_L_DAY VARCHAR2(8); begin I_L_DAY := TO_CHAR((TO_DATE(I_DAY, 阅读全文
posted @ 2012-06-25 09:54 wingsless 阅读(818) 评论(0) 推荐(0)
如何删除表中的重复数据
摘要：DELETE FROM table1 WHERE id IN (SELECT id FROM table1 GROUP BY id HAVING COUNT(id) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM table1 GROUP BY id HA 阅读全文
posted @ 2012-06-25 09:46 wingsless 阅读(335) 评论(2) 推荐(0)