114. SPECIAL FILES

LOGIN.sql

If you would like SQL PLUS to define your own environmental settings, put all the required commands in a file named login.sql. This is a special filename that SQL PLUS always looks for whenever it starts up. If it finds login.sql, it executes any commands in it as if you had entered then by hand. You can put any command in login.sql that you can use in SQL PLUS, including SQLPLUS commands and SQL statements. All ot them executed before SQL PLUS gives you the 

SQL> prompt.

GLOGIN.sql

This is used in the same ways as LOGIN.sql but to establish default SQL PLUS settings for all users of a database.