| Oracle SQL how to [message #71253] |
Tue, 01 October 2002 09:37  |
Ian Crawford
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
I've got an SQL problem that I haven't found an answer to. I want to run a query & get the results to show in one row, not a seperate row for each returned result e.g.
Instead of
Key1 value1
Key1 value2
Key1 value3
I want
Key1 value1 value2 value3
Thanks.
|
|
|
|
| Re: Oracle SQL how to [message #71264 is a reply to message #71253] |
Thu, 03 October 2002 10:11  |
Roy
Messages: 30
Registered: May 2002
|
Member |
|
|
|
You've to use some reporting tool. This is called cross tab formatting of output. REporting tools such as crystal, access and several others support this format. But you might want to post this in the Oracle reports forum and see if you can format things in this way.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
