Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transposing Rows into Columns (Except the number of columns could vary)

Roxy rollersNov 23 2020

I am trying to transpose rows into columns but my rows per student are not always the same because different students take different classes. I have created three tables where STUDENT_CLASS_TB is my table and I have dummy tables STUDENT_1001_TB and STUDENT_1002_TB to merely show how I want the data to be displayed by Student. My Query needs to work for only 1 Student at a time.
I am attaching Scripts:
student_tables_23NOV2020.txt (3.14 KB)I had to suffix file with .TXT as it did not like a .SQL extension.
Thanks in advance.
This post has been answered by Frank Kulash on Nov 24 2020
Jump to Answer

Comments

Post Details

Added on Nov 23 2020
#pivot, #sql
5 comments
64 views
1 mention