I want to get count(*) value in dynamic plsql statement.
We can write static stmt as:
select count(*) into tmp_cnt from table_info where nbr_entry='0123456789';
but how to get tmp_cnt value while writing the dynamic sql stament?
or any other way to get count(*) value into tmp_cnt variable?