what is the difference between primary key & foreign key?

Answer Posted / mithun

primary key is the unique value,but its not nul values..
this kry is avoided dublicate values

foreign key is always references the primary key.

Is This Answer Correct ?    21 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is raw datatype in oracle?

598


What are the different pseudo commands? Explain in general?

556


What is user managed backup in Oracle?

622


Explain an exception?

577


Explain implicit cursor.

569






If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1665


How to generate query output in html format?

577


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1487


How to export your own schema?

586


Is there any function in oracle similar like group_concat of mysql?

554


What is the difference between Delete, Truncate and Drop in Oracle?

615


How to create a temporary table in oracle?

702


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1871


Explain overloading. Can functions be overloaded?

583


Why is oracle used?

563