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
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

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
Prashanth
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: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
13 SQL*Plus Command Reference

Quote:
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:

Quote:
ATTRIBUTE
BREAK

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: Sun Dec 04 08:55:02 CST 2016

Total time taken to generate the page: 0.05340 seconds