Square boxes when formatting SQLs

SQL Navigator
1

Hi all,

When I try to format my SQL using PL/SQL Formatter, the resulting sql is full of square boxes.

See the attached image.

Thanks.
Date

PS: Running SQL Navigator version 6.1.1.1105
image003.jpeg

2

Hi Date,

This issue is caused by the mismatch between SQL Navigator preferences and Formatter options. They both have options to turn ON/OFF tab character and specify the size of tab character. These options are not synchronized so it causes trouble while formatting. Fortunately we have fixed this in our 6.2 beta version. You can download and check it out from the SQL Navigator Beta threads.

Gwen

3

Thanks Gwen.