Forum Stats

  • 3,854,725 Users
  • 2,264,414 Discussions
  • 7,905,772 Comments

Discussions

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

chromedome
chromedome Member Posts: 19
edited Dec 10, 2019 4:27PM in SQL Developer

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.

Answers