SQL formatting Oracle Headquarters Redwood Shores1 e1698667100526

SQL formatting

Eddie Awad has a nice blog about three apps to format your SQL code. Especially the online tools, SQLinForm en the Online SQL Formatter, are very nice. Both offer some options to select the SQL dialect and the output format (e.g. upper/lowercase) and language (SQL, VB, Java etc). The former, being a java applet, is more feature-rich than the latter. Example:

select ename from (select ename from emp order by sal desc) where rownum < 4

becomes

SELECT ename
FROM
    ( SELECT ename
    FROM emp
    ORDER BY sal desc
    )
WHERE rownum < 4

3 Comments

  1. colour-coded sql testing July 19, 2006
  2. eduardo ivan pichler December 28, 2005
  3. Scott Mitchell December 14, 2005