FAQ
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

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 ________________________________________________________________________

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

Fat City Network Services    -- 858-538-5051 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).

Search Discussions

  • Roger Xu at Jun 27, 2003 at 10:22 pm
    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
  • Reginald.W.Bailey_at_jpmorgan.com at Jun 28, 2003 at 12:12 am
    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.
    -----Original Message-----
    [mailto:[EMAIL PROTECTED]
    Sent: Friday, June 27, 2003 5:10 PM
    To: Multiple recipients of list ORACLE-L

    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-----
    Sent: Friday, June 27, 2003 4:40 PM
    To: Multiple recipients of list ORACLE-L
    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

    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

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

    Fat City Network Services    -- 858-538-5051 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 Email
    Security System. For more information on a proactive email security
    service working around the clock, around the globe, visit
    http://www.messagelabs.com
    ________________________________________________________________________

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author:
    INET: [EMAIL PROTECTED]

    Fat City Network Services -- 858-538-5051 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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 27, '03 at 9:47p
activeJun 28, '03 at 12:12a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase