what is the difference between primary key & foreign key?

Answer Posted / praneeth

primary key helps in uniquely identifying the records in a table
a foreign key is a field that points to the primary key of another table which links one table to another table

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define an anonymous block?

616


How to retrieve data from an cursor to a record?

559


Can we protect our pl/sql source code?

572


What is BBED in Oracle?

684


What are the differences between primary key and unique key?

509






How do we create privileges in oracle?

586


How to list all indexes in your schema?

578


How to build data dictionary view an new database?

530


What are the ansi data types supported in oracle?

518


How to create an oracle database manually?

568


How to execute the package in oracle?

570


What is translate in oracle?

615


What is an Oracle index?

1175


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1776


how can we store any pdf file in oracle

1638