Cascade | Varinder Sandhu

Oracle – PL-SQL – Foreign key on delete cascade

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

ON DELETE CASCADE: When a referenced parent table row is removed the entire child are removed automatically. Example: — Create a Table as mytable1 having the PRIMARY KEY CREATE TABLE MYTABLE1 ( ID INTEGER PRIMARY KEY, EMP_NAME VARCHAR2(10) ); — Create a Table as mytable2 having the FOREIGN KEY CREATE

» Read more

Cascade, Foreign key, Oracle

Oracle – Drop User Cascade

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

If you have user that owns objects and you want to drop the user then you have to use the Cascade keyword with your drop statement/command. The Oracle DROP USER CASCADE command drops a user and all owned objects. Without using DROP USER CASCADE you cannot delete the user that

» Read more

Cascade, Oracle