Re: 'history' for SQL commands

On Sat, 30 Aug 2003 03:53:03 -0700, qazmlp wrote:

> Very often, I need to execute some of the previous SQL commands in the
> sqlplus command prompt. Is there anyway, to get the previous commands,
> similar to the history mechanism that shells follow in Unix.

If you are on Windows 2K or WinXP, I believe command line version of sqlplus.exe can do this; the SQL*Plus you get from Start menu is sqlplusw.exe which is useless...

http://gqlplus.sourceforge.net/

Or if you are using HP-UX, you can call sqlplus from ied; like

     ied sqlplus usr/pass_at_host

ied provides a command line history for command line program.

There seems to be an ied equivalent in Perl:

   http://www.netsw.org/system/tools/term/fep.tar.gz

--
Babu
http://vsbabu.org/