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