Re: SQL Command list history on Linux

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


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