SQL Formatting problem

[Dwayne]

I'm getting frustrated with the formatting engine for DML statements - I can't figure out if I just haven't found the right option yet, or if it doesn't support what I'm trying to do.

Take this example:

CREATE TABLE monitor_user_chart_preferences
(
   account_name                    VARCHAR2(15)           NOT NULL,   chart                                          VARCHAR2(30)           NOT NULL,   region                                  VARCHAR2(50),   report_period                            VARCHAR2(30)           NOT NULL,   start_date                                  TIMESTAMP,   end_date                                    TIMESTAMP,  CONSTRAINT pk_user_chart_preferences PRIMARY KEY (account_name, chart))
MONITORING
TABLESPACE paws_systems
;

Now, why when I format this (Edit -> PLSQL Beautifier) is it not compressing all the ugly extra spaces, and putting each column on a new line?

What options do I need to have enabled to make this happen?

In the formatter options I see tabs for formatting preferences for Control Structures, DML, Parameters, but nothing for DDL. Is there some place I haven't looked?

Thanks

 

[Gustavo]

"CREATE TABLE" is not DML, it is DDL. DDL is not PL/SQL code, so the beautifier does not apply to it. Having DDL beautified is already on the list of enhancement requests.

 

[Dwayne]

Yes, I understand the difference between DML and DDL.

Glad to hear it's on the "to do" list

DK