Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22089 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
What are the elements of dbms?
Explain cursor as data base object?
What are the difference between primary key and unique key? : sql server database administration
What is normalization and denormalization in sql server?
What are the grouping functions?
What are the types of containers in ssis?
What function does a database engine serve in the sql server?
How can sql server instances be hidden?
What is the difference between osql and query analyzer?
How to get all stored procedures in sql server?
What is database replication?
Can we call stored procedure in view in sql server?
What is the standby server?
How to trouble shoot if unable to connect SQL Server
what are the different stages of Report Processing?
