Prev: Fueling your car with natural gas from home
Next: connect to external DB ( sqlserver ) via JDBC
From: Spendius on 22 Jun 2010 10:31
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
From: Michel Cadot on 22 Jun 2010 11:08

"Spendius" <spendius(a)muchomail.com> a �crit dans le message de news:
b1b53aae-c02d-4218-a003-50b95eca82c7(a)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


 | 
Pages: 1
Prev: Fueling your car with natural gas from home
Next: connect to external DB ( sqlserver ) via JDBC