PL/SQL Beautifier Rules add-on

[Kerplunk]

my previous company is using pl/sql developer. now in my new company, theyre not using that, so i downloaded a trial version and thinking of purchasing an annual contract before the trial period ends. im a fan of pl/sql beautifier rules feature however there is a format rule i would love to use. it would be nice if i can have the option of placing the parenthesis in the insert statement, parameter declaration, etc.
INSERT INTO dept
(deptno,
dname,
loc)
VALUES
(10,
'Accounting',
'New York');
can be changed to
INSERT INTO dept (
deptno,
dname,
loc
)
VALUES (
10,
'Accounting',
'New York'
);
or
PROCEDURE insertdept
(
p_deptno IN OUT dept.deptno%TYPE,
p_dname IN dept.dname%TYPE,
p_loc IN dept.loc%TYPE
) IS
can be changed to
PROCEDURE insertdept (
p_deptno IN OUT dept.deptno%TYPE,
p_dname IN dept.dname%TYPE,
p_loc IN dept.loc%TYPE
)
IS

thanks!

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Swift]

Hi, i'm offer to enhance this feature even more:
"Parameter Declaration" option in PL/SQL beautifier har check to List at left margins, you may add another check, like "Leave parenthesis on same line", to get result:
PROCEDURE insertdept (
p_deptno IN OUT dept.deptno%TYPE,
p_dname IN dept.dname%TYPE,
p_loc IN dept.loc%TYPE)
IS
Or maybe do invariants with parenthesis like:
on same line, on new line, on separate line.
And i think very important thing about this, to do this option available for "General" beautifier option "Item lists" to get beautiful parameters list when you call a procedure, like this:
result := insertdept (
deptno_param_value,
dname_param_value,
loc_paramvalue);
or
result :=
insertdept (
deptno_param_value,
dname_param_value,
loc_paramvalue);
Thank you!

- as 3 spaces or tab simbol

 

[Dwayne]

I would also love it if the beautifier would support formatting of DDL statements (i.e. CREATE TABLE).

Is this on the enhancement list yet?