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.
create or replacetriggerdept_br_u
before update of department_id,department_name
on departments for each row
begininsert into departments_log (
department_id
,department_name
,modification_date)
values (:old.department_id
,:old.department_name
,sysdate);
end;
/
produces this formatter result:
create or replacetriggerdept_br_u
before update of department_id,department_name
on departments for each row
begininsert into departments_log (
department_id
,department_name
,modification_date)
values (:old.department_id,:old.department_name,sysdate);
end;
/
This different behavior was introduced in sqldev-22.2.0. Worked as expected in sqldev-21.4.3
This input (and expected output)
produces this formatter result:
This different behavior was introduced in sqldev-22.2.0. Worked as expected in sqldev-21.4.3
Default settings, changed the following: