Re: editing a sql statement on Linux

verify whether you can use vi correctly outside sqlplus, you may not have your TERM env var set properly. This will cause vi not to start screen mode. If that's resolved, in sqlplus use
define _editor = /usr/bin/vi
should the ed command to start vi.
If you don't do that the ed editor is started.

Hth,

Sybrand Bakker, Oracle DBA

"john t kelly" <jtkelly_at_usadatanet.net> wrote in message news:3a91e00d$1_1_at_news5.newsfeeds.com...
> I cant seem to edit a sql statement when I run sqlplus on Linux (6.2)
 using
> either 8.1.6 or 8.1.7
> when I type edit I get a garbled line usually a ? mark. Q usually gets me
> back to the SQL Prompt.
> I am using konsole. I have tried setting my editor to vi but no change.
> Any ideas?
>
> Rgds,
> JOhn
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Mon Feb 19 2001 - 22:37:45 CST