PL\SQL Beautifier

[sinys]

Please, add this version

select /*new line*/
         depno as department_number,
         dname as departmen_name,
         loc   as department_location
  from   /*new line*/
         dept,
         emp
  where  /*new line*/
         emp.empno = p_empno
         and dept.deptno = emp.deptno;

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[sinys]

Do you remember about this?

 

[Marco Kalter]

Yes, it's still on the list.

 

[sinys]

it can be expected in version 9.1?

 

[Marco Kalter]

We don't know yet which features will be in 9.1, but this is indeed one of the candidates.

 

[riphkin]

Please, add this style

select m.ENAME
      into result
      from EMP e,
           EMP m
     where e.EMPNO = P_EMPNO
       and m.EMPNO = e.MGR
       and d.DEPTNO in (10, 20, 30, 40);

where aliases in lowercase, but field name and parameters in uppercase.
And add in CASE-WHEN-THEN-END section AND/OR under where clause, both for WHERE-section.

 

[Frank Kintrup]

Please, add this style

select m.ENAME
      into result
      from EMP e,
           EMP m
     where e.EMPNO = P_EMPNO
       and m.EMPNO = e.MGR
       and d.DEPTNO in (10, 20, 30, 40);

where aliases in lowercase, but field name and parameters in uppercase.
And add in CASE-WHEN-THEN-END section AND/OR under where clause, both for WHERE-section.

I would love to see this style!