Re: SQL Command list history on Linux
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: Neil Chandler <neil_chandler@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Jan 2018 08:20:16 -0500
On 01/04/2018 07:58 AM, Neil Chandler wrote:
Mladen,
What has that go to do with the original posters question?
Well, I am recommending an alternative CLI client for Oracle RDBMS.
If you are developing PL/SQL in SQL*Plus, you're probably not doing it
efficiently.
I am not developing anything. I wasn't developing even while I was a
DBA, more than 5 years ago. However, I had to write quick PL/SQL scripts
using DBMS_STATS, DBMS_MONITOR, DBMS_SCHEDULER, DBMS_JOB, DBMS_SPM and
similar. Sometimes, it's faster to use SQL Plus than to develop a
procedure using SQL Developer
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.
It can easily be downloaded from OTN and it works on Oracle RDBMS
11.2.0.4 without any issue. I would also recommend keeping up with the
OTN releases and not relying on the version shipped with the database.
If you want Windows-like editing on a Linux SQL*Plus (or dgmgrl, rman
or whatever), use rlwrap.
Or use a native tool that has readline library already built in, which
was my point in the first place.
--
Mladen Gogala
Database Consultant
http://mgogala.freehostia.com
Other related posts: