Interested to Buy Any Domain ? << Click Here >> for more details...
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?
- 4 Answers
- 10183 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj byregowda
Primary key- A column (or columns)in a table which makes every row in table unique. eg - EMPLOYEE table, EMPID is column which is unique.
Foreign Key - A column (or columns) in table Whose value References to primary key of another table OR ( A column which derives its value from another tables primary key.)
eg - EMP table EMPID is PK and DEPTNO is FK.
DEPT table DEPTID is pk.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What is the importance of batch source set up in ar? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
as a technical developer in oracle applications which type errors feced in your experience sofar
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
can we use lexical perameter in oracle plsql if yes how
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What are different types of transactions in ar? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
8. Supporting AP, AR and GL?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
