Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus command line editing: readline support
Neil Zanella <nzanella_at_garfield.cs.mun.ca> wrote in message news:<Pine.LNX.4.30.0110092356550.27643-100000_at_garfield.cs.mun.ca>...
> 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 Received on Wed Oct 10 2001 - 09:16:03 CDT