Re: 'history' for SQL commands

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sat, 30 Aug 2003 23:22:31 +0300
Message-ID: <3f510788$1_1@news.estpak.ee>

If you're on Windows and use regular command line mode sqlplus, then type few commands in it and see what pressing F7 does. It shows you the list of previously executed commands (you can control the length of history from cmd.exe properties). Also when you press a letter when at command history list, the last command starting with the letter is shown. I like these features a lot...

Tanel

"Vattekkat Satheesh Babu" <vattekkat.babu_at_verizon.net> wrote in message news:pan.2003.08.30.13.07.34.605821_at_verizon.net...
> 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/
Received on Sat Aug 30 2003 - 15:22:31 CDT