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.

How do I escape a reserved word in oracle?

1140

---

How to run create database statement?

981

---

What privilege is needed for a user to query tables in another schema?

929

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1838

---

What is a system tablespace?

1011

---

How to convert csv to table in oracle?

930

---

How to change system global area (sga) in oracle?

965

---

Can we insert data in view oracle?

973

---

How to call a stored function in oracle?

959

---

What is raw datatype in oracle?

1063

---

How to create additional tablespaces for an new database?

977

---

What are the differences between number and binary_float in oracle?

1063

---

Why does oracle 9i treat an empty string as null?

988

---

How to write a query with a left outer join in oracle?

1007

---

What are the attributes of cursor?

995

---