Home » SQL & PL/SQL » Client Tools » repeat last series commands in SQL PLUS
repeat last series commands in SQL PLUS [message #257557] Wed, 08 August 2007 11:30 Go to next message
NIckman
Messages: 64
Registered: May 2007
Member
In SQL plus
<SQL>
i need to repeat last six or seven commands instead of typeing

is there any command to using arrow keys o backward and forward
last typing comamnds

i know / to execute last command

pl tell me how to do that in SQL plus.
thx
N.
Re: repeat last series commands in SQL PLUS [message #257561 is a reply to message #257557] Wed, 08 August 2007 11:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not in windows SQL*Plus.
Use arrow in DOS SQL*Plus.
I don't know in Unix ones.
Otherwise you can use SQL*Plus worksheet.

Regards
Michel
Re: repeat last series commands in SQL PLUS [message #257568 is a reply to message #257557] Wed, 08 August 2007 12:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check here for a tool called rlwrap that will provide DOS Key functionality on UNIX/Linux. It will provide a method to recall the last few commands entered while in SQL*Plus.
Re: repeat last series commands in SQL PLUS [message #257595 is a reply to message #257557] Wed, 08 August 2007 13:17 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
On HP-UX, use ied. man ied for details...

alias sqlplus="ied sqlplus"
Re: repeat last series commands in SQL PLUS [message #257622 is a reply to message #257595] Wed, 08 August 2007 15:42 Go to previous messageGo to next message
NIckman
Messages: 64
Registered: May 2007
Member
I think mine is SUN Solaris not HP.
does it work on sun solaris m/c ied utitlity.

is this IED utility software need to install.

thx, N.
Re: repeat last series commands in SQL PLUS [message #495818 is a reply to message #257622] Tue, 22 February 2011 08:33 Go to previous message
oranooob
Messages: 86
Registered: May 2009
Member
NIckman wrote on Wed, 08 August 2007 15:42
I think mine is SUN Solaris not HP.
does it work on sun solaris m/c ied utitlity.

is this IED utility software need to install.

thx, N.


There are packages available of rlwrap for Solaris

opencsw.org/packages/rlwrap/

(ied is HP-UX only, not Open Source)
Previous Topic: SQLPLUS not exist
Next Topic: SQL Developer - Disable "save password" functionality
Goto Forum:
  


Current Time: Sat Dec 03 00:57:49 CST 2016

Total time taken to generate the page: 0.08427 seconds