Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Formatting bug: subqueries in column list indented incorrectly

3141379Jul 8 2026 — edited Jul 8 2026

When there is a query with a subquery in the column list, indentation doesn't happen as I would expect.

Example query:

SELECT 'one' AS c1 ,( SELECT 'hi' FROM dual ) AS greeting ,'3rd' AS c3 FROM dual;

is formatted to:

SELECT 'one' AS c1
      ,(
  SELECT 'hi'
  FROM dual
) AS greeting
      ,'3rd' AS c3
FROM dual;

notice lines 3-5 are back at the same indentation level as SELECT. I would expect those to be at the same level as the other items in the column list:

SELECT 'one' AS c1
      ,(
        SELECT 'hi'
        FROM dual
      ) AS greeting
      ,'3rd' AS c3
FROM dual;

Edit: I just inadvertently found that this bug only happens when ‘Line breaks on comma' is set to ‘before’

Comments
Post Details
Added on Jul 8 2026
2 comments
58 views