Answer Posted / orawhiz

If a foreign key reference a parent key of the same table is
called self-referential integrity constraint

How do I use os authentication with weblogic jdriver for oracle and connection pools?

994

---

Explain cascading triggers.

1011

---

What is the difference between hot backup and cold backup in oracle?

949

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1982

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1948

---

What is the difference between I and G in Oracle?

1010

---

Can we save images in a database and if yes, how?

996

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2128

---

How to define an oracle cursor variable?

969

---

How can we find out the current date and time in oracle?

1033

---

How can we find out the duplicate values in an oracle table?

992

---

What is bulk collect in oracle?

952

---

What is partitioned table in Oracle?

1100

---

How to get last row id?

935

---

How to view the data files in the current database?

1037

---