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!

use count(*) in EXECUTE IMMEDIATE

633972Dec 11 2008 — edited Dec 11 2008
Hi All,

I use Oracle 10g R2.
I am trying to get the count of records in a table, whose name is given at runtime. I am not sure how to return the count(*) value into a variable.
I need to do processing based on that count.

I thought i can use the returning into clause, but that seem to work only with column names.
Any suggestions/indiactors appreciated.
Thank you.

GK
This post has been answered by Himanshu Kandpal on Dec 11 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2009
Added on Dec 11 2008
3 comments
6,752 views