Re: Oracle woes

On Sat, 28 Feb 2004, Mike wrote:

> Beautiful!!!! Thanks so much for the help! Works like a charm. Am I able to
> make Kwrite my default editor in sqlplus, like in winXX? I tried to edit a
> statement and it was trying to make the changes in the terminal, but I
> couldn't figure out ehat commands to use. It may be emac environment. If
> anything I would like to change it to vi..

Yep, here's a sample login.sql for ya:


set term off echo off
col User new_value username
select User from DUAL;
set sqlprompt &username>
define _editor=kwrite
set term on echo on


This will change the prompt to use your username and also sets the editor
to kwrite. You can change it to vim or whatever else you'd like too. The
login.sql file should be in the same place as where you start sqlplus
(your home directory, for example).
~M

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss