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!

How to run select statement through variable

2845574Mar 30 2016 — edited Apr 1 2016

Hi Team,

I have one query to find count of the table, I have to do that through a variable like below

sql_stmt := 'select count(*) INTO'

||in_table_count

||'from'

||in_table

||'where hie_key ='

||in_hie_key;

End populate_table_count;

I have highlighted the query which i have tried. I am getting error like "00923. 00000 - "FROM keyword not found where expected"

Can you please any one help me?

Thanks in Advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2016

Added on Mar 30 2016

22 comments

6,221 views