Home » SQL & PL/SQL » SQL & PL/SQL » Need help formatting output from a SQL search (SQL*Plus: Release 9.2.0.7.0)
Need help formatting output from a SQL search [message #398235] Wed, 15 April 2009 13:32 Go to next message
funnymanb
Messages: 2
Registered: April 2009
Junior Member
I have a table that I need to get all the info out of in a concise manner...how do I get these tables to show up aligned?

My select statement:
select * from ppr_profile;


Output:

PPR_PROFILE_ID DEFAULT_PARTITION_ID START_LOCATION TOTAL_DIGITS
----------------------- ----------------------- -------------- ------------
PARTITION_OFFSET PARTITION_LENGTH MIN_LENGTH PREFIX_DIG SUFFIX_DIG ATTRIBUTES1
---------------- ---------------- ---------- ---------- ---------- -----------
ATTRIBUTES2
-----------

MINT-GAMMA_DMS 0 5
2 3 1 11 14
0

MINT-GAMMA_SIP 0 5
2 3 14 11 14

PPR_PROFILE_ID DEFAULT_PARTITION_ID START_LOCATION TOTAL_DIGITS
----------------------- ----------------------- -------------- ------------
PARTITION_OFFSET PARTITION_LENGTH MIN_LENGTH PREFIX_DIG SUFFIX_DIG ATTRIBUTES1
---------------- ---------------- ---------- ---------- ---------- -----------
ATTRIBUTES2
-----------
0

MINT-GAMMA_SIP_test 0 5
2 3 14 11 14
0


As you can see the spacing does not allow the columns to line up... how do I do this to a file and in the window itself? Thanks.
Re: Need help formatting output from a SQL search [message #398242 is a reply to message #398235] Wed, 15 April 2009 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set lines 30000
set pages 30000

Regards
Michel
Re: Need help formatting output from a SQL search [message #398251 is a reply to message #398242] Wed, 15 April 2009 14:16 Go to previous message
funnymanb
Messages: 2
Registered: April 2009
Junior Member
Thank you Michal. As you can tell I am new to the world of SQL.



Barrett
Previous Topic: ROLE ASSIGNING (merged 3)
Next Topic: Multiple Column Subquery restricting rows
Goto Forum:
  


Current Time: Sat Dec 10 11:04:23 CST 2016

Total time taken to generate the page: 0.07576 seconds