Aqua Data Studio - CTRL+B Beautifies Query

In a query pane in Aqua Data Studio… turn a query that looks like this:

into a beauty, like this:

All by pressing CTRL+B.

For the text equivalent:

select m.city, m.st, count(*)
from ___________ m 
inner join ____________ z
on m.city = z.city and 
m.st = z.state and
m.zip = z.zip_code WHERE
m.zip > '' AND 
m.st > '' AND 
m.city > '' AND 
z.city is null AND 
z.state is null and 
z.ZIP_CODE is null
group by m.city, m.st, m.zip 
HAVING count(*) <= 1 ;

into:

SELECT
	M.CITY,
	M.ST,
	COUNT(*) 
FROM
	__________ M 
		INNER JOIN __________ Z 
		ON M.CITY = Z.CITY AND
		M.ST = Z.STATE AND
		M.ZIP = Z.ZIP_CODE 
WHERE
	M.ZIP > '' AND
	M.ST > '' AND
	M.CITY > '' AND
	Z.CITY IS NULL AND
	Z.STATE IS NULL AND
	Z.ZIP_CODE IS NULL 
GROUP BY
	M.CITY,
	M.ST,
	M.ZIP 
HAVING
	COUNT(*) <= 1

About these ads