Re: check constraints

one way to find this out would be to try it. none of my check constraints reference any oracle objects other than the column names in the table.

HTH <samhou_at_my-deja.com> wrote in message news:94qtgo$rca$1_at_nnrp1.deja.com...
> 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))
> );
>
>
>
> Thanks
> Sam Hou
>
>
> Sent via Deja.com
> http://www.deja.com/
>
Received on Fri Jan 26 2001 - 08:18:17 CST