Hand-picked HTML and CSS code examples, tutorials and articles
CSS Gallery, jQuery plugins

SQL Beautifier

Enter SQL Source code then click Beautify button below to Beautify the SQL code:

Free online tool to Beautify SQL code.

Sample SQL Code

SELECT ca.proj_id AS proj_id, ca.ca_name AS proj_name, ca.ca_date_start AS proj_start, ca.ca_date_end AS proj_end,(SELECT COUNT(*) FROM rotations r WHERE r.proj_id = proj_id AND r.r_status = 'R' GROUP BY r.proj_id) r_count, (SELECT count(*) FROM rotations r WHERE r.proj_id = proj_id AND r.channel_id = 24) r_rtb_count FROM projs ca, clients c, proj_auth caa WHERE ca.client_id = 12345 AND ca.client_id = c.client_id AND ca_type = 'zzz' AND c.agency_id = 0 AND ca.client_id = NVL( caa.client_id, ca.client_id ) AND proj_id = NVL( caa.proj_id, proj_id ) AND caa.contact_id = 7890

Sample Output

SELECT ca.proj_id AS proj_id,
         ca.ca_name AS proj_name,
         ca.ca_date_start AS proj_start,
         ca.ca_date_end AS proj_end,
        
    (SELECT COUNT(*)
    FROM rotations r
    WHERE r.proj_id = proj_id
            AND r.r_status = 'R'
    GROUP BY  r.proj_id) r_count, 
    (SELECT count(*)
    FROM rotations r
    WHERE r.proj_id = proj_id
            AND r.channel_id = 24 ) r_rtb_count
FROM projs ca, clients c, proj_auth caa
WHERE ca.client_id = 12345
        AND ca.client_id = c.client_id
        AND ca_type = 'zzz'
        AND c.agency_id = 0
        AND ca.client_id = NVL( caa.client_id, ca.client_id )
        AND proj_id = NVL( caa.proj_id, proj_id )
        AND caa.contact_id = 7890

Advertisement