Re: Oracle 9i | login.sql does not run on login by default

In my experience, under Unix, Oracle looks for login.sql in your current directory. If none is found, it looks for login.sql in $SQLPATH

hth

Bon-Minh Lam

Anoop schrieb:

> $ sqlplus user/passwd_at_cdb
>
> SQL*Plus: Release 9.2.0.8.0 - Production on Wed Jan 10 07:12:24 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Release 9.2.0.8.0 - 64bit Production
> JServer Release 9.2.0.8.0 - Production
>
> SQL> @/opt/app/oracle/local/sql/login.sql
> cdb >
>
>
> Here is content of my login.sql:
>
> SET SQLPROMPT '&_CONNECT_IDENTIFIER > '
>
> I also had this in my login.sql which also did not show up when I
> logged into sqlplus:
> SET TERMOUT OFF
> DEFINE sqlprompt=none
> COLUMN sqlprompt NEW_VALUE sqlprompt
>
> SELECT USER || '@' || NVL('&_CONNECT_IDENTIFIER', global_name )
> sqlprompt
> FROM global_name;
>
> SET SQLPROMPT '&sqlprompt> '
> UNDEFINE sqlprompt
> SET TERMOUT ON
>
>
> Do I need to put anything else there to make it read on login to
> sqlplus?
>
> Thanks,
> Anoop
Received on Wed Jan 10 2007 - 08:36:00 CST