Answer Posted / asnani_satish@yahoo.com

Flashback table feature is available from Oracle 9i onwards
only. Before that deleted records once committed cannot be
rolled back. As far as Oracle 9i onwards the solution
specified by Bipin Maurya is correct. But i would like to
add something. For using FLASHBACK TABLE the user must be
granted privilege for the same. But there is another way out.

create table temp_new as select * from temp as of timestamp
to_timestamp('11/01/2011 08:45:00','dd/mm/yyyy hh24:mi:ss');

This will bring the table to the point in time specified by
timestamp.

Explain the use of indexes option in exp command.

1139

---

How to use "in out" parameter properly?

1044

---

Which is better Oracle or MS SQL? Why?

4931

---

What is an oracle user role?

984

---

What exactly do quotation marks around the table name do?

957

---

if you ctreate table identity

2368

---

How to define default values for formal parameters?

1042

---

What is meant by an index?

1135

---

How to execute a stored procedure in oracle?

1080

---

What the is the diff between local index and global index. give some example.

1638

---

What are the logical operations?

1119

---

What are temporal data types in oracle?

1119

---

How to generate query output in html format?

1112

---

Explain what does a control file contain?

1096

---

Can group functions be mixed with non-group selection fields?

1018

---