You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Aug 30, 2024. It is now read-only.
With the default formatter settings the following formatter input
with e as (select*from emp where deptno =10) select*from e;
produces this result:
with e as (
select*from emp
where deptno =10
)
select*from e;
I think the named queres should be indented an additional level, something like this:
with
e as (
select*from emp
where deptno =10
)
select*from e;
It should be possible to add a line break after the with keyword.
Here's a query that shows the wrong indentation:
with
function f (
in_value innumber
) return number is
begin
return in_value;
end;
e as (
select f(empno) as empno,
ename,
deptno
from emp
where deptno =10
)
select*from e;
Expected is a result like this:
with
function f (
in_value innumber
) return number is
begin
return in_value;
end;
e as (
select f(empno) as empno,
ename,
deptno
from emp
where deptno =10
)
select*from e;
With the default formatter settings the following formatter input
produces this result:
I think the named queres should be indented an additional level, something like this:
It should be possible to add a line break after the
withkeyword.Here's a query that shows the wrong indentation:
with function f ( in_value in number ) return number is begin return in_value; end; e as ( select f(empno) as empno, ename, deptno from emp where deptno = 10 ) select * from e;Expected is a result like this:
with function f ( in_value in number ) return number is begin return in_value; end; e as ( select f(empno) as empno, ename, deptno from emp where deptno = 10 ) select * from e;