Return
-
Title
Is there a formatting option for the if/then statements with and/or statements to be tied togethe -
Description
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));
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.