RE: SQL Command list history on Linux

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:

 

 

On Fri, Jan 5, 2018 at 2:16 PM, Sayan Malakshinov <HYPERLINK "mailto:xt.and.r_at_gmail.com"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: HYPERLINK "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="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: HYPERLINK "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="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 <HYPERLINK "mailto:gogala.mladen_at_gmail.com"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 <HYPERLINK "mailto:jeff.d.smith_at_oracle.com"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:HYPERLINK "mailto:xt.and.r_at_gmail.com"xt.and.r_at_gmail.com] Sent: Thursday, January 04, 2018 7:05 PM To: Jeff Smith <HYPERLINK "mailto:jeff.d.smith_at_oracle.com"jeff.d.smith_at_oracle.com> Cc: HYPERLINK "mailto:gdherri_at_gmail.com"gdherri_at_gmail.com; HYPERLINK "mailto:neil_chandler_at_hotmail.com"neil_chandler_at_hotmail.com; ORACLE-L <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org>; Mladen Gogala <HYPERLINK "mailto:gogala.mladen_at_gmail.com"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
HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e="http://orasql.org

 

-- 
Mladen Gogala
Database Consultant
HYPERLINK "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="http://mgogala.freehostia.com





 

-- 

Best regards,
Sayan Malakshinov

Oracle performance tuning engineer

Oracle ACE Associate
HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e="http://orasql.org





 

-- 

Best regards,
Sayan Malakshinov

Oracle performance tuning engineer

Oracle ACE Associate
HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=Pi-eZHjm5jOMKjmyXCgngygR5LfKYA1Jrk2UhsXMjew&s=cFcRYvP3EU4GItcYXfrEMjYCRDZ8y6B96Ah57CcjD90&e="http://orasql.org







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





image/png attachment: no-slash.png