Interested to Buy Any Domain ? << Click Here >> for more details...
Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
- 1 Answers
- 4858 Views
- I also Faced
- E-Mail Answers
Answer / ramachandra
we are using primary key and foreign key database designer identify an entity
diffencee b/w primary key and foreign key
1.every table should have one primary key
but foreign key it doesnt any rule we keep more than one foreign key
2.primary key doesn't accept null values
3primary key is parent key
but foreign key is child key it depends only primary key table or column it doesn't allow more than primary key column attributes.
4.primary key doesn't accept duplicate values
but foreign key accepting duplicate values
| Is This Answer Correct ? | 3 Yes | 0 No |
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
3. Steps in UAT?
What are different types of transactions in ar? : oracle accounts receivable
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
How to clone the database using RMAN back
What is cardinality?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What command would you use to create a backup control file?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the difference between the SQL*Loader and IMPORT utilities?
please send me oracle pl/sql exp resume. and also faqs...
Oracle General 
