Skip to Main Content

SQL Developer

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!

SQL Dev. 19.4 - Advanced format: columns/args alignment wrong when comma before with no space

Franco SolderaDec 30 2019 — edited Jan 12 2020

The alignment of select fileds and procedure's args breaks when setting line breaks before commas and no space after commas:

-- Output

CREATE OR REPLACE PACKAGE BODY emp_mgmt AS

   tot_emps   NUMBER;

   tot_depts  NUMBER;

   FUNCTION hire(

      last_name      VARCHAR2

    ,job_id         VARCHAR2

    ,manager_id     NUMBER

    ,salary         NUMBER

    ,department_id  NUMBER

   )RETURN NUMBER IS

      new_empno NUMBER;

   BEGIN

-- Expected

CREATE OR REPLACE PACKAGE BODY emp_mgmt AS

   tot_emps   NUMBER;

   tot_depts  NUMBER;

   FUNCTION hire(

      last_name      VARCHAR2

     ,job_id         VARCHAR2

     ,manager_id     NUMBER

     ,salary         NUMBER

     ,department_id  NUMBER

   )RETURN NUMBER IS

      new_empno NUMBER;

   BEGIN

It works fine if I set space after commas:

CREATE OR REPLACE PACKAGE BODY emp_mgmt AS

   tot_emps   NUMBER;

   tot_depts  NUMBER;

   FUNCTION hire(

      last_name      VARCHAR2

    , job_id         VARCHAR2

    , manager_id     NUMBER

    , salary         NUMBER

    , department_id  NUMBER

   )RETURN NUMBER IS

      new_empno NUMBER;

   BEGIN

This post has been answered by Vadim Tropashko-Oracle on Dec 30 2019
Jump to Answer

Comments

Post Details

Added on Dec 30 2019
4 comments
429 views