Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Formatter help.

stomFeb 20 2024 — edited Feb 20 2024

Hi,

Version 23.1.1.345 on Windows 11

I have been trying to toggle the formatter settings to align CASE and AGGREGATE functions and could use some help.

for example, consider the following statement.

  1. the first case statement's END is not aligned with CASE.
  2. the second case statement is okay but the closing parenthesis for MAX is not aligned.

SELECT 'ShowForumIssue' AS text
, CASE
WHEN 'A' = 'A' THEN 'True'
ELSE 'False'
END AS result
, MAX(
CASE
WHEN 'A' = 'A' THEN 'True'
ELSE 'False'
END
) AS max_result
FROM dual;

Comments
Post Details
Added on Feb 20 2024
4 comments
122 views