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
Search This Blog
Total Pageviews
Tuesday, 3 May 2011
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
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment