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 are triggers? : Sql server database administration
What is full outer join in sql server joins?
What are the properties and different types of sub-queries?
Can foreign key be deleted?
what is the difference between Tabular and Matrix report?
Tell me the phases a transaction has to undergo?
What are joins in sql and what are the different types of joins?
what is a join? : Sql server database administration
What is serializable?
Do you know what are the differences between lost updates and uncommitted dependencies?
When is the use of update_statistics command?
How to create percentile function?
What are user defined functions in ms sql server?
What is the difference between a primary key and a unique key? Are they the same?
Can sql servers link to other servers?