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 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 );