How do I enable SQL *Plus Up and down arrow keys?

SQL*Plus, the primary interface to the Oracle Database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data. However, it does not support up and down arrow keys for command-line editing and history.

ADVERTISEMENTS

You need to use gqlplus is a drop-in replacement for sqlplus, an Oracle SQL client, for UNIX/Linux and UNIX-like platforms.

As you know if you have used sqlplus, it is notoriously difficult to correct typing errors and other mistakes in your SQL statements. sqlplus does give you ability to use external editor to edit a statement, but only the last statement you typed. gqlplus solves this problem by providing the familiar command-line editing and history as in tcsh or bash shells, and table/column-name completion, while otherwise retaining compatibility with sqlplus. Thus, no user training is needed – simply use gqlplus instead of sqlplus. In addition, configuration/installation is trivial: gqlplus is a single binary compiled executable (written in C), so all you need to do is download it and put it anywhere in your PATH. After that, you’ll be ready to use it.

You can download here

Then install it as follows:

$ tar -zxvf gqlplus*
$ ./configure
$ make
# make install

To connect to Oracle server use it as follows:

$ gqplus “user/password”

🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source/DevOps topics:
CategoryList of Unix and Linux commands
File Managementcat
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Network Utilitiesdig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04

ADVERTISEMENTS
3 comments… add one
  • Anonymous Mar 21, 2006 @ 9:35

    Using rlwrap in conjunction with SQL*Plus is another solution on Linux. There is some info at

    Install rlwrap from your favorite rpm etc site and then alias sqlplus to use it:

    alias sqlplus=’rlwrap sqlplus’

  • hank Feb 19, 2009 @ 20:55

    Nice !
    I have installed gqlplus on my server, it works well.
    Thanks

  • jordi Nov 10, 2010 @ 11:21

    I’ve tried rlwrap (never heard about it). Just awesome!
    Thanks.

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.