删除父数据时删除子表数据的create procedure

Question

create table a (
a_id integer,
a_name varchar2(10),
    PRIMARY KEY (a_id)

)

create table b(
b_id,
b_name varchar2(10),
a_id integer,
PRIMARY KEY (a_id),
FOREIGN KEY (a_id) REFERENCES a(a_id)
)

Answer 1

如果子项具有链接到父项的FK，则可以在父项上使用DELETE CASCADE。

CREATE TABLE book
( book_id int not null, 
 book_name varchar(50) not null, 
 CONSTRAINT book_pk PRIMARY KEY (book_id) 
); 


CREATE TABLE bookdetails
( detail_id int not null, 
 book_id int not null, 
 CONSTRAINT fk_book
   FOREIGN KEY (book_id) 
  REFERENCES book(book_id) 
  ON DELETE CASCADE 
); 

Answer 2

完成所需的过程只需更改过程中的表名

访问https://anzblog.com/2017/04/29/create-procedure-delete-child-table-data-parent-data-deleted/，据我所知，它将适用于you.As。