Enhancement request to format CASE, WHEN, THEN, ELSE, END AS statements by moving them to the left hand side in order to eliminate the spaces. Also, an option to place these statements on the same line.
Here is an example of the code:
CASE
WHEN test1IS NULL
THEN '$$START'
ELSE test2
END AS test3,
CASE
WHEN test2 IS NULL
THEN location
ELSE combination_id
END AS combination
WORKAROUND:
None
STATUS:
Enhancement request ST58943 has been submitted to Development for consideration in a future release of TOAD for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center