Re: Help needed in using PRIM-FOREIGN table constraints
From: Aniruddha Kortikar <kortikar_at_mipos2.intel.com>
Date: 1 Jul 92 23:46:23 GMT
Message-ID: <12003_at_inews.intel.com>
Date: 1 Jul 92 23:46:23 GMT
Message-ID: <12003_at_inews.intel.com>
Oracle supports foreign key constraints ONLY in syntax. NOT at database level.
somebody from oracle would like to corroborate this.
Aniruddha Kortikar (kortikar_at_mipos2.intel.com)
In article <1992Jun30.193614.4278_at_verifone.com> sridhar_b1_at_verifone.com writes:
> <stuff deleted where sridhar has defined primary and foreign keys ..>
>But I am able to add an emp row with a dept_no which does not exist in any
>row in the table dept. Also, I am able to delete a row from the table dept
>whose dept_no is used by a row in the emp table.
>Can anyone help please ?
>My Email : SRIDHAR_B1_at_blrv1.verifone.com
Received on Thu Jul 02 1992 - 01:46:23 CEST