title: how to get count(*) value in local temp variable in dynamic sql (ORACLE PLSQL)
body: <p>I want to get <code>count(*)</code> value in dynamic plsql statement.
  We can write static stmt as:</p>
  
  <pre><code>select count(*) into tmp_cnt from table_info where nbr_entry='0123456789';
  </code></pre>
  
  <p>but how to get <code>tmp_cnt</code> value while writing the dynamic sql stament?
  or any other way to get <code>count(*)</code> value into <code>tmp_cnt</code> variable?</p>