Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: rostamseddiq@web.de (Rostam) Newsgroups: comp.databases.oracle.misc Subject: Re: sqlplus command line editing: readline support Date: 10 Oct 2001 07:16:03 -0700 Organization: http://groups.google.com/ Lines: 25 Message-ID: References: NNTP-Posting-Host: 62.27.110.45 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1002723363 6359 127.0.0.1 (10 Oct 2001 14:16:03 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 10 Oct 2001 14:16:03 GMT Xref: easynews comp.databases.oracle.misc:70128 X-Received-Date: Wed, 10 Oct 2001 07:56:10 MST (news.easynews.com) Neil Zanella wrote in message news:... > Hello, > > I wonder whether it is possible to have Oracle 8i / 9i behave in a way > similar to mysql in terms of command line editing. In particular I am > looking for a command history feature such as the one provided by the > gnu readline library which is used in bash and afaik in mysql as well. > Pressing the up arrow key should bring up the previous executed command > and the down arrow brings up the next command. Anyone who has used the > bash shell probably recalls having used this nift feature at some time > or another. Now is this possible from Oracle's sqlplus command line > interface? This would come in _REALLY_ handy. > > Thanks, > > Neil Hi, as a workaround you can use: 1) any standard editor to edit your sql-statements 2) login to Oracle in a DOS-Window (i.e. type sqlplus in a standard path) and use doskey Rostam