| SQL problem [message #379248] |
Mon, 05 January 2009 12:11  |
ismailklc84
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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).
Regards
Michel
[Updated on: Mon, 05 January 2009 12:27] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
