clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591697 fiddles created (45712 in the last week).

select * from V$VERSION;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production 0
 hidden batch(es)


create table t ( a int, b int, c int, primary key (a) ) ;
 hidden batch(es)


insert into t (a, b, c) values (1, 2, 3) ;
1 rows affected
 hidden batch(es)


insert into t (a, b, c) values (2, 5, 7) ;
1 rows affected
 hidden batch(es)


insert into t (a, b, c) values (3, 4, 7) ;
1 rows affected
 hidden batch(es)


CREATE OR REPLACE TRIGGER testing_mutating_table BEFORE UPDATE ON t FOR EACH ROW BEGIN IF :NEW.b <> :OLD.b OR :NEW.a <> :OLD.a THEN :NEW.c := :NEW.a + :NEW.b ; END IF ; END ; /
 hidden batch(es)


update t set b = 20 where a = 3 ;
1 rows affected
 hidden batch(es)


select * from t ;
A B C
1 2 3
2 5 7
3 20 23
 hidden batch(es)