Re: login.sql

From: B.Sc Yassir Khogaly <>
Date: Wed, 4 Nov 1998 12:23:46 -0000
Message-ID: <71ph2i$s85$>

[Quoted] This is from Oracle Corporation Oracle7 Administrator's Reference for UNIX / Administering SQL*Plus. This will give you an idea.


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 wrote in message <71pbkm$8ab$>...
>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
>be found?
>I ma using Oracle 7.* and 8.* on HP-UX Unix Computers.
>Please also mail responses to mailto:\\ as it is hard for
>to connect to the net (firewalls and other stuff.)
>ThanX, in advance for any input.
>-----------== Posted via Deja News, The Discussion Network ==----------
> 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

Original text of this message