Answer / guest

foreign key reference as Primary key in another table

Answer / ramprakash

Foreign keys enforce referential integrity by completing an
association between two entities.

Answer / guest

It's a constrains assigned to a column or combination of
columns included in the definition of referential integrity
which would refer to a referenced key

Answer / sejal

A foreign key is a link or relationship between two tables
which ensures that the data stored in a data-
base is consistent.

Answer / kebiraj

A foreign key, also called a foreign keyword, in a database
table is a key from another table that refers to (or
targets) a specific key, usually the primary key , in the
table being used. A primary key can be targeted by multiple
foreign keys from other tables. But a primary key does not
necessarily have to be the target of any foreign keys.




by
kebiraj.s

How to define an external table with a text file?

0 Answers  

---

How to find the duplicate rows count from employees table in oracle?

0 Answers  

---

How to divide query output into groups in oracle?

0 Answers  

---

Explain the use of grant option in imp command.

0 Answers  

---

How to delete an existing row from a table in oracle?

0 Answers  

---

---

What is the difference between truncate & delete command?

0 Answers  

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers   Oracle,

---

Is oracle an operator?

0 Answers  

---

what is the difference between no rows returned and null returned?

2 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

What is flashback Query ? And Use ?

4 Answers   Thermotech,

---

How would you change old and new values in an insert, delete and update triggers?

0 Answers  

---