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: 64967
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).

Previous Topic: Scheduler not running for users other than sys
Next Topic: Index not used
Goto Forum:

Current Time: Thu Jun 29 11:11:25 CDT 2017

Total time taken to generate the page: 0.19466 seconds