There are several options you can change on this screen, and more advanced options are available. The SQL Formatter entry allows you to automatically format the SQL, with the “Autoformat Visible SQL and PL/SQL”. Now, there are many options here for formatting SQL. To find these options, go to Tools > Preferences (on Windows) or Oracle SQL Developer > Preferences (on Mac).Ĭlick on the arrow next to the Code Editor item to expand the Code Editor section. Without this feature, my SQL writing would be a lot worse. The formatting options inside SQL Developer are some of my favourite options in the program. How To Change The SQL Developer Format SQL Options So, there are a few reasons you should format your SQL code. It helps with debugging as well because if the code is well formatted, it’s easier to see where any issues are and work on them. It also makes it easier for others to read.
It makes it easier for you right now, as you’re working on the code. It makes it easier for you to read in the future, for when you need to make changes. Well, this is precisely the reason you should format your SQL code. Have you ever had a look at someone else’s code, and tried to work out what it’s doing, but couldn’t because the code was all over the place? Similar statements weren’t grouped, capitalisation wasn’t used, the code was not indented consistently, and it was just a mess to understand? You can do this manually, or automatically, in SQL Developer. Many of the Oracle SQL IDEs have this feature, including SQL Developer. By this, I mean that the SQL statement will execute if the syntax is correct and the formatting is terrible.įormatting the SQL code will clean up the line breaks, indentation, capitalisation, and overall look of your SQL. When you write SQL, the format of the code is not relevant to the database. SQL formatting is the process of neatly arranging your code to make it more readable. In this article, I’ll explain what formatting SQL is, and how to find the SQL Developer Format SQL options.
0 kommentar(er)
