title: Dynamically add where clauses to a cursor in oracle
body: <p>I have plsql procedure which accepts certain parameters e.g. v_name, v_country, v_type.</p>
  
  <p>I wish to have a cursor with a select statement like this:</p>
  
  <pre><code>select column from table1 t1, table2 t2
  where t1.name = v_name
  and t1.country = v_country
  and t1.id = t2.id
  and t2.type = v_type
  </code></pre>
  
  <p>If certain parameters are empty can I only add the relevant where clauses to the cursor? Or is there a better way to accomplish this?</p>