Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question
I've done it via function call from sql, but how do I append another 5
NULLs to it?
steph wrote:
> 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 - 10:32:26 CDT