Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Calgary, Canada
    Posts
    3

    Unanswered: Command History in SQL*Plus

    I've started using Oracle SQL*Plus for school. Having used bash for a long long time, I'm very accustomed to the up-arrow providing command history for me. Currently, the up-arrow transmits ^[[A to the screen. Is there something I can do to enable the command history? I am running SQL*Plus Release 9.2.0.4.0 and am ssh-ing into the machine which has the databases on it.

    Thanks,
    Mike

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Unforutunatelly, I'm afraid you can't do that ... if you find out, let me know

    However, you can recall last command (query) entering "L" (List) at the SQL prompt. If your query consists of multiple lines, enter, for example, "L 3" to view 3rd line.
    Then you can change it using "C/old_string/new_string/" (C-change).
    If you need to append something at the ond of a line, enter "A something".
    Finally, enter "/" or "R" (R-run) to execute the query.

    Not much of a help ... sorry.

  3. #3
    Join Date
    Feb 2004
    Location
    Calgary, Canada
    Posts
    3
    Thanks for the reply.

    That's too bad, sometimes I can get really annoyed when such conveniences as command history are taken away. I guess I can learn to live in harsher conditions, like my forefathers did

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •