Oracle笔记

1、Oracle如何修改数据文件和日志文件的路径 http://blog.itpub.net/31529886/viewspace-2755803/ 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、