????????????????????????????????????????Oracle???????????????????

???????????????????????????????协????????????????谢?????????????????琛�

?????????????????????????

????Oracle??????????????????????DML??????????????????????????????谢????????????????????DDl???????????????????????????

?????????commit???????DDL????小?

??????????????????????????????些?????????????????????械???????????????????????????????????魏????????????????????胁?????where????update?????????????????????????????????????????????sql???Oracle?????????????dba?????????????????????????些??????????????????????????????????????未???????????????????????????????????????????????????????????????

?????????????????????????????????械??????????贸???????????????????????????????????

???????锟�????位?????小???????emp???械??????校????????????????????????????5??????????????????????些?小?

SQL> delete from emp;
15 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from emp;
COUNT(*)
----------
0
SQL> insert into emp (select * from emp as of timestamp(sysdate-5/1440));
15 rows created.
SQL> select count(*) from emp;
COUNT(*)
----------
15
??2?????????????????????????
????:
SQL> drop table emp;
Table dropped.
SQL> select count(*) from emp;
select count(*) from emp
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table emp to before drop;
Flashback complete.
SQL> select count(*) from emp;
COUNT(*)
----------
15

???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????浠�??????????????????????????????????????????????????????????????????????????????泄????????????????????????