I need to allow my users to type in a list of names and return the names that are not in a table.
1. User types [ Tom Joe Bob MIKE ] into a Text Area item named :P2_NAME_CHECK
2. A table named CUST contains two rows with TOM and Bob in the
3. A report returns two rows JOE and MIKE.
Usually, it is oposite. You want to show the list of users that match the criteria.
The solution for this problem is quite easy if you know how to use pipelined functions. This is a case where the pipelined functions shine. I created an example in my Demo Application showing how this can be done.
Basically, the pipelined function will create a row for all substrings returning no rows from the emp table, showing those substrings as rows.