Toad Formatter Plus is formatting ANSI syntax in a confusing pyramid structure. I cannot get it aligned into one line.
How Toad is Formatting the SQL now:
SELECT b.*
FROM rso_pitem_9999 a
JOIN
rso_pitem_9999_map b
ON (a.asset_id = b.asset_id)
JOIN
esearch.rso_attachments att
ON (b.item_id = att.item_id)
LEFT OUTER JOIN
esearch.box_descriptions2 box
ON (b.item_id = box.item_id)
LEFT OUTER JOIN
esearch.cop_box_descripti2 cop
ON (b.item_id = cop.item_id)
WHERE (box.item_id IS NOT NULL
OR cop.item_id IS NOT NULL);
How I would like it formatted:
SELECT b.*
FROM rso_pitem_9999 a
JOIN rso_pitem_9999_map b
ON (a.asset_id = b.asset_id)
JOIN esearch.rso_attachments att
ON (b.item_id = att.item_id)
LEFT OUTER JOIN esearch.box_descriptions2 box
ON (b.item_id = box.item_id)
LEFT OUTER JOIN esearch.cop_box_descripti2 cop
ON (b.item_id = cop.item_id)
WHERE (box.item_id IS NOT NULL
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center