1、Oracle如何修改数据文件和日志文件的路径

2、删除某年之前的长期计划：delete from tb where year(dt) < 2008

delete from 表名 where cast(字段名 as datetime)<'2009-07-21'; // cast( 列名/值 as 数据类型 )
commit;

delete from t_table where date<unix_timestamp('20110201');

DELETE FROM "TABLEA" WHERE CREATE_TIME=to_date('2019-04-26 10:22:11','yyyy-mm-dd hh24:mi:ss')

delete from test where convert(datetime,convert(nvarchar(50),logtime)) between '2009-06-21' and '2009-07-21'

select t.* from t_table t where cast(t.begin_time as DATE) >= to_date('2015-01-10 08:00:01','yyyy-mm-dd hh24:mi:ss') ;

3、

ITPub博客

Oracle笔记