Re: login.sql

From: B.Sc Yassir Khogaly <>
Date: Wed, 4 Nov 1998 12:36:04 -0000
Message-ID: <71phpn$vsh$>

More info about login.sql that you may need.!

Using a System Editor from SQL*Plus
An ed or edit command entered at the SQL*Plus prompt calls a default operating system editor, such as ed, emacs, ned, or vi. Your PATH variable must include the directory of the editor. The global default editor is usually set by the DBA in glogin.sql using the SQL*Plus _editor option. Override this setting by specifying an editor in login.sql. Both files are read by SQL*Plus at startup, the local file taking precedence. The _editor option can also be set during a SQL*Plus session, overriding the setting in either file.

If the _editor option is not set, the EDITOR and VISUAL environment variables specify the SQL*Plus editor. These variables are not set in glogin.sql or login.sql. They are set in a user startup file, or at the system prompt. If both are set, the EDITOR variable is used.

Setting the Order of the Editor
SQL*Plus searches for the default editor in the following order:

  1. The _editor option during a SQL*Plus session.
  2. The _editor option in login.sql.
  3. The _editor option in glogin.sql.
  4. The EDITOR variable in your startup file or at the system prompt.
  5. The VISUAL variable in your startup file or at the system prompt. If none of these values are set, SQL*Plus uses ed.

Setting the _editor option
Set the SQL*Plus _editor option by adding the following line to the login.sql file:

define _editor=editor_name
where editor_name is a UNIX editor.

Setting Environment Variables
Set the default editor with an environment variable by entering: For the Bourne or Korn shell:

$ UNIX_VAR=editor_name; export UNIX_VAR
For the C shell:

% setenv UNIX_VAR editor_name

UNIX_VAR is the EDITOR or VISUAL environment variable


is the UNIX editor

Default Settings
If you call the system editor, the current SQL buffer is placed in the edit buffer and all statements available to the editor can change the SQL statement. SQL*Plus uses the afiedt.buf. temporary file. When you exit the editor, the changed SQL buffer is returned to SQL*Plus. 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,V,#-:#0I%3D0Z5D-!4D0-"_at_`` `
end Received on Wed Nov 04 1998 - 13:36:04 CET

Original text of this message