Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql question

Re: sql question

From: steph <stephan0h_at_yahoo.de>
Date: 21 Aug 2006 23:44:25 -0700
Message-ID: <1156229065.297109.170250@m73g2000cwd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US