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.

It can be done with both DECODE and CASE. http://www.psoug.org
click on Morgan's Library
click on DECODE and look at the pivot table demos

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)