Operating System - HP-UX
1824971 Members
3264 Online
109678 Solutions
New Discussion

Re: Scrolling of commands entered in SQL*Plus

 
SOLVED
Go to solution
nz_1
Advisor

Scrolling of commands entered in SQL*Plus

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.
1 REPLY 1
Michael Schulte zur Sur
Honored Contributor
Solution

Re: Scrolling of commands entered in SQL*Plus

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. ;-)