PL SQL table variable - liamlamth/blog GitHub Wiki

select column_value
from   table (sys.odcivarchar2list (                                         --odcinumberlist
                'text_a',
                'text_b',
                'text_c'
                )
             )
--where column_value not in (select verify_column from verify_table)         --check if value is not in the table