Tuesday, May 20, 2014

Whitespace and SQL formatting

Today I share something I learned from Ric Van Dyke while continuing the blog spotlight, in that the PL/SQL engine actually breaks down the SQL bits of code into machine readable (formatted) text by standardizing the spacing so that the engine can digest it in a uniform manner.  I have been aware that the comments and spacing were removed or ignored, but I never knew why and now I do.  It even created a good exchange in the comments section too and you may get some new ideas there!

No comments:

Post a Comment