Home » SQL & PL/SQL » SQL & PL/SQL » Page Size and Line Size (Oracle 10g)
Page Size and Line Size [message #352831] Thu, 09 October 2008 17:23 Go to next message
Messages: 89
Registered: May 2005
Location: chennai

I want to display the results in SQLPLUS to be properly aligned.

I tried with different page size and line size, but it doesnt met my results.

Can anyone advice anyother way (some standard options) to make it properly ordered on displaying the results.

Thanks and Regards
Re: Page Size and Line Size [message #352832 is a reply to message #352831] Thu, 09 October 2008 17:37 Go to previous message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
13 SQL*Plus Command Reference

SET command controls most of the formatting options in SQLPLUS.

COLUMN command also plays a significant role in formatting output.

To a lesser extent the following also have an affect on formatting returned rows:


Both SET and COLUMN have many many options so I would bet what you need is there.

Without a visual example of what you are looking for, I can't give you more at this time.

Good luck, Kevin
Previous Topic: SQL Query Problem distinct results
Next Topic: Union - How to populate null field
Goto Forum:

Current Time: Fri Jul 28 14:29:28 CDT 2017

Total time taken to generate the page: 0.09875 seconds