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!

Customize SQL Formatter in VS Code extension

JiF BrodeurJan 29 2025

Hi, since the original user @barciaandres did not create a new post, I will since I have the same issue.

On VS Code SQL Developer extension 24.4.1

With Settings: Sqldeveloper › Format › Line Breaks: On Comma

Dictates how commas are handled

→ No Breaks

DECLARE

dummy_1 NUMBER;

dummy_2 NUMBER(12);

dummy_3 NUMBER(12,2);

dummy_4 NUMBER(12,4);

dummy_5 NUMBER(12,3);

BEGIN

NULL;

END;

The formatted result is

DECLARE

Dummy_1 NUMBER;

Dummy_2 NUMBER(12);

Dummy_3 NUMBER(

12,2

);

Dummy_4 NUMBER(

12,4

);

Dummy_5 NUMBER(

12,3

);

BEGIN

NULL;

END;

The formatter breaks the line after “NUMBER(” when decimal number are declared.

With the parameter set to No Breaks this seems to be a bug.

Is there a way to modify this behaviour?

Thanks

Jean-François and Barcia

Comments
Post Details
Added on Jan 29 2025
6 comments
881 views