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@xxxxxxxxx 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

.

Relevant Pages

  • Re: sql question
    ... NULLs to it? ... steph wrote: ... then RPAD on the missing commas. ...
    (comp.databases.oracle.server)
  • Re: Difference between = and IN
    ... I was under the impression that Nulls would just be excluded from the ... Hi Andy, ... AND Column1 NULL ... that the 40 is NOT IN (your age, George W. Bush's age, my age)? ...
    (microsoft.public.sqlserver.mseq)