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!

side by side layout for 2 queries

Scott HollowsJan 9 2010 — edited Jan 10 2010

I need to do a side by side layout of 2 queries in SQL*Plus to meet some tight layout restrictions.

Query 1 			Query 2
col1	col2	col3		col1	col2	col3
xxxx	xxxx	xxxx		xxxx	xxxx	xxxx
xxxx	xxxx	xxxx		xxxx	xxxx	xxxx
xxxx	xxxx	xxxx		xxxx	xxxx	xxxx
xxxx	xxxx	xxxx		
xxxx	xxxx	xxxx

A solution that works for more than 2 queries would be nice but not essential

The number of rows will be no more than 40
The number of rows might be different in each query.

I am considering moving the queries into PL/SQL and use DBMS_OUTPUT to do this, but I dont want to reinvent the wheel if there is an easier solution

Environment - Unix / Linus, Windows, Oracle database v10 (8 and 9 desirable).

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2010

Added on Jan 9 2010

3 comments

3,170 views