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.
select*from (
select to_number(
sys_context('userenv', 'current_schemaid') default nullon conversion error,
'99999990',
q'[nls_numeric_characters='.,']'
) as model_id
from dual
);
Formatter result with default settings:
select*from (
select to_number(
sys_context('userenv', 'current_schemaid') default nullon conversion error,
'99999990',
q'[nls_numeric_characters='.,']'
) as model_id
from dual
);
See the line break before on conversion error and the wrong indentation. Indentation is expected to be the same as the previous and next line (if a line break would be necessary).
Formatting just the subquery like this:
select to_number(
sys_context('userenv', 'current_schemaid') default nullon conversion error,
'99999990',
q'[nls_numeric_characters='.,']'
) as model_id
from dual;
Original statement and expected result:
Formatter result with default settings:
See the line break before
on conversion errorand the wrong indentation. Indentation is expected to be the same as the previous and next line (if a line break would be necessary).Formatting just the subquery like this:
works as expected.