Answer Posted / sangeetha meda

1. Self Join
Self join is a query in which a table is Joined to itself.

Self joins are used to compare the values in a column to
the other values in the same column in the same table.

2.Equi Join or Inner join
Equi join is a join in which the rows are retrieved the
equality of the relation ship between columns in the tables.

Select only those rows that have values in common in the
columns specified in the ON clause.

3.Non Equi Join or Outer Join

Left Outer Join:

Retrieves the matching records in both the table and non
matching records in the first or left table.

Right Outer Join

retrieves the matching records in both the table and non
matching records in the second or the right table.

Full Outer Join

Retrieves all the records (means matching and non matching
records in both the tables).

Which command is used to call a stored procedure?

987

---

how can we destroy the cookie? : Sql dba

993

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1027

---

How to install oracle sql developer?

1020

---

What is sqlcontext?

1059

---

Is primary key always clustered index?

993

---

what is a join? : Sql dba

1008

---

What does subquery mean in sql?

1034

---

Why is nosql good?

1006

---

what is subquery? : Sql dba

1109

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1568

---

What is acid property in a database?

1016

---

Is primary key clustered or nonclustered?

991

---

Which software is used for pl sql programming?

968

---

Explain exception handling in pl/sql?

1019

---