Inverse function of ODCINumberList ?

#1

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

#2

"Spendius" <spendius (AT) muchomail (DOT) com> a écrit dans le message de news:
b1b53aae-c02d-4218-a003-50b95eca82c7...oglegroups.com...

Quote:

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

SYS_CONNECT_BY_PATH

Regards
Michel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Inverse function of ODCINumberList ?

comp.databases.oracle.server comp.databases.oracle.server

Inverse function of ODCINumberList ? - 06-22-2010 , 09:31 AM

Re: Inverse function of ODCINumberList ? - 06-22-2010 , 10:08 AM