oracle T-SQL

--6804 1039654  1032850
SELECT  COUNT(1) FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')

-- BAK DATE 20141231
INSERT INTO T_ORDER_06171150
SELECT * FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')

--6804
SELECT COUNT(1) FROM T_ORDER_06171150

--CREATE BAK TABLE
CREATE TABLE T_ORDER_06171150 AS SELECT * FROM T_ORDER WHERE 1=2

--DEETE 6804  1032850
DELETE FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')

 

 

--6804 1039654  1032850
SELECT  COUNT(1) FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')

-- BAK DATE 20141231
--INSERT INTO T_ORDER_06171150
--SELECT * FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')

--6804
SELECT COUNT(1) FROM T_ORDER_06171150

--CREATE BAK TABLE
--CREATE TABLE T_ORDER_06171150 AS SELECT * FROM T_ORDER WHERE 1=2

--DEETE 6804  1032850
--DELETE FROM T_ORDER WHERE COMMITDATE > TO_DATE( '20141231','YYYYMMDD')