#SQL CODE FORMATTER CODE#

#SQL CODE FORMATTER CODE#

Not formatting your code in a consistent manner can have a negative impact on performance as well.įor this to make sense, you need to have at least a basic understanding of how SQL statements are processed by the database, so, I’m going to give you a short, and a little over-simplified, explanation about it. So, yes, one of the big reasons to format your code is related to readability, but it is not the only one! Here, if you have to join additional tables, it is very easy to see where the FROM clause is, or if you want to add additional conditions, the WHERE clause is also very easy to spot.įormatting your code can have a huge impact on how easy it is to read and maintain. WHERE salary > 5000 AND department_id ! = 60

I think that is a very important question, and I want to focus on the reasons why everyone should format their SQL code first, to then conclude the article with a short demonstration of how SQL Developer can help you do it, so, let’s get started. What if instead of asking how people format their SQL code, we asked how many people format their SQL code consistently? I’m going to show you the kind of things the auto-formatter can do to help you with your SQL code format, but first, I want to discuss the topic that really got me thinking after seeing the poll results: You know that SQL Developer has a nice auto-formatter, right?

Granted, only about 600 people responded, but still, I couldn’t believe that 60% of the responders format their code manually (and I know that many of the followers of that account are people who work with Oracle databases). A few days ago, I was quickly scanning my Twitter feed, and I saw a poll from a relatively popular Twitter account, asking people how they format their SQL code or how they apply a specific SQL code format.Īfter a couple of days, I looked it up again to see the final results, and I was very surprised when I saw this:

Sql code formatter