| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> Re: help with a query
Because, probably.
This is what you want:
SET COLSEP |
<tommychill_at_my-deja.com> wrote in message
news:8nuv5s$jqt$1_at_nnrp1.deja.com...
> Why do you need to display the data in such a manner?
>
>
>
> In article <8nuo36$bm5$1_at_nnrp1.deja.com>,
> Jorge Castro <jrcastro_at_ceibo.entelnet.bo> wrote:
> > and I want to make a query that show it like this:
> >
> > TYPE1|VALUE1|TYPE2| VALUE2|TYPE0|VALUE0|
> > -----|------|-----|-------|-----|------|
> > 0| 5000| 4| 676,85| 19| 0|
> > 1| 10| 5|1068,75| 20| 0|
> > 2| 2000| 6| 85,5| 21| 0|
> > 3| 15| 14| 0| 22| 0|
> > 7| 200| 15| 456| 23| 100|
> > 8| 800| 16| 20| 24| 0|
> > 9| 25| 17| 45| | |
> > 10| 0| 18| 45| | |
> > 11| 500| | | | |
> > 12| 0| | | | |
> > 13| 0| | | | |
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 23 2000 - 09:08:49 CDT
![]() |
![]() |