Posted by: techGuy June 12, 2008
ORACLE Constraints help
Login in to Rate this Post:     0       ?        

create table B

 {

  id number,

name varchar2(20 Byte),

ship varchar2(20byte),

CONSTRAINT  "CK_ID" CHECK(id in(select id from A)) enable

}

I'm not sure if that works, but u can try that.

Read Full Discussion Thread for this article