I would be very grateful if somebody could help, I am trying to generate a report and to do this I have to flatten out data. I am using Oracle stored procedures and would like to produce a means of storage (like a record) whos attributes are defined as transposed rows, is this possible. Thanks Jaime
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating record from transposed row as column header
- Thread starter Jaime13
- Start date
SantaMufasa
Technical User
Jaime,
Certainly what you want is possible. To illustrate, it would be most useful if you could post a simple example of what you want including table structure, sample data, and results you want from the sample data.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 16:45 (15Apr04) UTC (aka "GMT" and "Zulu"), 09:45 (15Apr04) Mountain Time)
Certainly what you want is possible. To illustrate, it would be most useful if you could post a simple example of what you want including table structure, sample data, and results you want from the sample data.
Mufasa(aka Dave of Sandy, Utah, USA @ 16:45 (15Apr04) UTC (aka "GMT" and "Zulu"), 09:45 (15Apr04) Mountain Time)
- Status
Similar threads
