Re: What happens when I log on to SQLPlus

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Sun, 21 Apr 2002 10:43:00 +0200
Message-ID: <a9tu1k$eht$1@news1.xs4all.nl>

Indead, first $ORACLE_HOME/sqlplus/admin/glogin.sql is run. Then sqlplus looks for a file named login.sql in the current directory. If it's not there it searches all directories listed in $ORACLE_PATH variable.
The first login.sql file found is run.

Same applies for Oracle on Windows NT: glogin.sql in the Oracle home sqlplus\admin dir
Then the first login.sql file found in:
a. the current dir (when you used the installed shortcut: the oracle home \bin subdirectory)
b. if set the directories listed in the variable %SQLPATH%. c. the directories listed in registry key \\HKLM\Software\Oracle\HOME<n>\SQLPATH

Use this variable or registry key to include the directories where you store your sql scripts in. Sqlplus will find them then regardless the current directory from where it started.

Pinaki <bpinaki123_at_indiatimes.com> schreef in berichtnieuws 96eccafc.0204201017.70a659a1_at_posting.google.com...
> Hi,
> I have a simple question to ask.Which script does Oracle execute
> when I click on the sqlplus icon(enter the username,password and
> hoststring) and create a session with Oracle...
>
> Thanks,
> Pinaki
Received on Sun Apr 21 2002 - 03:43:00 CDT