Re: SQL Command list history on Linux

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 5 Jan 2018 15:54:35 +0800
Message-ID: <CAB=aETA9mLDJ4SykpzBTvYOOXMhZX_T5tJb+hCUMkaR8G4eXMQ_at_mail.gmail.com>



sqlplus is a little faster to start than sqlcl, but not something that I think would be deemed a show-stopper,

eg here

https://imgur.com/a/Ft4d2

On Fri, Jan 5, 2018 at 8:21 AM, Sayan Malakshinov <xt.and.r_at_gmail.com> 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
>
> SQL>_at_sqlplus_settings.sql
> Autotrace Disabled
> Usage: SET DESCRIBE [DEPTH {1|n|ALL}] [LINENUM {ON|OFF}] [INDENT {ON|OFF}]
> SP2-0158: unknown SET option beginning "setlongchu..."
>
>
> On Fri, Jan 5, 2018 at 3:18 AM, Sayan Malakshinov <xt.and.r_at_gmail.com>
> wrote:
>
>> Jeff,
>>
>> Ah, it seems I found a bug: sqlcl can't find files from virtual drives
>> mounted with subst command.
>> My S: drive was created with "subst S: n:\s" command and sqlcl
>> auto-completion can't find files from S:\, though it can execute them.
>> But if I change directory to N:\s (original location), it works fine.
>>
>>
>> On Fri, Jan 5, 2018 at 3:09 AM, Jeff Smith <jeff.d.smith_at_oracle.com>
>> wrote:
>>
>>> In my windows My Documents folder
>>>
>>>
>>>
>>> After starting sqlcl, I used the CD command to nav to that directory, so
>>> that’s where SQLcl is looking.
>>>
>>>
>>>
>>> Jeff
>>>
>>>
>>>
>>>
>>>
>>> *From:* Sayan Malakshinov [mailto:xt.and.r_at_gmail.com]
>>> *Sent:* Thursday, January 04, 2018 7:05 PM
>>> *To:* Jeff Smith <jeff.d.smith_at_oracle.com>
>>> *Cc:* gdherri_at_gmail.com; neil_chandler_at_hotmail.com; ORACLE-L <
>>> oracle-l_at_freelists.org>; Mladen Gogala <gogala.mladen_at_gmail.com>
>>> *Subject:* Re: SQL Command list history on Linux
>>>
>>>
>>>
>>> Jeff,
>>>
>>>
>>>
>>> I haven't understood, where are your lo* files located?
>>>
>>>
>>>
>>
>>
>>
>> --
>> 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
>

-- 
Connor McDonald
===========================
blog:   connormcdonald.wordpress.com
twitter: _at_connor_mc_d

"If you are not living on the edge, you are taking up too much room."
- Jayne Howard

*Fine print: Views expressed here are my own and not necessarily that of my
employer*

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 05 2018 - 08:54:35 CET

Original text of this message