OraFAQ Forum: SQL & PL/SQL » How do you save your Sqlplus format settings???

Home » SQL & PL/SQL » SQL & PL/SQL » How do you save your Sqlplus format settings???

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

How do you save your Sqlplus format settings??? [message #20241]

Wed, 08 May 2002 11:31

spits
Messages: 2
Registered: May 2002

Junior Member

Hi,

Can your output settings be saved in Sqlplus?? Is it possible to have it saved so when i log into sqlplus and do a query all my heading and break formats are there without having to enter them in on each session??

Report message to a moderator

Re: How do you save your Sqlplus format settings??? [message #20242 is a reply to message #20241]

Wed, 08 May 2002 11:39

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Create or edit a file called login.sql in your bin directory where your Oracle client software is installed. You can place your various settings there that will be persistant.

set numwidth 9
set linesize 78
set ...

Report message to a moderator

Re: How do you save your Sqlplus format settings??? [message #20247 is a reply to message #20242]

Wed, 08 May 2002 13:10

spits
Messages: 2
Registered: May 2002

Junior Member

Thanks alot Todd. That worked out great!!

Report message to a moderator

Previous Topic:	Oracle User Defined Functions
Next Topic:	recordset Paging in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:30:57 CDT 2024