title: How to filter your sql query using declared parameters in Oracle SQL
body: <p>I have a Oracle SQL script and would like to pass input parameter to the script for execution.
  How would I achieve this?</p>
  
  <p>Say I have date parameter testdate. This is how we do it in sql server</p>
  
  <pre><code>declare @testdate as date
  
  select * from test where testdate=@testdate
  </code></pre>
  
  <p>Basically I have set of sql statements in a block which needs to be executed.</p>