SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

difference between DELETE & TRUNCATE

475975Apr 7 2006 — edited Apr 7 2006

hi friends,
i have read in a book of SQL the differences between DELETE & TRUNCATE, it says that :

TRUNCATE drops the table & recreates the table but, DELETE deletes the rows row by row. now my doubt is that how can a table be again recreated once it has been dropped. If it is dropped, the meta data about the table is also deleted from the data dictionary to recreate it.

please help me.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2006

Added on Apr 7 2006

3 comments

966 views