Oracle 12c New Feature On Delete Cascade

[@rajeshvasan2616]

Very nice explanation ❤

[@samishah001oraclable]

very nice demo. thanks bro

[@SivaAcademy]

Welcome

[@pankajkharade6936]

Excellent Sir 👍👍👍👍

[@SivaAcademy]

My pleasure 💐

[@devanaidu9406]

Very nice explanation sir,thank you sir

[@SivaAcademy]

You're most welcome

[@Parvej669]

Thank You sir for this wonderful video

[@SivaAcademy]

Welcome 🙏

[@etlqalabs5048]

Good explanation

[@SivaAcademy]

Thank you

[@SatyendraKumar-im5tu]

This feature is available in 11g as well .

[@swapniljoshi7082]

on delete Cascade was in 11g also , please correct me if i am wrong Sir

[@govindarajuluchevula3165]

sir make videos on performance tuning

[@therottenkiwis]

Hi Siva, Apart from Delete and Truncate, Is there any option to drop the parent table?

[@SivaAcademy]

Can you please elaborate your question, parent table means?

[@therottenkiwis]

@@SivaAcademy Here you're DELETE/TRUNCATE continent table using ON DELETE CASCADE. Can we DROP continent table?

[@therottenkiwis]

@@SivaAcademy Hi Siva, Asked about DROP TABLE CASCADE CONSTRAINTS;

[@SivaAcademy]

Ok, is it clear?

[@therottenkiwis]

@@SivaAcademy Yes. Thanks!

[@sivapalanisamy8989]

Is Oracle will support ON UPDATE CASCADE Constraint or not?

[@Ganeshay-09]

Areee sir awaj karoo badaoooo thodaa apkaa vdo me kyaa slow rhta aawaj apkaa.... Aise lagta apka headphones nai lagtee ap

[@vikram4755]

This is good and very dangerous at the same time. If anyone accidentally deletes from parent table and issues commit he is in trouble with no information to rollback from all child tables.

[@PriyankaKumari-ul7bv]

HI SIVA, on delete cascade is feture of 9i not 12c. Please correct me if i m wrong

[@SivaAcademy]

@Priyanka, "CASCADE clause for truncate table command" is introduced from 12.1 onwards ........ means, on delete cascade can be used with truncate command with additional keyword called "CASCADE"..... thanks for pointing out....May be the title is misleading.......let me modify the thumbnail image for more clarity....Thanks, Siva

[@amareshdas4034]

10g onwards it is there

[@Gaaaaaaa656]

code to deta bhai