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));
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