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!

Display output in horizontal rows

711216Dec 23 2009 — edited Dec 23 2009
Hello all,

Please help me how to display the out put of count of the below queries in horizontal rows.

select count(*) "test1" from oe_headers_all where customer_po_number like 'consign-%'

select count(*) "test2" from oe_headers_all where customer_po_number like 'non-consign-%'

select count(*) "test3" from oe_headers_all where customer_po_number like 'REGULAR%'

select count(*) "test4" from oe_headers_all where customer_po_number like 'NON-REGULAR%'


tes1 test2 test3 test4
---- ----- -------- ------
20 50 30 40

Regards,
Kiran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2010
Added on Dec 23 2009
12 comments
1,522 views