Oracle DBA – A lifelong learning experience

Commas at the beginning or end of a sql code line

Posted by John Hallas on August 18, 2016

Back in Nov 2015 I commented on a Oracle-L discussion about What happened to SQL*Developer SQL Formatter asking why people liked to see a comma at the beginning of the line in sql code and there was a fair bit of input into how it was easier to use and amend  – think of it like bullet points was one comment.

Fair enough I though and I have used that technique when I remember ever since.

Then I saw a post by Connor McDonald on how the syntax formatter  – or your own hand formatted code might give the wrong results if you are not careful about the placing of commas.

Looks like it is back to the drawing board for me then and commas on the right



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: