What is the difference between DELETE and TRUNCATE?
Answer Posted / sanjay keserwani
we can go upto some number of records through delete while
in truncate we have to unoccupied all records.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is the difference between the implicit and explicit cursors?
What are the datatypes available in pl/sql ?
Do stored procedures prevent sql injection?
How to change sql*plus system settings?
What is difference between hql and native sql?
What are different types of indexes?
How do you concatenate in sql?
What is a variable in sql?
How to combine two stored procedures in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
When sql appeared?
What is primary key secondary key alternate key candidate key?
define sql insert statement ? : Sql dba
Is truncate ddl or dml?
Is the primary key an index?