sqlplus Command Line History

sqlplus Command Line History Doskey functionality in sqlplus on linux platform sqlplus History sql doskey ( like old days on dos ) sqlplus doskey

rlwrap is a Command Line History and Editing in SQL*Plus and RMAN on Linux


http://utopia.knoware.nl/~hlub/uck/rlwrap/


wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.37.tar.gz

apt-amd-02:/home/anujs/Downloads/rlwrap-0.37 # wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.37.tar.gz
--2011-05-03 12:44:25--  http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.37.tar.gz
Resolving utopia.knoware.nl... 213.197.30.29
Connecting to utopia.knoware.nl|213.197.30.29|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 251438 (246K) [application/x-gzip]
Saving to: `rlwrap-0.37.tar.gz'

100%[==========================================================================================================================================>] 251,438     1.12M/s   in 0.2s    

2011-05-03 12:44:25 (1.12 MB/s) - `rlwrap-0.37.tar.gz' saved [251438/251438]


or


rpm 


Download your RPM according to your OS

apt-amd-02:/home/anujs/Downloads # cat /etc/issue
Welcome to openSUSE 11.3 "Teal" - Kernel \r (\l).


rlwrap-0.30-56.1.x86_64.rpm


Download software from  this site as per your OS

http://rpm.pbone.net/index.php3?stat=3&search=rlwrap&srodzaj=3


OpenSuSE  ftp.opensuse.org/distribution/11.2/repo/oss/suse/x86_64/rlwrap-0.30-56.1.x86_64.rpm


install this RPM 


apt-amd-02:/home/anujs/Downloads # rpm -Uvh rlwrap-0.30-56.1.x86_64.rpm
Preparing...                ########################################### [100%]
        package rlwrap-0.30-56.1.x86_64 is already installed


go to oracle user

su - oracle

edit your .bash_profile with following line


alias hsqlplus='rlwrap sqlplus'
alias hman='rlwrap rman'
alias hsql='rlwrap sqlplus'
alias sql="rlwrap -i -f ~/.sqlplus_history -H ~/.sqlplus_history -s 30000 sqlplus"
touch ~/.sqlplus_history



this will store 30000 line in .sqlplus_history file 

or

export RLWRAP_EDITOR="vim +%L -c 'syntax on' -c 'set filetype=sql'"
alias sysdba='rlwrap -m -s5000 sqlplus / as sysdba'




oracle@apt-amd-02:~> hsqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 3 11:54:26 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: scott/tiger

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BONUS                          TABLE
DEPT                           TABLE
EMP                            TABLE
SALGRADE                       TABLE
T                              TABLE

sql> 

now if you press arrow key, you will able to see previous commands !!!!!!!!!!!!!!!!!!!!!!!!


=====================================================================================================================================


download !!

 wget ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/epel/6/x86_64/Packages/r/rlwrap-0.42-1.el6.x86_64.rpm
 
--2022-03-10 07:51:15--  ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/epel/6/x86_64/Packages/r/rlwrap-0.42-1.el6.x86_64.rpm
           => ‘rlwrap-0.42-1.el6.x86_64.rpm’
Resolving ftp.pbone.net (ftp.pbone.net)... 93.179.225.212
Connecting to ftp.pbone.net (ftp.pbone.net)|93.179.225.212|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done.    ==> PWD ... done.
==> TYPE I ... done.  ==> CWD (1) /mirror/archive.fedoraproject.org/epel/6/x86_64/Packages/r ... done.
==> SIZE rlwrap-0.42-1.el6.x86_64.rpm ... 95240
==> PASV ... done.    ==> RETR rlwrap-0.42-1.el6.x86_64.rpm ... done.
Length: 95240 (93K) (unauthoritative)

100%[===================================================================================================================================================>] 95,240       166KB/s   in 0.6s

2022-03-10 07:51:17 (166 KB/s) - ‘rlwrap-0.42-1.el6.x86_64.rpm’ saved [95240]


rpm -ivh rlwrap-0.42-1.el6.x86_64.rpm
warning: rlwrap-0.42-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:rlwrap-0.42-1.el6                ################################# [100%]




su - oracle
 touch /home/oracle/.oracle_keywords
 
 
 alias sqlplus='/usr/bin/rlwrap -if $HOME/.oracle_keywords $ORACLE_HOME/bin/sqlplus'
 
 rlwrap sqlplus / as sysdba
 
 
  rlwrap sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 10 07:54:51 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select * from dual;

D
-
X