OraFAQ Forum: Client Tools » repeat last series commands in SQL PLUS

Home » Other » Client Tools » repeat last series commands in SQL PLUS

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

repeat last series commands in SQL PLUS [message #257557]

Wed, 08 August 2007 11:30

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.

Report message to a moderator

Re: repeat last series commands in SQL PLUS [message #257561 is a reply to message #257557]

Wed, 08 August 2007 11:34

Michel Cadot
Messages: 68510
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

Report message to a moderator

Re: repeat last series commands in SQL PLUS [message #257568 is a reply to message #257557]

Wed, 08 August 2007 12:04

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.

Report message to a moderator