Accidentally i deleted my table. How can i get that table?
- 4 Answers
- 8063 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
Do you know what is openxml in sql server?
What is the server name for sql management studio?
How do I open port 1433?
What is sub-query in sql server? Explain its properties.
Define outer join?
What Is Rdbms?
What are the types of normalization?
Explain the concept of recursive stored procedure.
SQL Server Architecture ?
What is the difference between join and inner join?
what do you understand by change data capture?
How to handle error or exception in sql?
If the job running very slow what is the action you do
Explain time data type in sal server 2008?
Explain the categories of stored procedure?
