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 the Advantages of using CTE in sql server?
Differentiate between delete and truncate.
What is the importance of a recovery model?
Why use “in” clause in sql server?
What are the five characteristics of good data?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
what's new in sql server 2016?
Can one drop a column from a table?
what is a check constraint?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What will be query used to get the list of triggers in a database?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to list all tables in the database using odbc_tables()?
Show Practically Sql Server Views are updatable?