Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23042 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 to pass parameters to procedures?
Why do we need integrity constraints in a database?
What is set operator oracle?
Why do you create or replace procedures rather that drop and recreate.
What do you mean by a tablespace?
What is difference between truncate and delete?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to put more than 1000 values into an oracle in clause?
List the types of joins used in writing subqueries?
What are the most common interview questions on ETL Testing for experience?
Explain how are indexes update?
What is meant by an index?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are a query and state the different types of queries and their uses?
What is a table index?
