Online SQL Formatter

Quite frequently nowadays, I come across large SQL queries which I need to debug. Problem is, sometimes these queries come in one very long string without any linebreaks. Pretty hard to read, huh.

Help's at hand (thanks to "google sql formatter") - there's this online SQL formatter at :
http://www.sqlinform.com

It's a Java applet, no source but free for use. Just accept the disclaimer and paste your SQL into the textbox. It comes with syntax colouring too. Very nice.

Some other alternatives to consider :

1. http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm
2. http://home.comcast.net/~danmeany/sqlformatter.html

(2005-07-15 18:07:31 SGT) [Tech] Permalink

Comments:

Post a Comment:

Comments are closed for this entry.

« Mozilla Firefox... | Main | HP to slash 15000... »

Most popular blog postings on lowem.log :

1. Singapore MRT rail network length to double by 2020
2. 2010 Nissan Leaf electric car specifications : 107hp, 24KWh lithium-ion batteries, 100-mile range
3. Live spot gold price quotes chart on COMEX
4. 2010 Toyota Prius specifications released : 50 mpg, 1.8L, 134hp, Ni-MH, solar roof option
5. AVG Anti-Virus Free Edition 2011 direct download link
6. Real-time live gold and silver price quotes chart on COMEX
7. Singapore electric vehicles : Government agencies EMA and LTA to study EV introduction
8. Book review : Shut Down by William Flynn

Featured articles on lowem.log :

1. Book review : Shut Down by William Flynn
2. Singapore electric cars testing starts with 9 electric vehicles
3. Honda, GS Yuasa JV to make lithium-ion batteries for 2010/2011 Honda Civic Hybrid
4. 2010 Honda Civic Hybrid preliminary specifications released
5. 2010 Honda CR-Z hybrid, 2010 Honda Fit/Jazz hybrid models confirmed
6. 2010 Toyota Prius specifications released : 50 mpg, 1.8L, 134hp, Ni-MH, solar roof option
7. NYMEX crude oil recovers from $32.40 low after 2.2 mbpd OPEC production cut announced
8. Singapore : Nuclear power not ruled out