Re: How do I return a column into a row ?

Sorry, you misunderstood my last post.

I only created the temp table to create some test data and to provide a working example which anyone could try out, concentrate on the SQL to produce your required results.
I'm assuming that you have your tables set up already, all you need is the SQL to get results. You shouldn't need a temp table yourself.

M

C Chang <cschang_at_maxinter.net> wrote in message news:<3C5B67A8.355_at_maxinter.net>...

<snip>

> Thanks Mark. However, I am not sure this is practical. Not only it
> uses an run-time temp table, but there are 10000 ( 10000 IDs) inserts to
> create it, my client probably does not have time to wait it to finish.
> I will keep looking an efficient way. Actually, I am thinking a select
> procedure like this:
> SELECT ID, f(ID) from my_table ..
>
> where the f(ID) is a function return VARCHAR2, in which the return
> string is as A/4;B/10;C/2 .... But the problem is how to return an
> array in order of A,B,C even some of missing like ID=3.
> Thanks anyway.
>
> C Chang
Received on Mon Feb 04 2002 - 04:18:39 CST