Arrow Key Does Not Show Command History When Using SQL*Plus
Last updated on MARCH 08, 2017
Applies to:SQL*Plus - Version 10.1.0.2 and later
The command line history (that is, the arrow keys UP/DOWN to see past commands) does not work when running SQL*Plus on UNIX.
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 7 16:35:01 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 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