Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does Oracle8 support native crosstab queries?
No native cross-tab queries, but you can *emulate* a crosstab using the
DECODE function. Take a look in the documentation. Using the DECODE
function will probably be more efficient than doing a more common select and
cross-tabbing it in the application (less data sent out on response).
Good luck,
Dave
vjavaly_at_hotmail.com wrote in message <6qmu8l$cl9$1_at_nnrp1.dejanews.com>...
>Does Oracle8 have a native crosstab query capability (i.e. MS Access:
>TRANSFORM - SELECT - PIVOT)? I'm testing "generating SQL at runtime"to
>emulate this function.Any ideas? Thank you.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 10 1998 - 17:00:05 CDT