Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25169 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
Explain primary key?
What is data file in computer?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Explain tablesample?
Can we delete data from a view?
Write a SQL command to insert and update only a particular field?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How can sql server instances be hidden?
How to execute stored procedure in select statement sql server?
What is a fan-out query in SQL Azure?
Explain transaction server isolation?
What is co-related sub query?
How can I tell if sql server is 32 or 64 bit?
What do you understand by SQL*Net?
