| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help on Data Integrity Constraints
Adding more columns, won't it affect the performance.
Can foreign key constraint be created something like below instead of adding new columns?
Constraint constraint1 FOREIGN KEY ('AISTATUS',Status) REFERENCES
Master(Type,Code),
Constraint constraint1 FOREIGN KEY ('ROLE',Designation) REFERENCES
Master(Type,Code),
Constraint constraint1 FOREIGN KEY ('SEX',Gender) REFERENCES
Master(Type,Code)
I am getting ORA-00904- invalid identifier error.
Can a foreign key constraint be created with a fixed value and a table column referencing another table primary key that has two fields? Received on Tue May 03 2005 - 16:52:26 CDT
 |
 |