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!

Get the number of rows affected by a truncate

Neo-bApr 9 2012 — edited Apr 9 2012
Hello All,

I want to get the number of rows affected by truncate commands without selecting the count from the table. is there any way?

for delete, insert and updated i used sql%rowcount; before the commit, is there something like for truncate?

Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2012
Added on Apr 9 2012
2 comments
1,745 views