Skip to Main Content
Forums

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!

truncate vs delete

alinuxApr 23 2007 — edited Apr 23 2007
Hi all,
What is better to use inside a stored procedure. I want to delete all the rows from a table.

truncate or delete all?

the table has approximately 3 000 rows.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2007
Added on Apr 23 2007
10 comments
799 views