Accidentally i deleted my table. How can i get that table?
- 4 Answers
- 8371 Views
- I also Faced
- E-Mail Answers
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 difference between ‘having’ clause and a ‘where’ clause?
How to create user defined functions with parameters?
How to drop an existing table?
What is extended stored procedures?
What do you mean by the term 'normalization'?
List all the types of user-defined functions?
What happens to a statement batch if there is a compilation error?
What is code near application topology?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How to find index size for each index on table?
How to download and install microsoft .net framework version 2.0?
Explain the phases a transaction has to undergo?
How do I create an extended event in sql server?
What is data source document?
How can sql server instances be hidden?
