Oracle DBA – A lifelong learning experience

Posts Tagged ‘commas and sql’

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




Posted in Oracle | Tagged: , | Leave a Comment »