Linking with Foreign Keys

Posted on 16th Feb 2014 07:03 pm by admin

I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name varchar2(20) not null, Specialty varchar2(40) not null);

using :

alter table faculty_specialty modify (foreign key (I_Name) references faculty);

to:

Create table Faculty (I_Name varchar2(20) primary key);

The following error occurs:

SQL> alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name));
alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name))
*
ERROR at line 1:
ORA-02298: cannot validate (ORDB029.SYS_C0027281) - parent keys not found

I Know it's elementry but I can figure out why this is happening.....

Your Answer:

Login to answer

Other forums

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
this code is not working???? 
it says this error..  Warning: Division by zero in ..

the variables are correct, so why is th
  A WBS element with the name XXX already exists in version FREI_VERSION     
Hi.

When I am trying to insert WBS element in a project, error occurs:



 "A WBS eleme
what does this mean? += 
is anyone able to explain what this code is saying?

i had it written for me awhile back and n
"GROUP BY" in arrays 
Well i'm looking to do something i usually could do easily using COUNT and GROUP BY if it was a sql 
upload only text files 
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t