Friday, April 21, 2006

SQL Formatter

Came across this very nice tool to format SQL and PL/SQL Statements

Really good and I think I will use this a lot, the application that I regularly support has too many SQL’s that are not formatted and it drives me crazy to debug them, I usually end up rewriting the entire SQL.

I have this thing with formatted code and I always make it a point to format and indent my code and when I was teaching in NIIT I used to always ask (should I say force) my students to indent and format the code or risk loosing the program. Lot of them learnt it the hard way but not sure how many people carried that into their day jobs.

A Program is like your handwriting the more you format your code and write it the more people would be able to read it and support it.

 

 

No comments: