title: Oracle SQL Developer - How to create query that prompts user to enter two dates
body: <p>I am doing a database course for school and we are using Oracle SQL Developer. One of the queries we are required to create includes the following </p>
  
  <blockquote>
    <p>Show X, Y, Z, values for all Master Avatars born between two dates (to be entered at runtime – the user should be prompted for dates)</p>
  </blockquote>
  
  <p>I have successfully created the query to retrieve all of the data, minus the date input. I have been using <code>'Av_DOB=&amp;Choose_Date'</code> to prompt the user for an input, and it works when I input a valid DOB from the table. But how do I go about making it so the user is prompted to enter two dates and the result will display any Avatars with a DOB between them? This is what I have, and I have tried various other ways but nothing has worked thus far.</p>
  
  <p>First try -</p>
  
  <pre><code>WHERE Av_DOB BETWEEN &amp;First + &amp;Second;
  </code></pre>
  
  <p>Second try -</p>
  
  <pre><code>WHERE  Av_DOB=&amp;First AND Av_DOB=&amp;Second;
  </code></pre>
  
  <p>Can someone advise me what the correct way of writing the query is so that I get my desired result? </p>