SQL*Plus history under Linux

linux history sqlplus
Aleksey Otrubennikov picture Aleksey Otrubennikov · Aug 11, 2010 · Viewed 7k times · Source

How to make sqlplus in Linux to maintain history of my queries? So that I could use up/down arrows to get my previous query.

Answer

Aleksey Otrubennikov picture Aleksey Otrubennikov · Aug 11, 2010

rlwrap package is needed. Used like this:

$ rlwrap sqlplus user/password@sid

Nice to place alias to .bashrc:

alias sqlplus="rlwrap sqlplus"

Found answer here:

http://sysdba.wordpress.com/2006/10/08/how-to-use-rlwrap-to-get-a-command-history-in-sqlplus/

Related questions

Linux Command History with date and time

I wants to check on my linux system when which command was fired - at which date and time. I fired commands like this: history 50 It shows me the last 50 commands history, but not with date and time at which …

Read More
How do I find all files containing specific text on Linux?

I'm trying to find a way to scan my entire Linux system for all files containing a specific string of text. Just to clarify, I'm looking for text within the file, not in the file name. When I was looking …

Read More
How to change permissions for a folder and its subfolders/files in one step?

I would like to change permissions of a folder and all its sub folders and files in one step (command) in Linux. I have already tried the below command but it works only for the mentioned folder: chmod 775 /opt/lampp/…

Read More