Re: SQL Command list history on Linux

Jeff,

*But, if you find a bug, please report it to My Oracle Support.*

Oh, thanks, I would like to keep my nerves and time. /* I have enough bugs with database and I'm pretty happy with sqlplus+rlwrap :) */ I'm pretty sure that you are much better than engineers from support for such cases :D
Btw, it seems that SQLcl doesn't support -prelim option?

Mikhail,

Thanks, I've tried it 3-4 years ago, but don't remember why it didn't work for me. I'll check it again :)

On Fri, Jan 5, 2018 at 11:30 PM, Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

> Hi Sayan,
>
> 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.
>>
>
> I used to miss such a thing too but I saw Tanel Poder using Terminator
> once: https://github.com/software-jessies-org/jessies/wiki/Terminator
> I have been using it on Linux mostly. I had some issues with Terminator
> handling single-byte Cyrillic encodings in the beginning, but then switched
> to NLS_LANG=.AL32UTF8 and it was a smooth experience with the tool.
> Not so smooth with Oracle products, like: Output widths change after
> upgrade, or change of character set (Doc ID 330717.1), (wrote a script to
> produce "column <column_name> format <format>" for a table given as input
> since I was tired of scrolling horizontally having done something like
> select * from v$session :)).
>
> Regards,
> Mikhail Velikikh.
>
> On 5 January 2018 at 11:16, 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/xt
>> ender/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/201
>> 4/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