Home > Database > Mysql Tutorial > ORACLE—007:查找删除的数据

ORACLE—007:查找删除的数据

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 15:02:39
Original
1297 people have browsed it

删除表格的数据有两种:delete和trunc。 trunc则数据再不可恢复,而使用了delete还可以通过查找并恢复的。 如果使用delete误删除了数据,那么可以通过如下sql查找到。 select *from 表名 as of TIMESTAMP 时间where条件 例如:表名tb_test为,选择10天内的删

删除表格的数据有两种:delete和trunc。

trunc则数据再不可恢复,而使用了delete还可以通过查找并恢复的。

如果使用delete误删除了数据,那么可以通过如下sql查找到。

select *
from 表名 as of TIMESTAMP 时间
where
条件
Copy after login


例如:表名tb_test为,选择10天内的删除数据,sql如下

select * from tb_test as of TIMESTAMP sysdate-10
where
1=1;
Copy after login

 

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template