Home » SQL & PL/SQL » SQL & PL/SQL » SQL problem
SQL problem [message #379248] Mon, 05 January 2009 12:11 Go to next message
Messages: 2
Registered: January 2009
Junior Member
i have a problem.i want to trasnform my query result.Here is my query result.Table Column and Mapping are the columns of my query.

Table Column Mapping
Table1 A door
Table1 B pencil
Table1 C
Table1 A veli
Table2 B ali
Table2 C kemal
Table3 A paul
Table3 B john
Table3 C hans

and i want to translate mye query result like this:

Table1 Table2 Table3
A door veli paul
B pencil ali john
C kemal hans

I heard that i can do this with pl/sql.
onyone help me?
Re: SQL problem [message #379253 is a reply to message #379248] Mon, 05 January 2009 12:26 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ, search for "row to column".

In addition, 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.
Use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).


[Updated on: Mon, 05 January 2009 12:27]

Report message to a moderator

Previous Topic: Counts for all dates in a given month
Next Topic: This 9i code is throwing error "ORA-06503: Function returned without value" when executed
Goto Forum:

Current Time: Wed Oct 26 10:58:26 CDT 2016

Total time taken to generate the page: 0.05802 seconds