Home » RDBMS Server » Server Utilities » sql plus
sql plus [message #70554] Fri, 28 June 2002 07:11 Go to next message
Javier
Messages: 8
Registered: April 2001
Junior Member
hy everybody, in my work I always use oracke sql *plus, but every time i open it, a have to do:
set line 1000
set pagesize 20
set pause on
and I also have to go to enviroment, and set a variable to 20
How can I set these value for default.

Thanks a lot
Re: sql plus [message #70556 is a reply to message #70554] Fri, 28 June 2002 07:18 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
add these environment settings to the glogin.sql.
it will be available at
$ORACLE_HOME/sqlplus/admin
Previous Topic: how to import procedure
Next Topic: Re: how to copy table from user to another user
Goto Forum:
  


Current Time: Mon Dec 23 06:29:31 CST 2024