Thread: sqplus arrows

    #1
  1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jul 2003
    Location
    Prague, Czech Republic
    Posts
    869
    Rep Power
    71

    sqplus arrows


    Hey,
    can someone give me a clue how to define the arrow keys for work in sqlplus just as they do in a regular xterm?.
    History key function is not an issue now.
    So far I made the backspace work with it.

    using: Oracle 8i sqlplus in xterm for Linux (ORACLE_TERM=386x).
    system: RHL 7.2
    X: Afterstep 1.8

    Thank you.
  2. #2
  3. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    Well, assuming you're just wanting to edit the current sql statement, you should be able to type "edit" and open in a text editor. When you save the file you should be dumped back to sqlplus where you can run it.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jul 2003
    Location
    Prague, Czech Republic
    Posts
    869
    Rep Power
    71
    Ok. Thanks. I have two more things to fight:
    1. how to enable deleting text with backspace (persistently)
    2. how to enable left/right arrows to work as a movement keys. Not like printing some mess instead.

    I have somehow enabled backspace, but it is not loaded (using Aftrstep's wharf to launch sqlplus). Is there any global config file via ORACLE_HOME directory that these configs may be kept in for wide use?
    Last edited by zby; September 12th, 2003 at 03:01 AM.
  6. #4
  7. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    Well, I really have no idea . You can try playing with your TERM environment variable, but if you're not having any problems in your shell that probably isn't going to help.

    Here's something that may help you, though: http://gqlplus.sourceforge.net/
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jul 2003
    Location
    Prague, Czech Republic
    Posts
    869
    Rep Power
    71
    Ok. Thank you.

IMN logo majestic logo threadwatch logo seochat tools logo