Lists as tables in Oracle

 No Responses »
Jul 242015
 

While searching for a way to find records in a table that best match what I’m looking for, I just discovered (Google is your friend) Oracle’s sys.odcinumberlist and sys.odcivarchar2list. Very nice functions to create in-memory tables.

SQL> select * from table(sys.odcivarchar2list('a',null,'b','c'));

COLUMN_VALUE
--------------
a

b
c

Never too old to learn new tricks….