rlwrap and auto completion in sqlplus
It is a while I am following the blog of Mariami Kupatadze , it seems that our background and daily work is around the same area and interest as mine. This week she posted a simple Linux adjustment ( sqlplus backspace – ^H, delete – [[D^, add command history ) for better way of using sqlplus. Since I am also a geek of environment improvements that can ease daily work, I want to add a nice variation. An example of basic rlwrap usage: rlwrap sqlplus / as sysdba or use sqlplus as alias with rlwrap: alias sqlplus='rlwrap sqlplus' After some usage you will notice that default history file is created here ~/.sqlplus_history I usually copy this file to ~/sqlplus.wordlist and edit it with wanted completion word. My personal file looks this way: abort active affirm all_roles alter alternate applied applied_seq# applied_thread# apply apply_finish apply_lag archived archived_seq# archived_thread# archiver async_blocks attribute availability begin bindi...