title: sql - single query to return values that are not present
body: <p>For example, you have a simple table with just one column.
  ie.</p>
  
  <pre><code>CREATE TABLE movies   (title VARCHAR2(255 BYTE))
  </code></pre>
  
  <p>set up with the following data:</p>
  
  <pre><code>INSERT INTO movies   (title) VALUES ('Scream');
  INSERT INTO movies   (title) VALUES ('Blair Witch');
  INSERT INTO movies   (title) VALUES ('Friday the 13th');
  INSERT INTO movies   (title) VALUES ('Scary Movie');
  INSERT INTO movies   (title) VALUES ('Hide and Seek');
  INSERT INTO movies   (title) VALUES ('Alien vs Predator');
  </code></pre>
  
  <p>Is there a single query or PL/SQL that will do the following dynamically (ie without having to manually do a "UNION select 'scream' from dual..." for every value)?</p>
  
  <p>Obviously this query is wrong but you get the idea:</p>
  
  <pre><code>Select * from movies
  where title in (
  'Scream',
  'Scary Movie',
  'Exorcist',
  'Dracula',
  'Saw',
  'Hide and Seek'
  )
  </code></pre>
  
  <p>Desired result being a record for every value in the "WHERE TITLE IN" clause where the record is not present in the table.
  ie.</p>
  
  <pre><code>'Exorcist'
  'Dracula'
  'Saw'
  </code></pre>