Is there a formatting option for the if/then statements with and/or statements to be tied together?
For example:
IF (det_id = 0) AND (plevel = 'P' OR plevel = 'B') THEN
NULL;
END IF;
The request is to get the above formatting results, instead, the formatter is doing the following:
IF (det_id = 0)
AND (plevel = 'P'
OR plevel = 'B') THEN
NULL;
END IF;
The and/or statements are being stacked in select statements as well:
SELECT *
FROM test
WHERE x = 2
AND y = 4
OR ((x=1) and (y=2));
WORKAROUND
None
STATUS
Enhancement request ST56590 has been submitted to Development for consideration
in a future release of TOAD for Oracle.