PL/SQL Beautifer handling of CASE ... WHEN structures

vipi

Member
Hello there,

Don't know if this was already complained or suggested as future enhancement... anyway i couldn't find anything by search in the forum.

What i found a bit annoying is that how PL/SQL Beauty builds CASE ... WHEN structures as a one string. I think it would be nicer to have an option to show those structures in following way:

declare
x number;
l_str varchar2(10);
begin
l_str := case x
when 1 then 'a'
when 2 then 'b'
when 3 then 'c'
when 4 then 'd'
end;
end;

means every WHEN as a new line.

Meanwhile PL/SQL Beautifier put all of them to one line which is quite hard to read especially if there are a lot of when conditions.

declare
x number;
l_str varchar2(10);
begin

l_str := case x when 1 then 'a' when 2 then 'b' when 3 then 'c' when 4 then 'd' end;
end;

thanks in advance
 
Back
Top