OraFAQ Forum: SQL & PL/SQL » PL/SQL Environment

Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL Environment

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

PL/SQL Environment [message #36822]

Sun, 23 December 2001 21:02

j.smith
Messages: 21
Registered: December 2001

Junior Member

I need to permentatly change the default environment for sqlplus.

i tried
set linesize 100
set pagewidth 20

i also tried:
the manual environment settings in sqlplus
COMMIT, EXIT

they all work for the user session,
but when i close the sqlplus program and logon again
they are set back to their default.

how do i change the environment so that evertime i log back into sqlplus, it keeps the environment i set?

Should run a script that loads evertime sqlplus loads? or is there a easier way?

please advise...

----------------------------------------------------------------------

Report message to a moderator

Re: PL/SQL Environment [message #36823 is a reply to message #36822]

Sun, 23 December 2001 21:31

hnetscape
Messages: 30
Registered: December 2001
Location: India

Member

Hi,
Open file oracle_homeplus32glogin.sql and
add this
set linesize 100
set pagewidth 20
and save the file
and exit from sql and reload then it will set it.

Hope this will help you.

Balraj.

----------------------------------------------------------------------

Report message to a moderator