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
How to retrieve data from an explicit cursor?
how can we store any pdf file in oracle
Explain self joins in oracle?
Can we save images in a database and if yes, how?
What is a lookup table in oracle?
How to join two tables in a single query using oracle?
What is recovery manager in Oracle?
What is data file?
How to check the oracle tns settings?
What privilege is needed for a user to delete rows from tables in another schema?
What is a table index in oracle?
Is oracle an operator?
How to turn on or off recycle bin for the instance?
Why does for update in oracle 8 cause an ora-01002 error?
What is a database table in oracle?
