Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7343 Views
- I also Faced
- E-Mail Answers
Answer Posted / samad
ya its correct sowjanya
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible
DELETE - deletes all records from a table, the space for the
records remain rollback is possible
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Why do you use stored procedures and state some of its disadvantages?
Explain about functional dependency and its relation with table design?
What is flashback in Oracle?
How to define an oracle cursor variable?
How do I uninstall oracle client from windows?
How to delete an existing row from a table in oracle?
What is difference between cartesian join and cross join?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to see free space of each tablespace?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is a dynamic performance view in oracle?
Give the advantages and disadvantages of clusters.
What is the difference between translate and replace?
