what is the difference between primary key & foreign key?

Answer Posted / guest

Primary key is unique
primary key is not NULL and

foreign key is NULL
foreign key reference as Primary key in another table

Is This Answer Correct ?    250 Yes 62 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1974


Can we protect our pl/sql source code?

578


Can you tell me how to add new column in existing views?how?How is possible?

938


various types of hints and their usage

2131


What privilege is needed for a user to query tables in another schema?

508






How to drop an index in oracle?

609


How can we find out the current date and time in oracle?

641


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1207


How to write a query with an inner join in oracle?

564


Calculate difference between 2 date / times in oracle sql?

572


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1584


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

612


What is the quickest way to export a table to a flat file?

572


 What are the oracle DML commands possible through an update strategy?

582


How to divide query output into groups in oracle?

563