In oracle 12c TRUNCATE TABLE CASCADE will truncate its child tables, if ON DELETE CASCADE relationship is present on child table.

Create one parent and child table with some data

You can check the child table details using : Get child table details

Truncate the parent table with cascade option:

We can see the child table has been truncated, though we just truncated only parent table.

Leave a Reply