Hi ,

Whenever i am opeening my sq; * plus session i have to set the below mentioned variables in order to use it comfortably :-
set linesize 30000
set pagesize 30000
set sqlprompt PRODA>

but rather typing it everytime i open a new sesion i have created a sql file having these settings and i am openning the file using the editor but it is not changing the settings.

PFA the screenshot.

Please advice

Subhotech

Put all those settings into a LOGIN.SQL file (which should be in a directory you use when connecting to SQL*Plus). Alternatively, to use it always, create a GLOGIN.SQL file ("global") (it should be located in your ORACLE_HOME\SQLPLUS\ADMIN directory).

Google for more information.

Thanks! for the info ....i did some google found some more info..
Actually i am working on a remote machine and i dont have access to Oracle installation directory.i.e ADMIN etc
So i have stored the current setting into a file using STORE SET FILE_NAME which stores all the env variables and then i modiefied the variables . On logging to a new session i can use START FILE_NAME TO use the new settings.

You don't need access to the Oracle installation.

login.sql is stored locally on your computer where you run SQL*Plus

See the manual for details

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref410