Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22680 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohsin mohammed abdul
Delete command deletes the data from the tables .. but can
get back on issue of roll back whereas when you issue
truncate deletes the records and oracle implicitly issues
commit command and even when you issue rollback you won't
get the data back
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How will you optimize a stored procedure optimization?
Write a program to fetch first 10 records from a file?
What is tablix?
What is a matrix in ssrs?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is temporal table?
How to recover from sql injection? : sql server security
Why and when do stored procedure recompile?
mention different types of relationships in the dbms?
Explain datetimeoffset data type in sal server 2008?
What is Extended user-defined?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is the native system stored procedure to execute a command against all databases?
How to start sql server browser service?
What is the usage of sign function?
