title: Sql in oracle to find out missing records from its distinct values
body: <p>I am sorry , this one is not working... May be I should have clarified this earlier. The values A,B,C,D etc... Are the Distinct values for CODE in the Table. There are several hundreds of IDs in the table and each ID can have one to many Code values. In the above example assume that there are 5 distinct values of Code from table A. There are 3 IDs and each ID is associated in Table A as follows</p>
  
  <p>ID    Code
  1      A
  1      B
  1      C
  2      D
  2      A
  3      B
  3      C
  4      A
  4      B
  4      C
  4      D
  4      E</p>
  
  <p>As you see above there are several IDs associated with different Code values. I need the result as follows</p>
  
  <p>ID   CODE
  1     D
  1     E
  2     B
  2     C
  2     E
  3     A
  3     D
  3     E</p>
  
  <p>ID 4 should not return anything because it contain all possible Codes (in this case A,B,C,D,E)</p>