what is the difference between primary key & foreign key?
Answer Posted / deepa
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
What is a data dictionary and how can it be created?
How to open and close an explicit cursor in oracle?
What is the difference between substr & instr functions?
What is oracle update statement with inner join ?
Why does Oracle not permit the use of PCTUSED with indexes?
What is oracle database client?
How to define a record variable to store a table row?
What is oracle latest version?
What are oracle functions?
How to retrieve data from an cursor to a record?
How to use "startup" command to start default instance?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to convert csv to table in oracle?
What privilege is needed for a user to connect to oracle server?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.