Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139046 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can a parameter be passed to a cursor?
What is a proxy object?
How to concatenate two text values in oracle?
What is logical backup in oracle?
What is a static data dictionary in oracle?
Give the various rollback segment states.
Why is oracle used?
How to create a single index for multiple columns?
How to use subqueries with the in operator using oracle?
How many categories of data types in oracle?
Differentiate between pre-select and pre-query?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
State the various uses of dbcc command?
How does Oracle guarantee data integrity of data changes?
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
