Re: SQL Command list history on Linux

I’ve always been able to connect directly (for dev and SIT at least), but sadly the days of downloading any application I like to my work desktop are long gone.

William

On 4 Jan 2018, at 23:52, Neil Chandler <neil_chandler_at_hotmail.com> wrote:

Dave,

In the last decade I've been on about 2 client sites where connecting to the database directly from your desktop was possible.

For all of the others it's usually via something like an RSA token onto a jump box in the data domain and connect from there, with limited or no copy/paste/transfer of files to or from the jump box directly. On more secure sites, it's usually on a totally different network not even accessible from your normal workstation but via a different workstation (and very very occasionally I'm not even allowed to touch the keyboard - somebody else does that)

Neil Chandler

From: Dave Herring <gdherri_at_gmail.com <mailto:gdherri_at_gmail.com>> Sent: 04 January 2018 22:09
To: neil_chandler_at_hotmail.com <mailto:neil_chandler_at_hotmail.com> Cc: Jeff Smith; oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>; gogala.mladen_at_gmail.com <mailto:gogala.mladen_at_gmail.com> Subject: Re: SQL Command list history on Linux  

Maybe I'm missing something, but if you use SQLcl as a client and connect from your laptop it gets past any issues of red tape, security clearance, etc.

Dave

On Thu, Jan 4, 2018 at 9:56 AM, Neil Chandler <neil_chandler_at_hotmail.com <mailto:neil_chandler_at_hotmail.com>> wrote: Jeff,

The main traction against sqlci isn't the several seconds to start rather than pretty much instant sqlplus (this becomes a factor when calling sqlplus multiple times in a loop), nor the fact it's far superior to sql*plus, but the red tape, security clearance, patching, etc, required to get new software (especially the Java component) onto the all of the DB servers. That pretty much nobody is using 12.2 in Production yet compounds it, so the red tape is required. There's nothing you can do about this that time won't cure except make the sqlci case increasingly compelling.

I use vi and sqlplus because they are guaranteed to be there. If I was a perm DBA in a company long-term, I'd probably raise the paperwork to get it onto every DB server purely for the automatic column size adjustments if nothing else. Love that.

Neil Chandler

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