SQL translation problem

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 Received on Wed May 05 1999 - 22:37:53 CDT