Re: SQL Command list history on Linux

Jeff,

Btw, I have found another bug with file completion in SQLcl on Linux: If I type _at_subdirectory/ and press [Tab] it shows files from this subdirectory, and when I add first 2 letters of the file from this subdirectory (ie it becomes "_at_subdirectory/te" ) SQLcl completes filename with / after filename:

[image: Inline image 1]

On Fri, Jan 5, 2018 at 2:16 PM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> Mladen,
>
> > *you have an incorrect separator for the pathname parts.*
> I wonder why do you think so? If you look at the problem carefully you'll
> find that there is no problem with separators.
> Anyway, I use / only, because it allows my scripts to work on any platform
> (for example: https://github.com/xtender/xt_scripts/blob/master/xplan.sql
> )
>
> > *Windows should only be used as...*
> I successfully work on any platform and do not like holy wars and flaming.
> My screenshots from windows: http://orasql.org/
> 2014/10/16/just-a-couple-of-screenshots-of-sqlplusrlwrapcygwinconsole/
> The only thing I really want on Linux is horizontally scrollable
> terminal, because it's really convenient to set linesize 1500 when you need
> to check >20-30 columns.
> Unfortunately I have no time to finish my own terminal for that, so I use
> SQL Developer for that on Linux.
>
> On Fri, Jan 5, 2018 at 12:22 PM, Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> Sayan, you have an incorrect separator for the pathname parts. Things
>> work much better when the separator is "/" instead of "\". I have no
>> problems with using "cd /home/mgogala/misc/SQL" and then executing the
>> scripts. Also, please make sure that your desktop can execute "uname -a"
>> command. Windows should only be used as a virtual machine, only for Webex
>> conferences and stuff requiring MS Office and Visio. Even OSX is
>> preferable to Winduhs. After all, OSX is only a badly mutilated version of
>> BSD Unix (Darwin).
>>
>> On 01/04/2018 07:18 PM, Sayan Malakshinov 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
>>
>>
>> --
>> Mladen Gogala
>> Database Consultanthttp://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




image/png attachment: image.png