Hello, is there some way to set the package indent to 0, but still have ident 2 in other places?
I want this:
but when i use Beautifier for the whole package, i get this:
I is very important for our company start at the begining of the line in packags.
Thx for help!
I want this:
Code:
create or replace package body
function mgrname(p_empno in emp.empno%type) return emp.ename%type is
result emp.ename%type;
i integer;
begin
result := null;
i := 1;
if p_empno is null then
-- If empno is null, return an empty name
result := null;
else
-- Fetch the name of the manager
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);
end if;
return(result);
exception
when no_data_found then
return(null);
end;
end;
but when i use Beautifier for the whole package, i get this:
Code:
create or replace package body
function mgrname(p_empno in emp.empno%type) return emp.ename%type is
result emp.ename%type;
i integer;
begin
result := null;
i := 1;
if p_empno is null then
-- If empno is null, return an empty name
result := null;
else
-- Fetch the name of the manager
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);
end if;
return(result);
exception
when no_data_found then
return(null);
end;
end;
I is very important for our company start at the begining of the line in packags.
Thx for help!