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 does trigger mean in slang?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Enlist some predefined exceptions?
What is the life of an sql statement?
What are the advantages of indexing?
What is an invalid partition table?
How do I view output in sql developer?
What is trigger in sql? Explain
What are the properties of a transaction?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we create index on primary key?
Which are the different types of indexes in sql?
what are the different type of normalization? : Sql dba
How to read/write files from pl/sql?
what is the difference between inner and outer join? Explain with example. : Sql dba