diff between DELETE and TRUNCATE?.

Answer Posted / p.baskar

DELETE is DML Command, TRUNCATE is DLL Command.

DElete used to particular record or, all records from table.
But TRUNCATE only relete the all records.

Ee can rollback the DELETE Command, But we cant rollback the
TRUNCATE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor and what are the steps need to be taken?

577


How to update values on multiple rows in oracle?

581


When do we use group by clause in a sql query?

546


Explain what are synonyms used for?

574


Explain the use of Merge statement in oracle 11g

570






can u plz provide me oca sql dumps please i need them

1438


What is blob datatype?

545


Difference between cartesian join and cross join?

523


What is the difference between "as" and "is" in an oracle stored procedure?

514


What the is the diff between local index and global index. give some example.

1110


How to select all columns of all rows from a table in oracle?

563


how to clone 9i Database on to 10g Database.

1803


What are the uses of a database trigger?

503


How to use subqueries in the from clause in oracle?

561


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1825