Beautifier - Array

[Tarquino]

Hi,

When working with bidimensional array sometimes after beautifying we have an extra space after before(.).

For example, before beautifier:

declare
  type rec_var is record (column1 varchar2(10), column2 varchar2(10));
  type t_var is table of rec_var index by binary_integer;
  r_var t_var;
begin
  -- number 1
  r_var(1).column1 := 'Test 1';
  r_var(1).column2 := 'Test 1';

  -- number 2
  select 'Test 2'
        ,'Test 2'
    into r_var(2).column1
        ,r_var(2).column2
    from dual;
end;

Now, after:

declare
  type rec_var is record(
     column1 varchar2(10)
    ,column2 varchar2(10));
  type t_var is table of rec_var index by binary_integer;
  r_var t_var;
begin
  -- number 1
  r_var(1).column1 := 'Test 1';
  r_var(1).column2 := 'Test 1';

  -- number 2
  select 'Test 2'
        ,'Test 2'
    into r_var(2) .column1
        ,r_var(2) .column2
    from dual;
end;

Please note the into clause.

Thanks,
Alexandre Tarquino

 

[Marco Kalter]

This is indeed not correct. We'll fix it.