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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
1 comment
98 views