Coming Soon: A More Forgiving Formatter

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

For 17.4, the formatter will attempt to format invalid SQL for you.

If the parser runs into a problem recognizing your code, it will format it as much as it can. But that’s not all.

It will ALSO go to the end of your statement, and traverse the SQL in the other direction and continue formatting as far as it can.

Let’s look at an example:

Before

the parser squiggle after the first pipe indicates it doesn’t understand what’s going on at that point.

But hey, let’s format it anyway.

Cause hey, we’re trying to fix the code, but it’s so hard to read. We could really use the formatter’s help.

Almost

Ok, a bit more obvious where the problem is now, and it did format the SQL a good bit.

Adds the missing pipe |, formats again.

After

Ta-da!

When does 17.4 come out?

Soon’ish. But the name should give you a pretty good hint.

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *