8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for TRUNCATE TABLE ... CASCADE in Oracle Database 12c Release 1 (12.1)


satish.kkd@gmail.com said...

Last Delete statement missing CASCADE option, please add.

Tim... said...

Hi.

As explained earlier in the article, the CASCADE keyword is optional. If the constraint is defined with the cascade option, the delete will always cascade. It's left out here intentionally to show that...

Cheers

Tim...

Anonymous said...

In the first line, there's typo in the spelling - heirarchy

Tim... said...

Hi.

Fixed. Thanks. )

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.