
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
I have a list of 100 SSNs, say. There is a table that stores SSNs. this table has 60 of the 100 SSNs. Is it possible to write a query that gives me the 40 SSNs that are not there - without using temp tables/inserts in to any table and without writing PL/SQL(meaning without writing to files/using looping constructs etc.). I want to avoid getting the 60 SSNs that are there in the table, bumping it up against the 100 using other tools.. It all boils down to : how to convert a comma-seperated list to a record set/query output using just a query ? Any pointers will be greatly appreciated... Thanks.
| <-- __Chronological__ --> | <-- __Thread__ --> |