Scrolling of commands entered in SQL*Plus

nz_1 — Sun, 30 Nov 2003 02:59:01 GMT

I used this command before to enable "up" and "down" scrolling of commands entered in SQL*Plus or svrmgrl, but I've not been able to find it again.

# svrmgrl

Anyone know and remember?
Thanks.

Re: Scrolling of commands entered in SQL*Plus

Michael Schulte zur Sur — Sun, 30 Nov 2003 16:27:20 GMT

Hi,

I think, you are looking for this:
How to Enable 'Command History' in SQL*Plus and SVRMGRL: ======================================================== HP/UX has a nice feature called 'ied'. 'ied' is "input editor and command history for interactive programs." It can also be used with SQL*Plus and SVRMGRL to provide command history. Examples: --------- $ ied -s 8192 -h $HOME/.sqlhistory sqlplus $ ied -s 8192 -h $HOME/.sqlhistory svrmgrl or, as an alias: $ alias sqlplus='ied -s 8192 -h $HOME/.sqlhistory sqlplus' $ alias svrmgrl='ied -s 8192 -h $HOME/.svrmgrhistory svrmgrl' In the above examples, when you start SQL*Plus or SVRMGRL, all previous commands can be accessed as usual: k j in vi-mode Options used for ied in the above examples: -h filename : Keep the history in a file named filename. -s size : This option specifies the size of the history buffer. For a full list of options on ied: $ man ied

greetings,

Michael

ps. points are allways appreciated. ;-)

topic Scrolling of commands entered in SQL*Plus in Operating System - HP-UX

Scrolling of commands entered in SQL*Plus

Re: Scrolling of commands entered in SQL*Plus