title: How do you extract number of rows in Count(*), and send to a variable. (Pl/SQL)
body: <p>I'm trying extract the number of rows using the count(*) with the respect of it's condition and sending it to a variable for later use. </p>
  
  <p><strong>How do I create variables for the number of rows within a table.</strong> 
  Thank you.</p>
  
  <pre><code>VARIABLE 
  VAR CHAR(10)
  
  SELECT COUNT(*) INTO :VAR 
  
  FROM [Database]
  WHERE [condition 1]
  AND [condition 2]
  </code></pre>