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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FAQ - Transposing data using pure SQL

Status
Not open for further replies.
taupirho

taupirho

Programmer
Jun 25, 2002
680
GB
I finally got around to writing something about the methodology for transposing row data to column data using plain vanilla SQL. Basically its just a reiteration of my answer to the thread below but I've also included another method for doing the same thing if you have happen to have Oracle XML DB installed also.

The link below is the orginal thread I answered


And the FAQ link is


Cheers


In order to understand recursion, you must first understand recursion.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
813
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
242
TheLazyPig
TheLazyPig
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
279
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
316
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top