Arrow Key Does Not Show Command History When Using SQL*Plus

(Doc ID 567215.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version and later
Linux x86


The command line history (that is, the arrow keys UP/DOWN to see past commands) does not work when running SQL*Plus on UNIX. 

For example:

$ sqlplus / as sysdba

SQL*Plus: Release - Production on Thu Feb 7 16:35:01 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$instance;
SQL> ^[[A <--- this is what appears when you press UP-arrow within SQL*Plus

Instead of seeing the past commands, you get junk characters when using UP or DOWN arrow.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms