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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,501 views