Home » SQL & PL/SQL » Client Tools » how to set direction key in SQLPLUS? (oracle10gR2 Solaris5.9)
how to set direction key in SQLPLUS? [message #310430] Tue, 01 April 2008 04:40 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

how to set direction key in SQLPLUS?

It always prompt error byte.

Example:

SQL> shutdown immediate;^[[C^[[D^[[D^[[A
Re: how to set direction key in SQLPLUS? [message #310438 is a reply to message #310430] Tue, 01 April 2008 04:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure whether I understood your question.
Are you talking about the 'backspace' key (to go back and edit )?
It depends on your environment,shell.
Try
stty erase \^H

and invoke sqlplus.
If you are talking about fetching the command line history, it is not available by default (in unix). Several alternatives are available, if you can google.
One such.
http://www.orafaq.com/forum/t/36846/0/

Re: how to set direction key in SQLPLUS? [message #310457 is a reply to message #310430] Tue, 01 April 2008 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't in SQL*Plus itself.
You can use OS tool for that.

Regards
Michel
Re: how to set direction key in SQLPLUS? [message #310924 is a reply to message #310430] Wed, 02 April 2008 19:52 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
May also want to take a look at rlwrap.
Previous Topic: arraysize in plsql developer?
Next Topic: basic SQL+ setting
Goto Forum:
  


Current Time: Wed Dec 07 16:33:19 CST 2016

Total time taken to generate the page: 0.07134 seconds