Re: SQL*Plus in Oracle 9.x

You don't say what OS you use, but if you run sqlplus in a shell (such as cmd.exe on nt or emacs etc on *nix) that you inherit the command history features of the shell. There were some postings here a while back from Oracle employees suggesting that various environment related features from iSQL*Plus might well find there way into command line sqlplus in 10.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Steve Mazerski" <smazerski_at_yahoo.co.jp> wrote in message
news:296c8e2b.0304061413.4ab4fc31_at_posting.google.com...


> Let me first state that I find SQL*Plus an excellent and valuable tool

which is


> the basis of my work with Oracle.

>

> One thing that always annoys me though is the complete lack of any kind of


GNU


> readlines-style support. Things like being able to recall the fourth


previous


> query, searching the command history etc. (Yes I know GNU readline would


> not be an option from a licensing point of view ;-).

>

> Currently my Oracle experience is stuck at 8.1.7, but I was idly wondering

if


> in 9.x SQL*Plus has been improved in this respect?  ("Dragged kicking and


> screaming into the 1990s" as my co-worker succinctly put it ;-) ).

>

> I found this document:

>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/whatsnew
.htm


> and as it says nothing about improvements to the command line interface


> I presume there have been no radical changes.

>

>

> Curious

>

> Steve Mazerski