what is the difference between primary key & foreign key?
Answer Posted / altaf ali
primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.
A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
How to pass a parameter to a cursor in oracle?
What is ADDM Advisor in Oracle?
What is dual table oracle?
How to check the oracle tns settings?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Can you create a synonym without having a table?
What is instant client oracle?
How to change user password in oracle?
What are a query and state the different types of queries and their uses?
How do I know if oracle client is installed on windows?
What privilege is needed for a user to delete rows from tables in another schema?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are internal user account in oracle?
How to view the data files in the current database?
What is tns name?