title: How can I select from list of values in Oracle
body: <p>I am referring to this <code>stackoverflow</code> answer:</p>
  <p><a href="https://stackoverflow.com/questions/1564956/how-can-i-select-from-list-of-values-in-sql-server/7285095#7285095">How can I select from list of values in SQL Server</a></p>
  <p>How could something similar be done in <strong>Oracle</strong>?</p>
  <p>I've seen the other answers on this page that use <code>UNION</code> and although this method technically works, it's not what I would like to use in my case.</p>
  <p>So I would like to stay with syntax that more or less looks like a comma-separated list of values.</p>
  <p><strong>UPDATE</strong> <em>regarding the <code>create type table</code> <a href="https://stackoverflow.com/questions/10353969/how-can-i-select-from-list-of-values-in-oracle/10354083#10354083">answer</a></em>:</p>
  <p>I have a table:</p>
  <pre><code>CREATE TABLE BOOK
  (   &quot;BOOK_ID&quot; NUMBER(38,0)
  )
  </code></pre>
  <p>I use this script but it does not insert any rows to the <code>BOOK</code> table:</p>
  <pre><code>create type number_tab is table of number;
  
  INSERT INTO BOOK (
      BOOK_ID
  )
  SELECT A.NOTEBOOK_ID FROM
      (select column_value AS NOTEBOOK_ID from table (number_tab(1,2,3,4,5,6))) A
  ;
  </code></pre>
  <p>Script output:</p>
  <pre><code>TYPE number_tab compiled
  Warning: execution completed with warning
  </code></pre>
  <p>But if I use this script it does insert new rows to the <code>BOOK</code> table:</p>
  <pre><code>INSERT INTO BOOK (
      BOOK_ID
  )
  SELECT A.NOTEBOOK_ID FROM
      (SELECT (LEVEL-1)+1 AS NOTEBOOK_ID FROM DUAL CONNECT BY LEVEL&lt;=6) A
  ;
  </code></pre>