title: ACCEPT Multiple Variables into SQL
body: <p>Is there any way to have a user enter a list of values into an ACCEPT in SQL Developer?
  i.e.:</p>
  
  <pre><code>ACCEPT USER_ENTRY CHAR PROMPT 'Please enter values'
  
  select *
  from my_table
  where my_id in('&amp;USER_ENTRY')
  </code></pre>
  
  <p>Of course this works with a single value but I cannot find a solution to make it work with multiple values. For example if I wanted to select the details for ID '1' and '2'.</p>
  
  <p>I am aware of loading the information into a temporary table and querying against that, but I'd rather avoid that if possible due to the nature of the project (users will call this script using a 'front end' script using <code>@"MY_FILE_LOCATION\MY_SCRIPT.sql";</code> and so will not be able to see the actual script that they are running but will need to enter multiple values).</p>