Answer Posted / joe
Delete is DML and truncate is DDl;
both or used to delete the records from the table.
We can rollback the deleted records but we cant when we used truncate.
Delete is faster than truncate
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Is it possible for a table to have more than one foreign key?
How to convert comma separated string to array in pl/sql?
What is procedure explain with example?
What are different categories of sql commands?
Explain the purpose of %type and %rowtype data types?
How do I remove sql developer from windows 10?
How can we solve sql error: ora-00904: invalid identifier?
How do I enable sql encryption?
How sql query is executed?
how to concatenate two character strings? : Sql dba
What is the use of & in pl sql?
What is compilation error in pl sql?
what are the types of join and explain each? : Sql dba
Are subqueries faster than joins?
How many primary keys can a table have?