Xref: alice comp.databases.oracle.misc:30602
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.clear.net.nz!news.clear.net.nz!not-for-mail
Reply-To: "CL" <charlie@xenacom.co.nz>
From: "CL" <charlie@xenacom.co.nz>
Newsgroups: comp.databases.oracle.misc
Subject: SQL translation problem
Lines: 18
Organization: Xenacom
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.0810.800
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800
Message-ID: <H_7Y2.10$o1.70@news.clear.net.nz>
Date: Thu, 6 May 1999 15:37:53 +1200
X-Trace: news.clear.net.nz 925961255 203.97.53.124 (Thu, 06 May 1999 15:27:35 NZST)
NNTP-Posting-Date: Thu, 06 May 1999 15:27:35 NZST

Hi
I am doing a job to rewrite a interface from ACCESS to ORACLE. I meet a
problem.
How can I translate the following query to Oracle SQL? I can do that in my
report.
It is a simple table with columns CAT, CODE, PRICE1, PRICE2...

TRANSFORM Avg([PRICE1]) AS [The Value]
SELECT [CODE]
FROM ITEMS
GROUP BY [CODE]
PIVOT [CAT];

Many thanks

Charles