Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question
epipko_at_gmail.com wrote:
> Hi all,
> I have a table with 5 rows in it:
>
> column1
> -----------
> a,
> b,
> c,
> d
>
> I need to be able to pull 10 values where missing values are NULL:
>
> column1
> ------------
> a,b,c,d,e,,,,,,
>
>
> Thanks,
> Eugene
Not completely sure if this answers your question, but if it's about
string aggregation have a look at
http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php
Received on Tue Aug 22 2006 - 01:44:25 CDT