Cascading deletion of foreign key constraints between SQL and Oracle

Recently, to delete a record in the software system, you have to associate the record with multiple tables and there are still constraints between them. Therefore, when creating a table, add constraints as follows:

SQL foreign key constraints can achieve cascading deletion and cascading update;

Oracle only supports cascade deletion.

Format of SQL cascading deletion and cascading update:
Create table A001 (id int primary key, name varchar (20 ))
Create table A002 (id int references A001 (ID) on delete cascade on update cascade, age tinyint)

Format of ORACLE cascading deletion:
Create table A001 (id int primay key, NAME VARCHAR2 (20 ))
Create table A002 (id int references A001 (ID) on delete cascade, age number (2, 0 ))