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

    Forum Stats

  • 3,702,038 Users
  • 2,239,552 Discussions
  • 7,835,729 Comments

Discussions

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

chromedomechromedome Posts: 19
edited December 2019 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

Sign In or Register to comment.