OraFAQ Forum: Linux » Recalling Previous commands

Home » Infrastructure » Linux » Recalling Previous commands (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recalling Previous commands [message #465959]

Fri, 16 July 2010 02:32

malhi
Messages: 96
Registered: December 2009
Location: Karachi

Member

Respected brothers..........

I am working on Linux base Oracle, i have heard that there is a way of recalling previous command in SQL prompt, but i do not know can you tell me.
Also as we can edit commands with ed in windows, can we have this type of facility in linux bases oracle.

Let me clear my question, while working on Linux terminal we can use up and down keys to recall previous commands, how this i can do on SQL prompt.

[Updated on: Fri, 16 July 2010 02:42]

Report message to a moderator

Re: Recalling Previous commands [message #465981 is a reply to message #465959]

Fri, 16 July 2010 03:55

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

you need to set up vi editor as your default editor on linux
In SQL*Plus write:

      define_editor='vi'

So on ed IT will invoke the vi editor on linux.

[Updated on: Fri, 16 July 2010 03:57]

Report message to a moderator

Re: Recalling Previous commands [message #465983 is a reply to message #465981]

Fri, 16 July 2010 04:03

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

in windows you can get the previous comand history list by using arrows and pressing functional key f7 where as you cannot in *nix.But
http://www.oracle-base.com/articles/linux/rlwrap.php
will guide you
To be frank ,I have never used such utility .YOYO
good luck
sriram

Report message to a moderator

Re: Recalling Previous commands [message #465984 is a reply to message #465983]

Fri, 16 July 2010 04:08

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Sriram OP is asking to recall the command on SQL PLUS window on Linux ( with ED)

what you said is true but for Command prompt ( SQL PLUS windows on command.exe ) ,
but OP wants to recall the Last command with Ed on Linux.

[Updated on: Fri, 16 July 2010 04:08]

Report message to a moderator

Re: Recalling Previous commands [message #465988 is a reply to message #465959]

Fri, 16 July 2010 04:38

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

malhi wrote on Fri, 16 July 2010 13:02

Respected brothers..........

I am working on Linux base Oracle, i have heard that there is a way of recalling previous command in SQL prompt, but i do not know can you tell me. Also as we can edit commands with ed in windows, can we have this type of facility in linux bases oracle.

Let me clear my question, while working on Linux terminal we can use up and down keys to recall previous commands, how this i can do on SQL prompt.

@ Rahul re read the above statement.( I am not talking about "ed" here" rest of the things I addressed)

Have read the URL provided?

sriram Smile