Re: Recalling SQL history does not work in UNIX version of SQL*Plus???

On Wed, 04 Aug 2004, 1443131_at_usenetplanet.com wrote:
>
> In Windows version of SQL*Plus, pressing up arrow brings
> previous SQL statements.

I'm pretty sure this is because sqlplus for windows piggybacks on cmd prompt functionality (however little that is). I don't find this very useful at all because you can only get one line of history, so your sql authoring has to be a single line.

> However, it is not working in UNIX version of SQL*Plus (we use
> HP/UX). Is there something that we need to set to make it
> work? Thank you in advance.

I don't believe you can do this in UNIX. For some reason, once in sqlplus from a shell prompt, you lose the history capability of the shell prompt you came from, but the odd thing is that you don't lose all of the parent shell's functionality.

For example:

    stty erase [backspace]

is also available at the sqlplus prompt but

    set -o vi

is not.

But, I wouldn't find this all that useful for the same reason as above.

-- 
Galen Boyer