Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[19.4] custom keys inactive in view "SQL" tab

B.DelméeJan 6 2020 — edited Jan 7 2020

It seems that with v19.4, the custom shortcut keys (e.g. "select to matching brace") are not usable anymore in the "SQL" tab of a view.

This was still working in 17.4 (my daily driver) and probably 19.3 which i only used briefly.

I find this very handy when viewing a complicated view and capturing bits of it.

Pet peeve of mine: these little gratuitous changes (and sometimes regressions as with the excel date export issue)

make what should be a no-brainer (let's adopt the latest quarterly edition) a somewhat risky proposition.

Comments

You're saying that none of your custom keyboard shortcuts are working? Or just this specific Instance?

There was no v19.3

Bugs are also my pet peeve

B.Delmée

Sorry, yes, I meant 19.2 (and 19.2.1)

"goto matching brace" and "select to matching brace" are about the only two i use often in this context and they have stopped working. They are still working in a regular worksheet, only not in the view browser.

Ah, missed that distinction the first time

I've never used this set of matching brace kb commands before

Do you have a bit of text that would trigger a working example for Alt+[ which should find for me a matching brace?

Jeff

B.Delmée

Anything with braces should do, here's a rather trivial example below.

WITH src( ID, str, dt )  AS ( 

    SELECT LEVEL, 'STR' || LEVEL, DATE'2020-01-01' + LEVEL - 1 

    FROM dual 

    CONNECT BY LEVEL <= 366 

SELECT EXTRACT(MONTH FROM dt) mm, COUNT(*) cnt, round(AVG(ID)) avgid 

FROM src 

GROUP BY EXTRACT(MONTH FROM dt) 

ORDER BY 1

;

We have complicated views with several stacked "WITH" clauses and capturing them between their delimiting parentheses is handy (and also a way to navigate and skip big logical blocks when trying to understand them).

Sometimes a WITH clause builds on a previous one and a view actually implements a transformation pipeline. Some of these have several hundred LOCs.

PS I just assigned <Alt><end> as a duplicate for <Ctrl><<end> (end of file) and this one works both in a worksheet and the view "SQL" tab. So perhaps there is something special in the brace matching case...

I am on windows 7 (64 bit) using the system-wide JDK (32bit)

Java(TM) Platform1.8.0_192
Oracle IDE19.4.0.354.1759
Versioning Support19.4.0.354.1759

Ha, because I was playing with actual brackets [{ vs parens.

Not sure what happened here but I'll log a bug for you.

Hopefully a workaround for copying view text to a proper sql worksheet will suffice until 20.1 is available.

B.Delmée

No biggie, that is what i was doing before Vadim made the view "SQL" tab smarter at my request ;-)

B.Delmée

I just noticed this also affects the report editor; can you add this to your bug description ? Thanks, Jeff.

B.Delmée

Ping - just hoping this can make it to the backlog someday …

user9540031

@b-delmee : 15 years using SQL Dev, and I had never noticed these 2 keyboard shortcuts existed. Thank you!

(The default key assignments for these 2 are broken on a French keyboard, BTW, but they do work once redefined to something that my keyboard may actually emit. And, yes, as of SQL Dev 21.4.3, they do work in SQL worksheets, in the PL/SQL code editor, but not in the SQL tab of the view editor.)

Regards,

1 - 10

Post Details

Added on Jan 6 2020
10 comments
391 views