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!

Count the number of rows inserted

416312Feb 23 2006 — edited Feb 23 2006

Hi,

Is there a way to count the number of rows processed post DML in PL/SQL?

For eg,

BEGIN

INSERT INTO TMP1
SELECT * FROM EMP;

a function to count the number of rows inserted into tmp1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2006
Added on Feb 23 2006
3 comments
2,099 views