 | |
#1
 
| |||
| |||
|
Column into Row -
09-03-2009
, 06:45 AM
#2
| |||
| |||
|
|
Hi all, I have a table like this .. Name * * ID -------- * * ---- A * * * * * *1 B * * * * * *2 C * * * * * *3 D * * * * * *4 E * * * * * *5 If table is queried , I need like .. Name * * A * * B * * *C .. ID * * * * * 1 * * 2 * * * 3 .. Can anyone help me on this issue ? Thanx, Keerthi c |
options for providing that output vary with the age of the release.
Post your version to 4 or 5 numbers so someone can help you without
guessing.
David Fitzjarrell
#3
| |||
| |||
|
|
Hi all, I have a table like this .. Name * * ID -------- * * ---- A * * * * * *1 B * * * * * *2 C * * * * * *3 D * * * * * *4 E * * * * * *5 If table is queried , I need like .. Name * * A * * B * * *C .. ID * * * * * 1 * * 2 * * * 3 .. Can anyone help me on this issue ? Thanx, Keerthi c |
you probably want to do is called pivoting. There have been several
posts on the subject in the past. There are several approaches but
some require more recent versions of Oracle. Indeed 11g includes a
command to pivot data. You can seach the archives to find some
possible solutions.
HTH -- Mark D Powell --
#4
| |||
| |||
|
|
On Sep 3, 6:45*am, keeri <ck.keer... (AT) gmail (DOT) com> wrote: Hi all, I have a table like this .. Name * * ID -------- * * ---- A * * * * * *1 B * * * * * *2 C * * * * * *3 D * * * * * *4 E * * * * * *5 If table is queried , I need like .. Name * * A * * B * * *C .. ID * * * * * 1 * * 2 * * * 3 .. Can anyone help me on this issue ? Thanx, Keerthi c Knowing the version of Oracle you're using helps tremendously as the options for providing that output vary with the age of the release. Post *your version to 4 or 5 numbers so someone can help you without guessing. David Fitzjarrell |
Hi David,
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Can anyone help .. ?
Thanks,
Keerthi C
#5
| |||
| |||
|
|
On Sep 3, 6:11*am, ddf <orat... (AT) msn (DOT) com> wrote: On Sep 3, 6:45*am, keeri <ck.keer... (AT) gmail (DOT) com> wrote: Hi all, I have a table like this .. Name * * ID -------- * * ---- A * * * * * *1 B * * * * * *2 C * * * * * *3 D * * * * * *4 E * * * * * *5 If table is queried , I need like .. Name * * A * * B * * *C .. ID * * * * * 1 * * 2 * * * 3 .. Can anyone help me on this issue ? Thanx, Keerthi c Knowing the version of Oracle you're using helps tremendously as the options for providing that output vary with the age of the release. Post *your version to 4 or 5 numbers so someone can help you without guessing. David Fitzjarrell Hi David, Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 Can anyone help .. ? Thanks, Keerthi C- Hide quoted text - - Show quoted text - |
http://asktom.oracle.com/pls/asktom/...D:419593546543
David Fitzjarrell
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.