Re: SQL Command list history on Linux

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 9 Jan 2018 09:49:28 +0300
Message-ID: <CAOVevU7MhukKSWLM+rvf31ujKMZnZ3FMiBcRMGGwj7YZX+L+Dw_at_mail.gmail.com>



Mark,

with command line interfaces being deprecated and considered antique in the
> Windows world

Ah-ha, that's why Microsoft finally created Windows Server without GUI, develop their powershell and added ubuntu :) I'm too far from windows administration, but I thought that Windows world is much closer to CLI now than 15 years ago :D

On Tue, Jan 9, 2018 at 6:25 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> I believe that was a joke having to do with command line interfaces being
> deprecated and considered antique in the Windows world (but not actually
> illegal).
>
>
>
> If Mladen meant that literally I will be surprised.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Sayan Malakshinov
> *Sent:* Monday, January 08, 2018 7:45 PM
> *To:* Mladen Gogala
> *Cc:* Jeff Smith; Dave Herring; neil_chandler_at_hotmail.com; ORACLE-L
> *Subject:* Re: SQL Command list history on Linux
>
>
>
> Mladen,
>
>
>
> SQLCl is Linux stuff... using SQLCl on Windows is illegal
>
>
>
> I haven't understood your point, especially in context of this error,
> because you can get the same error on Linux too.
>
> Anyway, why do you think so? And when "*SQLCl on Windows is illegal*"?
>
>
>
> *SQLcl 17.4.0.354.2224 on Oracle Linux 7.2:*
>
>
>
> $ sql / as sysdba
>
>
>
> SQLcl: Release 17.4.0 Production on Tue Jan 09 03:36:37 2018
>
>
>
> Copyright (c) 1982, 2018, Oracle. All rights reserved.
>
>
>
> Connected to:
>
> Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
> Production
>
>
>
>
>
> SQL> cd /tmp
>
> SQL> !pwd
>
> /tmp
>
>
>
> SQL> store set settings replace
>
> Wrote file /tmp/settings.sql
>
> SQL> _at_settings
>
> Autotrace Disabled
>
> Usage: SET DESCRIBE [DEPTH {1|n|ALL}] [LINENUM {ON|OFF}] [INDENT {ON|OFF}]
>
> SP2-0158: unknown SET option beginning "setlongchu..."
>
> SQL>
>
>
>
>
>
> On Sat, Jan 6, 2018 at 11:34 PM, Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
> On 01/04/2018 07:21 PM, Sayan Malakshinov wrote:
>
> And I've just found another bug: If I save SQLcl settings with "store set
> sqlplus_settings.sql replace" and execute _at_sqlplus_settings.sql to restore
> them, SQLcl returns a couple of errors:
>
> SQL>store set sqlplus_settings.sql replace
> Wrote file S:\sqlplus_settings.sql
>
>
> Sayan, SQLCl is Linux stuff. I know that it is written in Java and that
> Java is supposed to be portable, but using SQLCl on Windows is illegal in
> some states.
>
>
>
>
> --
> Mladen Gogala
> Database Consultant
> http://mgogala.freehostia.com
>
>
>
>
>
> --
>
> Best regards,
> Sayan Malakshinov
>
> Oracle performance tuning engineer
>
> Oracle ACE Associate
> http://orasql.org
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 09 2018 - 07:49:28 CET

Original text of this message