Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22012 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
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
How many file formats are supported to export data?
How to insert multiple rows with one insert statement in oracle?
How to create a new oracle data file?
Explain oracle data types with examples?
What is PL/SQL ?
What is the data pump import utility?
How to resolve the ORA-39133 error in Oracle?
How many data types are supported?
What is an oracle wallet?
What are the built-in functions used for sending Parameters to forms ?
How to use values from other tables in update statements using oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to use subqueries with the in operator using oracle?
Explain the function of optimizer in oracle?
Where do you use decode and case statements?
