I’ve been using SQL Developer a lot lately for data analysis and I’ve been getting used to the auto formatting to easily create well readable code out of my garbled-“I’m in a hurry”-SQL-mess.
This works like a charm, except for the comma’s which kept showing up at the end of the column names after the auto formatting, a small annoyance which is easily solved with this trick.
This is the default auto-formatting which is used by SQL Developer:
SELECT t1.column1, t1.column2, t2.column3 FROM table1 t1 JOIN table2 t2 ON t1.value1 = t2.value2;
You can change this behaviour by accessing the following settings:
Tools -> Preferences -> Database -> SQL Formatting -> Oracle Formatting -> Press button “Edit”
In the Oracle Formatting window: Line-breaks -> Select “Before comma” and deselect “After comma”
After this trick, the default formatting will have this code as a result:
SELECT t1.column1 , t1.column2 , t2.column3 FROM table1 t1 JOIN table2 t2 ON t1.value1 = t2.value2;
Happy querying! 🙂