Re: SQL Command list history on Linux

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Tue, 2 Jan 2018 21:51:56 +0000
Message-ID: <HE1PR1001MB1243C5AFA7A8C44778B91AA385190_at_HE1PR1001MB1243.EURPRD10.PROD.OUTLOOK.COM>

Jeff,

My preferred solution is to install "rlwrap" [ e.g. "yum install rlwrap" - check out https://github.com/hanslub42/rlwrap ] it provides similar functionality to a windows CMD environment. You just call the command you want to use via rlwrap

e.g. rlwrap sqlplus, or rlwrap dgmgrl

To keep thing simple, you can alias it

alias rsql='rlwrap sqlplus'

alias rdg='rlwrap dgmgrl'

regards

Neil Chandler

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> Sent: 02 January 2018 20:41
To: oracle-l-freelist
Subject: SQL Command list history on Linux

I am coming from a Windows environment in which SQL plus does have a command line history. In Linux, running SQL Plus, an up arrow key returns garbled characters. Is there a way to activate the command line history for Linux servers running SQL Plus?

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 02 2018 - 22:51:56 CET