Re: check constraints

samhou_at_my-deja.com wrote:
>
> Hi all DBA:
> Would Oracle allow one table's check constraints to refer to
> another table's column name, also would subquery be allowed in check
> constraint in any version of oracle?
> Foreign key would be the best way for the example below, but I am
> interested to know if check constraint is possible in this case!
> For example :
> create table dept(
> deptno number,
> name varchar2(100)
> );
>
> create table emp (
> empno number,
> name varchar2(100),
> deptno number constraint emp_pk_deptno
> check(exists(select * from emp where emp.deptno = dept.deptno))
> );

What you need is a foreign key constraint. Received on Fri Jan 26 2001 - 07:18:25 CST