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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
