????????????????????
???????????? ???????[ 2013/8/1 14:17:48 ] ????????
????????????????????????????????????????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
???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????浠�??????????????????????????????????????????????????????????????????????????????泄????????????????????????
??????

???路???
??????????????????
2023/3/23 14:23:39???写?貌??????????
2023/3/22 16:17:39????????????????????些??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???路???????路
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11