epipko_at_gmail.com wrote:
> 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
>
It is not NULLs you want it is commas. Count the number of real values,
or if you wish commas, then RPAD on the missing commas.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 22 2006 - 13:12:05 CDT
