what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.

Answer Posted / cm

example :

primary key table: emp ( ENO, ename, address)
here eno is primary key

foreign key: table hari( ENO, phone, salary)
here same eno from hari table is used to get the values
from emp.

Is This Answer Correct ?    32 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a trigger and what are its types in oracle?

530


How to return top 5 rows in oracle?

537


What happens if recursive calls get out of control?

539


Explain about functional dependency and its relation with table design?

545


What is tns entry?

615






What is a oracle database?

597


Why oracle is used?

573


What is rich query?

534


Give the different types of rollback segments.

569


State and explain about oracle instance?

536


Explain database link?

651


What is oracle rowcount?

564


Can we convert a date to char in oracle and if so, what would be the syntax?

546


How to specify default values in insert statement using oracle?

551


How to install oracle odbc drivers?

616