Accidentally i deleted my table. How can i get that table?
Answer Posted / ravi
In this case data only deleted but table structure is there.
so can flashback the the data.
example:-
delete * from emp;
ans:- insert into emp select * from emp as of timestamp
sysdate -3/1440;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the use of commit?
How can you insert null values in a column while inserting the data?
What is sql injection? How to protect against sql injection attack?
How do I install sql server?
How to delete an existing database user?
How do you delete a trigger?
What are a scheduled jobs or what is a scheduled tasks?
What is implicit mode in sql server?
What is data compression? : sql server database administration
What is coalesce in sql server?
What are sub reports?
what's the information that can be stored inside a bit column? : Sql server database administration
between cast and convert which function would you prefer and why?
can any body tell me how to know the password of current user in sql server
Find nth lowest salary or get nth lowest salary?