Re: SQL Command list history on Linux
Date: Thu, 4 Jan 2018 12:58:38 +0000
Message-ID: <HE1PR1001MB1243A42292AC0BCAAFE56C67851F0_at_HE1PR1001MB1243.EURPRD10.PROD.OUTLOOK.COM>
Mladen,
What has that go to do with the original posters question?
If you are developing PL/SQL in SQL*Plus, you're probably not doing it efficiently. SQL Developer is the better (free) tool for that, regardless of platform.
SQLCI is great, but it's slow to start, requires a fairly recent Java release, and only natively available from 12.2.
If you want Windows-like editing on a Linux SQL*Plus (or dgmgrl, rman or whatever), use rlwrap.
regards
Neil Chandler.
Database Guy.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mladen Gogala <gogala.mladen_at_gmail.com> Sent: 04 January 2018 10:57
To: oracle-l_at_freelists.org
Subject: Re: SQL Command list history on Linux
On 01/02/2018 04:51 PM, Neil Chandler wrote:
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
Hi Neil,
Rlwrap is not an equivalent solution. The "rlwrap" trick breaks editing of PL/SQL code, which can be annoying. If you write a multi-line PL/SQL snippet and something goes wrong, "ed" will only return a part of the snippet. SQLCl will do the right thing and give you back the entire procedure. It has a primitive screen editor built into the code because arrow keys also work when editing the history commands. Also, SQLCl has "REPEAT" command which turns your SQLCl session into an instant monitor, if necessary. In addition to all that, there is Jeff Smith, who has been doing an outstanding job with the product and explaining it on this list. Jeff is extremely helpful and a very nice guy. And no, I don't work for Oracle Corp. and I don't plan on working for Oracle anytime soon.
Regards
--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 04 2018 - 13:58:38 CET