Re: select from a list where not in a table

I think a PL /Sql table should help u to store the records .... if you want to make the data in it to be persistant you could always declare it in a package !!!

Then doin a not in should solve ur problem. But i think a join would be a better option
cause a not in will do a full table scan. Received on Tue Dec 14 2004 - 03:01:06 CST