What we need importantly here is the Cascade delete, so I think this is enough.
On Sat, Apr 5, 2014 at 10:48 AM, Prasad Tissera <[email protected]> wrote: > Unlike MySql and H2, Oracle does not support ON UPDATE clause. But ON > UPDATE RESTRICT is the default behavior of Oracle. Since ON UPDATE > RESTRICT will be omitted in the oracle SQL scripts. > > example. > > H2/MySQL Script: > > ALTER TABLE IDN_APPMGT_CLIENT ADD CONSTRAINT APPLICATION_ID_CONSTRAINT > FOREIGN KEY (APP_ID) REFERENCES IDN_APPMGT_APP (ID) ON UPDATE RESTRICT ON > DELETE CASCADE; > > Oracle Equivalent: > > ALTER TABLE IDN_APPMGT_CLIENT ADD CONSTRAINT APPLICATION_ID_CONSTRAINT > FOREIGN KEY (APP_ID) REFERENCES IDN_APPMGT_APP (ID) ON DELETE CASCADE; > > > -- > Prasad Tissera > Software Engineer. > Mobile : +94777223444 > -- Suresh Attanayake Senior Software Engineer; WSO2 Inc. http://wso2.com/ Blog : http://sureshatt.blogspot.com/ Web : http://www.ssoarcade.com/ Facebook : https://www.facebook.com/IdentityWorld Twitter : https://twitter.com/sureshatt LinkedIn : http://lk.linkedin.com/in/sureshatt Mobile : +94755012060 Mobile : +016166171172
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
