Inverse function of ODCINumberList ?

From: Spendius <spendius_at_muchomail.com>
Date: Tue, 22 Jun 2010 07:31:13 -0700 (PDT)
Message-ID: <b1b53aae-c02d-4218-a003-50b95eca82c7_at_q12g2000yqj.googlegroups.com>



Hi,
The ODCINumberList function allows you to to: SQL> select * from table(sys.odcinumberlist(1,2,9));

COLUMN_VALUE


           1
           2
           9

=> is there another function that would make the other
way around and take a tabular result set of a single column to make a list of it ?, kind of:
SQL> select tabToList(rownum) from all_objects where rownum <5;

    TABTOLI


         1, 2, 3, 4

Thanks...
Regards,
Spendius Received on Tue Jun 22 2010 - 09:31:13 CDT

Original text of this message