Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to show SQL output in 1 ROW instead of normal multiple lines?

SebaVastaFeb 20 2024 — edited Feb 20 2024

How to show 2 rows from this SQL in one line like “A, B”. Our DB is 11g R2.

SELECT *
FROM
(
SELECT 'A' f1 FROM DUAL
UNION
SELECT 'B' FROM DUAL
);

This post has been answered by BluShadow on Feb 20 2024
Jump to Answer
Comments
Post Details
Added on Feb 20 2024
1 comment
107 views