Home » Infrastructure » Linux » Recalling Previous commands (11g)
Recalling Previous commands [message #465959] Fri, 16 July 2010 02:32 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: Recalling Previous commands [message #465984 is a reply to message #465983] Fri, 16 July 2010 04:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: Recalling Previous commands [message #465996 is a reply to message #465981] Fri, 16 July 2010 05:02 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
Thanks.
Re: Recalling Previous commands [message #466004 is a reply to message #465983] Fri, 16 July 2010 06:05 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
Thanks a lot
Re: Recalling Previous commands [message #466018 is a reply to message #466004] Fri, 16 July 2010 07:59 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
So does it helpful?(I am the utility).

sriram Smile
Previous Topic: rm command script
Next Topic: Oracle files are deleted each time I restart OS
Goto Forum:
  


Current Time: Fri Mar 29 06:22:59 CDT 2024