| |
You are here: Experts > Computing/Technology > Oracle > Oracle > sql query
Expert: Edson - 9/26/2009
Question
I want to know that how to use flash back query if anybook
please tell me I want to rollback The DDL commands.
Answer
---Examples of FlashBack
create table test_flashback
(ab number(2));
insert into test_flashback
select substr(dman_cd_dim_ano,1,2) from dm_ano;
delete from test_flashback;
commit;
insert into test_flashback select * from test_flashback as of timestamp(sysdate - ((1/24)/60));
commit;
---------------------------------
drop table test_flashback;
flashback table test_flashback to before drop;
----Real example
select count(*) from (
select * from test_flashback as of timestamp(sysdate - ((10/24)/60))
) a
Wait your reply
Add to this Answer Ask a Question
|
|
|
