Skip to Main Content

19.2.1 Toggle ANSI/Oracle Joins: removes statement semi-colon

chromedomeDec 10 2019 — edited Dec 10 2019

Saw Jeff's video about the new 19.2 toggle. Tried it out before announcing it to my 50 engineers.

The formatting options applied are still disappointing, but that's another discussion.

Just reporting a minor bug, that if the old statement had a semi-colon at the end, after letting SQL Developer re-write it for ANSI joins, the semi-colon is silently removed. So developer gets to mouse, point, click, add semi-colon back, or recompile (most of our SQL is in PL/SQL) and find out the hard-way.

Post Details
Added on Dec 10 2019
1 comment