Home » SQL & PL/SQL » SQL & PL/SQL » How to Use Cross Tab query (oracle 10g)
How to Use Cross Tab query [message #407030] Mon, 08 June 2009 03:59 Go to next message
Messages: 1
Registered: June 2009
Location: progammer
Junior Member

Hi All,

I have query in MS-Access but i need to covert it in Oracle Query. I have tried lot but i didn't get proper solution:

MS-Access Query..

TRANSFORM First(table1.A) AS temp
SELECT table1.ID1
, table1.ID2
, table1.ID3
FROM table1 LEFT JOIN table2
ON table1.A = table2.A
WHERE table1.ID1="123456789"
AND table1.ID2=0
GROUP BY table1.ID1
, table1.ID2
, table1.ID3
PIVOT table2.A In (1,2,3,4,5,6,7,8,9);
Re: How to Use Cross Tab query [message #407037 is a reply to message #407030] Mon, 08 June 2009 04:13 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post a working Test case: create table and insert statements along with the result you want with these data.

Before Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Next Topic: Fill the Blank Values with Data (merged 3)
Goto Forum:

Current Time: Sat Aug 19 08:18:17 CDT 2017

Total time taken to generate the page: 0.04639 seconds