OraFAQ Forum: SQL & PL/SQL » About Linesize and Pagesize in SQL Plus.........

Home » SQL & PL/SQL » SQL & PL/SQL » About Linesize and Pagesize in SQL Plus.........

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About Linesize and Pagesize in SQL Plus......... [message #7548]

Fri, 20 June 2003 04:53

BABU SRSB
Messages: 42
Registered: June 2002

Member

Hi All,

My default values of
LineSize = 100
PageSize = 80
in my SQL Plus.
So, every time i am changing these to my requirement.

How can i change these default values to
LineSize = 1000
PageSize = 800

I heard, in one of oracle files, we can set these parameters. I am using Oracle 8i client version.

Can any one please suggest me on this..

Awaiting the response.

Yours,

Babu.

Report message to a moderator

Re: About Linesize and Pagesize in SQL Plus......... [message #7549 is a reply to message #7548]

Fri, 20 June 2003 06:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

every oracle client/server installation has a glogin.sql
in $ORACLE_HOME/sqlplus/admin.
add your entries here ( the set commands)
set pagesize 100
set linesize 1000 etc at the end of the file.
this file is read by sqlplus and executed everytime you login.

Report message to a moderator

Re: About Linesize and Pagesize in SQL Plus......... [message #7551 is a reply to message #7549]

Fri, 20 June 2003 08:38

BABU SRSB
Messages: 42
Registered: June 2002

Member

Thanks a lot Mahesh....

Regards,

Babu.

Report message to a moderator

Previous Topic:	Max function in oracle9i
Next Topic:	Outer joint using upper and trim

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 00:06:05 CDT 2024