Answer Posted / nishi

Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.

Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2062

---

What are set operators?

1082

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2262

---

How to add a new column to an existing table in oracle?

1139

---

Explain what are the uses of rollback segment?

1015

---

various types of hints and their usage

2699

---

How will you identify oracle database software release?

1010

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2187

---

What is a private synonym?

1588

---

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

1134

---

How do I manually create a database in oracle?

1019

---

How do I manually uninstall oracle client?

1088

---

if you ctreate table identity

2374

---

Explain enable novalidate constraint.

1083

---

What are internal user account in oracle?

1008

---