Re: Inverse function of ODCINumberList ?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 22 Jun 2010 17:08:48 +0200
Message-ID: <4c20d1fe$0$23057$426a74cc_at_news.free.fr>
Date: Tue, 22 Jun 2010 17:08:48 +0200
Message-ID: <4c20d1fe$0$23057$426a74cc_at_news.free.fr>
"Spendius" <spendius_at_muchomail.com> a écrit dans le message de news:
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
SYS_CONNECT_BY_PATH
Regards
Michel
Received on Tue Jun 22 2010 - 10:08:48 CDT