Re: display rows beside each-other

Ronald wrote:
>
> hi, thanks.
>
> It's only for a max of 2 or 3 records (about 30 char long total.)
>
> But so far I see this only works on plsql isn't it ?
>
> Is there also a sql (beside plsql) solution ?
>
> Ronald.

check out LAG and LEAD to get the next/prev row relative to the current one.

or hunt around for the OCI aggregate functions which let you build your own string concat function

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------