login.sql

Do you get frustrated that every time you start SQL*Plus that you have to set your environment variables i.e. linesize, pagesize etc. yet again.

Well there is an easier way!

As Unix users are aware there is a file called .profile that is executed each time they login, Oracle also has a similar file.

You guessed it, the file is called login.sql .

The login.sql file allows you to enter a SET environment variable statement on each line. There is no limit on the number of statements the login.sql file can contain.

If we enter the following lines into the login.sql file.

    set feedback 1
    set pagesize 100
    set linesize 100

Then start a sql*plus session and type 'show all' from the sql*plus prompt you will see that the above environment variables have already been set.

Exit to : Oracle Hints and Tips