Toad World® Forums

Case format


#1

When I format a SELECT statement with an AND in the WHEN, the AND gets put all the way on the left margin. it should be with the WHEN. Example:

SELECT CASE
WHEN 1 = 2
AND 3 = 4 THEN
‘no’
ELSE
‘yes’
END
fld
FROM DUAL;

Thanks.
-Charlie


#2

Hi Charlie,

Thanks for reporting this. PT49820765 is raised for you. We need to wait for the formatter team to address the issue. I will let you know when we can fix it.

Thanks,
Vincent