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
What is a cursor and what are the steps need to be taken?
How to update values on multiple rows in oracle?
When do we use group by clause in a sql query?
Explain what are synonyms used for?
Explain the use of Merge statement in oracle 11g
can u plz provide me oca sql dumps please i need them
What is blob datatype?
Difference between cartesian join and cross join?
What is the difference between "as" and "is" in an oracle stored procedure?
What the is the diff between local index and global index. give some example.
How to select all columns of all rows from a table in oracle?
how to clone 9i Database on to 10g Database.
What are the uses of a database trigger?
How to use subqueries in the from clause in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?