Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Flash back rows


SQL> select sysdate from dual;
SQL> set time on;
SQL> conn scott/tiger
scott> select * from salgrade;
scott> delete from salgrade where grade=1;
scott> commit;
scott> alter table salgrade enable row movement;
scott> flashback table salgrade to timestamp to_timestamp('09-MAY-2013 18:23:45','dd-mm-yyyy hh24:mi:ss');

Related Posts Plugin for WordPress, Blogger...

Flag Counter