title: Oracle SQL - Form a dummy table from given strings to join with another table
body: <p>There is N no. of strings. </p>
  
  <p>let's say <code>'foo', 'bar', 'chi', 'xyz', 'moo'</code>.</p>
  
  <p>I want to form a dummy table, say X for joining with another table, say Y which has those strings in one of the column i.e name in . Trying to pull out data by running the below query.</p>
  
  <p><code>select Y.name, Y.age
  from(**select ('foo', 'bar', 'chi', 'xyz', 'moo') as name**) X 
  left join Y on X.name = Y.name;</code></p>
  
  <p>I know that text within ** is not the proper SQL syntax, but looking for something similar to have to run query in Oracle SQL.</p>
  
  <p>Any suggestion or ideas most welcome.</p>