Re: SQL Command list history on Linux

with "this is how to duplicate it " details.

:)

On Fri, Jan 5, 2018 at 1:43 PM, Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> The dreaded, works for me.
>
>
>
> Love the feedback and that you’re going crazy with the testing. We do want
> the feedback. But, if you find a bug, please report it to My Oracle Support.
>
>
>
> Jeff
>
>
>
>
>
> *From:* Sayan Malakshinov [mailto:xt.and.r_at_gmail.com]
> *Sent:* Friday, January 05, 2018 6:24 AM
> *To:* Mladen Gogala <gogala.mladen_at_gmail.com>
> *Cc:* Jeff Smith <jeff.d.smith_at_oracle.com>; Dave Herring <
> gdherri_at_gmail.com>; neil_chandler_at_hotmail.com; ORACLE-L <
> oracle-l_at_freelists.org>
>
> *Subject:* 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
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_xtender_xt-5Fscripts_blob_master_xplan.sql&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=Qhr9oGSGu0SBbLT31YpYjxhQ3pSLtc2loQtgtSC6_tg&e=>
> )
>
>
>
> > *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/
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org_2014_10_16_just-2Da-2Dcouple-2Dof-2Dscreenshots-2Dof-2Dsqlplusrlwrapcygwinconsole_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=Kwwsxby1j-lmZd20qmdyKRwVFd2X3ruoh7zwQGHa_PU&e=>
>
> 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
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e=>
>
>
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> http://mgogala.freehostia.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__mgogala.freehostia.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=kzHT0jDlcoMTzNEv_H5NVmII8bZLpp-RWdK8XxvbFc4&e=>
>
>
>
>
>
> --
>
> Best regards,
> Sayan Malakshinov
>
> Oracle performance tuning engineer
>
> Oracle ACE Associate
> http://orasql.org
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e=>
>
>
>
>
>
> --
>
> Best regards,
> Sayan Malakshinov
>
> Oracle performance tuning engineer
>
> Oracle ACE Associate
> http://orasql.org
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e=>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info





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




image/png attachment: image001.png