Answer Posted / orawhiz

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to be
performed on dependent data as a result of any action on
referenced data.

What is a package ? What are the advantages of package ?

1071

---

how to join query for one source type is oracle another source type is sql server ?

2406

---

What is the relation of a user account and a schema in oracle?

1067

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2337

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2944

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2117

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2082

---

How to call a stored function with parameters?

1010

---

What is an oracle user role?

967

---

How do I reset a sequence in oracle?

1078

---

What is the difference between postgresql and oracle?

1021

---

How to define an external table with a text file?

1046

---

Why is oracle used?

922

---

What is user managed backup in Oracle?

1120

---

Is there a function to split a string in plsql?

1039

---