Re: login.sql
Date: Wed, 4 Nov 1998 12:23:46 -0000
Message-ID: <71ph2i$s85$1_at_newsreader2.core.theplanet.net>
Hi
[Quoted] This is from Oracle Corporation Oracle7 Administrator's Reference for UNIX
/ Administering SQL*Plus. This will give you an idea.
Regards
Setup Files
The setup files for SQL*Plus are glogin.sql, the global setup file, and
login.sql, for local and individual use. The glogin.sql and login.sql files
contain either SQL statements or SQL*Plus commands that you choose to
execute at the beginning of each SQL*Plus session. When you invoke SQL*Plus,
glogin.sql is read first, followed by login.sql.
The glogin.sql File
The glogin.sql file is executed regardless of your current directory. The
DBA can customize the glogin.sql file. When you install (rather than
upgrade) SQL*Plus, existing glogin.sql files are deleted. The glogin.sql
file is in $ORACLE_HOME/sqlplus/admin.
The login.sql File
The SQLPATH environment variable contains a list of directories, separated
by colons. SQL*Plus searches for the login.sql file in the directories
listed in SQLPATH.
Following is a sample login.sql file:
set echo off
set feedback 4
set pause on
set pause "PLEASE PRESS RETURN TO CONTINUE"
set message on
set echo on
azariae_at_amdocs.com wrote in message <71pbkm$8ab$1_at_nnrp1.dejanews.com>...
>I have the file login.sql in a directory that is not my homedir but it DOES
>take effect.
>how can this be? is there an environment variable defining where login.sql
can
>be found?
>I ma using Oracle 7.* and 8.* on HP-UX Unix Computers.
>Please also mail responses to mailto:\\azariae_at_amdocs.com as it is hard for
me
>to connect to the net (firewalls and other stuff.)
>
>ThanX, in advance for any input.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I&
M3CI987-S:7(_at_2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1%
M3#M(3TU%.U9/24-%.BLT-"_at_P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE#
M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I,
M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP
M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O
M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM)
M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ
<.3DX,3$P-%0Q,C(S-#5:#0I%3D0Z5D-!4D0-"_at_``
`
end
Received on Wed Nov 04 1998 - 13:23:46 CET