0 
0 Read Time:28 Second
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
Happy
0 %
Sad
0 %
Excited
0 %
Sleepy
0 %
Angry
0 %
Surprise
0 %
Related posts:
Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond 
Hotsos 2013 – Presentation material “Creating Structure in Unstructured Data” 
Het Oracle OpenWorld Preview Evenement (5 september 2013) – 15 sprekers & sessies 
The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper 
Sometimes the cause of a TNS error is ….
SELECT Last_Name,
Salary,
Department_Id
FROM Employees
WHERE Salary < ANY (SELECT Salary
FROM Employees
WHERE Job_Id = ‘it_prog’
ORDER BY 2)
AND Job_Id <> ‘it_prog’
ORDER BY 1
thanksssss
I was looking for this tools
Cool, I’ve been missing the SQL formatter in SQL*Navigator ever since I changed jobs. The option to download Online SQL Formatter and integrate it into our build is very tempting… Thanks for the pointers!