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

How to name query output columns in oracle?

692


Will you be able to store pictures in the database?explain.

538


How to store pictures on to the database?

532


What happens if variable names collide with table/column names?

584


What are triggers in oracle?

563






What is dual table oracle?

527


How to rename a tablespace in oracle?

621


What is Redo Log Buffer in Oracle?

634


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1775


What are the predefined tablespaces in a database?

556


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1695


Explain the use of rows option in imp command.

604


What is a dead lock in oracle?

598


What is a sub query? What are its various types?

588


How to drop a tablespace?

574