Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cross Table
hello
First i want to thank you ..for your moment. The idea of Cross table is to be able writing queries without values ...
Decode is ok, but is wery slopy way (and been used now).
Problem occurs when those values change and what worse they keep
growing.
Now imagine me sitting after work in office and searchin for those
values just to change several
queries ...true its not a big deal... well not now but ..if i manage to
sell my app to several other
firms ....well...i dont wanna see this movie !!
thnx in advance Edo
Connor McDonald wrote:
> Check out decode which will achieve this as long as one of the
> dimensions is finite...
>
> eg
>
> select decode(code,'A1',cost,0) a1,
> decode(code,'B2',cost,0) b2,
> decode(code,'H',cost,0) h,
> ...
> from table;
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Tue Oct 12 1999 - 03:03:02 CDT