Beautifier with Procedure call by named notation

[Jeff81]

When I call a procedure by named parameter notation it gets beautified like this.

test_proc(p_name => 'FOO', p_name1 => 'BAR', p_value1 => 'Jeff');

But I would prefer it to look like this.

test_proc(p_name   => 'FOO',
          p_name1  => 'BAR',
          p_value1 => 'Jeff');

The only way to change this is to change the Item Lists format to be One Item Per Line. But then that also changes the IN clause in your where statements to look like below which I don't like. Is there a way to separate the two distinctions.

SELECT *
    FROM emp
   WHERE emp_id IN (1,
                    2,
                    3);

 

[Marco Kalter]

There is indeed not distinction between parameter lists and other item lists. This is on the list of enhancement requests.

 

[Theod]

Hi,

as workaround I use an comment after the first parameter.

test_proc(p_name => 'FOO', --
p_name1 => 'BAR',
p_value1 => 'Jeff');

 

[Jeff81]

Hi,

as workaround I use an comment after the first parameter.

test_proc(p_name => 'FOO', --
p_name1 => 'BAR',
p_value1 => 'Jeff');

Thanks for the tip but unfortunately that didn't work for me.