Answer Posted / rajesh
Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.
Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can a function retun more than one value in oracle with proper example?
How many functions are there in sql?
What is cte sql?
What are the sql versions?
Is join same as left join?
Is postgresql a server?
What are the types of keys?
Which version of sql do I have?
define sql insert statement ? : Sql dba
What is the main difference between sql and pl/sql?
What does bitemporal mean?
What is java sql drivermanager?
write an sql query to find names of employee start with 'a'? : Sql dba
What are different functions in sql?
Why query optimization is needed?