Skip to Main Content

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!

How to return data in tabular form on Oracle 8.0

Hello. On one of my servers I still have Oracle 8.0.5 and I want to implement a query to select from different tables and return data in tabular form. Unfortunately, in this version is not possible to use “PIVOT” and, if I am not mistaken, “CASE” and “IF-THEN-ELSE ” as well. Do you know how to get what I want? Thank you

This post has been answered by Frank Kulash on Aug 2 2025
Jump to Answer
Comments
Post Details
Added 3 days ago
2 comments
54 views