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: <epipko_at_gmail.com>
Date: 22 Aug 2006 08:32:26 -0700
Message-ID: <1156260746.414580.153300@p79g2000cwp.googlegroups.com>


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

Original text of this message

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