[Oracle-l] RE: sqlplus newbie: How do I retrieve the last command I ran in a

How
about a history of commands? Thanks.

-----Original Message-----From: Stefick Ronald S Civ
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Friday, June
27, 2003 5:10 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: sqlplus newbie: How do I retrieve the last
command I ran in a
You can either use the "/" key to re-run the last command, or
you can type "ed" and enter to edit the last command.  Then when you are
finished editing, save the changes, and when you return to the SQL> command
prompt, just hit the "/" key again.
-Scott Stefick
-----Original Message----- From: Roger
Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: sqlplus newbie: How do I retrieve the last command I ran in a
sqlplus session?
Hi,
How do I retrieve the last commands I ran in a sqlplus
session? I remembe in the training class, I were able to use arrow keys in
Windows platform. But in Solaris 9/UNIX platform, it does NOT work.
Roger Xu Database Administrator
Dr Pepper Bottling Company of Texas (972)721-8337

size=2>________________________________________________________________________

This email has been scanned for all viruses by the
MessageLabs Email Security System. For more information on a proactive email
security service working around the clock, around the globe, visit http://www.messagelabs.com" target=_blank>http://www.messagelabs.com

Please see the official ORACLE-L
FAQ: http://www.orafaq.net"
target=_blank>http://www.orafaq.net --
Author: Roger Xu   INET:
[EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com" target=_blank>http://www.fatcity.com
San Diego,
California        -- Mailing list and web
hosting services ---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line containing: UNSUB
ORACLE-L (or the name of mailing list you want to be removed from).  You
may also send the HELP command for other information (like
subscribing).________________________________________________________________________This
email has been scanned for all viruses by the MessageLabs EmailSecurity
System. For more information on a proactive email securityservice working
around the clock, around the globe, visithttp://www.messagelabs.com">http://www.messagelabs.com________________________________________________________________________

This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com>
http://www.messagelabs.com

If you are on a Windows 2000/NT client, then start the command line version
of SQL Plus by entering "start %ORACLE_HOME%/bin/sqlplus [EMAIL PROTECTED]".
Then in your SQL session you should be able to recall SQL commands the same
way you do in Windows 2000/NT: use the cursor arrow keys to recall and
edit previous commands. To insure you have enough buffer memory, right
click on the SQL Plus title bar and edit the properties of the SQL Plus
command window and set the screen lenght and width to 2500 and 130
respectively.

I hope this helps.

RWB

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]

[EMAIL PROTECTED]

[EMAIL PROTECTED]

tx.com To: [EMAIL PROTECTED]

Sent by: cc:

[EMAIL PROTECTED] Subject: RE: sqlplus newbie: How do I
retrieve the last command I ran in a
ity.com

06/27/2003

06:10 PM

Please respond

to ORACLE-L

How about a history of commands? Thanks.