79239324

Date: 2024-11-30 10:34:14
Score: 1
Natty:
Report link

Alternatively, if you don't mind whether those key values exist NOW but just want to add the constraint for future entries, you can turn off validation on your alter table statement by adding NOVALIDATE at the end:

ALTER TABLE table2
ADD FOREIGN KEY (EMPNO)
REFERENCES table1(EMPNO) 
NOVALIDATE;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: crilopez