Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sachin
the main difference between delete and truncate is that in
the truncate u will delete all the values from the table as
well as from the data dictionaries also while delete is used
to delete selected values and in the same way drop is use
to delete whole data from a table but the deleted data will
occupy the memory space in the extents but if we perform
truncate then the extents are free from the deleted data .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ordinary table in oracle?
How to get a list of all background sessions in the database?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to save query output to a local file?
How can I create database in oracle?
What is the dynamic sql in oracle?
What is the difference between a user and a schema in oracle?
How do I learn what codesets are available in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How to filter out duplications in the returning rows using oracle?
What is oracle join syntax?
What language does oracle use?
 What are the oracle DML commands possible through an update strategy?
Explain view?
What is the purpose of save points in oracle database?
