--1,闪回
select * from tableName as of timestamp to_timestamp('2019-04-20 10: 43:00','yyyy-mm-dd hh24: mi: ss');
alter table tableName enable row movement;
flashback table tableName to timestamp to_timestamp('2019-04-20 10: 43: 00','yyyy-mm-dd hh24:mi: ss');
--2,关闭连接(唯一索引不能修改,只能先删除)
alter table tableName drop constraint indexName;
--3,删除索引
drop index indexName;
--4,创建索引
create unique index indexName on tableName(column1, column2);
--5,复制数据 表结构要一样
insert into (column1,column2)
select sys_guid(), column2 from tableName
--6,删除字段
alter table tableName drop column column1;
--7,添加字段
alter table tableName ADD column1 VARCHAR2(200) NOT NUL;
--8,添加注释
comment on cloumn tableName.column1 is 'sdas';
--9,判断语句
select decode(sign(to_date('2019-11-11','yyyy-mm-dd')-sysdate),1,1,2) from dual;
select case
when to_date('2019-11-11','yyyy-mm-dd') > sysdate
then 1
else 2
end
from dual