Interested to Buy Any Domain ? << Click Here >> for more details...
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
what is recursive stored procedure? : Sql dba
Explain how can you save or place your msg in a table?
Define select, insert, create, delete, update, drop keywords
What is a variable in sql?
What is union, minus and interact commands?
What is cte sql?
What is a memo field?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is the mutating table and constraining table?
Is progress software supports to ( pl/sql )?
What is the maximum size of sqlite database?
What is sql catalog?
What are the packages in pl sql?
What do you mean by stored procedures?
If a cursor is open, how can we find in a pl/sql block?
