Topic: Question about delete and fk
There is table A with field A.id
There is table B with fields id, header_id, a_id
Is FK B.a_id => A.id
It is necessary to delete records from A request of a type
delete from A where A.id in (select a_id from b where header_id=1);
update B set a_id=null where header_id=1;
But on delete works FK.
Whether it is possible such trivial task to solve SQL without temporary tables and PL/SQL?