Dear community. thanks for the help.
Is there a way to do cascade merge on parent/child tables.
create table p
( x int primary key, pname varchar2(100) not null);
create table c
( a int primary key, x references p,
cname varchar2(100));
before image:
insert into p ( x,pname) values ( 1,'john');
insert into c(a,x,cname) values (1,1,'johnson1');
insert into c(a,x,cname) values (2,1,'johnson2');
after image:
insert into p ( x,pname) values ( 2,'mary');
insert into c(a,x,cname) values (3,1,'maryson1');
insert into c(a,x,cname) values (4,1,'maryson2');
--select * from c
update c set cname = 'mary'||'_'||cname where a = 2