Saturday Mar 15, 2014

sql*plus command history on Linux

RLWRAP is your friend

A customer of mine has complained about the inability to easily grab a previously submitted command in sql*plus.

Refrain from migrating the platform you are on, and use rlwrap.

  1. install the OS package "rlwrap" available in your linux distro
  2. define the following bash function in your .bash_profile
sp () {
  rlwrap sqlplus ${@:-/nolog}
}


Enjoy using sp instead of sqlplus!

About

Enrico Brambilla is an Oracle Core Technology Expert, member of Oracle Consulting. He has worked with over a hundered big and small customers across the years, gathering thoughts to share about Database, e-BS, Exadata, GoldenGate and more - not "just" technology.

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today