Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
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 |
8. Supporting AP, AR and GL?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Describe the P2P cycle ?
statement string in open is null or 0 length ORA-40735
What is database schema?
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
how to create an user in oracle 10g.please give me an example..
how can we send a concurrent program output to the clients through mail or fax give me example.
What is chargeback invoice? How do we create it? : oracle accounts receivable