Oracle：创建表，插入删除数据

create table spark_timetime
(
  ExTime   Date not null,
  SaveTime Date not null
);

select * from spark_timetime;

-- delete from spark_timetime;

INSERT INTO spark_timetime VALUES 
( 
to_date('2017-12-30 18:00:00' , 'YYYY-MM-DD HH24:MI:SS'), 
to_date('2018-01-01 06:00:00' , 'YYYY-MM-DD HH24:MI:SS')
);

INSERT INTO spark_timetime VALUES 
( 
to_date('2017-12-31 18:00:00' , 'YYYY-MM-DD HH24:MI:SS'), 
to_date('2018-01-01 06:00:00' , 'YYYY-MM-DD HH24:MI:SS')
);

INSERT INTO spark_timetime VALUES 
( 
to_date('2018-01-01 06:00:00' , 'YYYY-MM-DD HH24:MI:SS'), 
to_date('2017-12-30 18:00:00' , 'YYYY-MM-DD HH24:MI:SS')
);