Re: What happens when I log on to SQLPlus

absolutely you can edit the glogin.sql file for custom prompts etc (and a slew of of other things can be done as well).

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:446220075876 http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:928829365838

Pinaki wrote:
>
> Hi,
> Thanks for the replies...But can I edit the glogin.sql
> file.Suppose I want to change the sql prompt(SQL>) to something
> else.Not for the particular session(this I can can change from the
> enviornment settings) but whenever I login through SQLPLus.
>
> Pinaki
>
> "Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:<a9tu1k$eht$1_at_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 - 14:20:28 CDT