Answer Posted / sripathi venkata ramesh

I am Sripathi Venkata Ramesh from Gudivada

Answer is below

Joins

a) Inner join or default join or Equi Join:
It selects all the matching aswellas non matching records
from both the tables.

b) Outer join: It selects all the matching
aswellas non matching records from both the tables
depending upon the join type.

1) Left outer join:
It selects all the records from the left table but only the
matching records from the right table.

2) Right outer join: It
selects all the records from the right table but only the
matching records from the left table.

3) Full outer join:
It’s a union of left and right outer join.

c) Cross join or Cartesian join: Every row
in the first table joins with every row in the second
table. It does not have any condition. It is also called as
a Cartesian join.

d) Self join: Joining a table by itself is
called Self join. Here we have to use alias table.

How to define a record variable to store a table row?

1056

---

how do u setup a replication site?

1980

---

How to convert characters to numbers in oracle?

1063

---

What is ordinary table in oracle?

1151

---

How to display row numbers with the records?

1074

---

How many memory layers are in the oracle shared pool?

1177

---

What is oracle thin client?

1021

---

How do I recompile a procedure in oracle?

961

---

Calculate difference between 2 date / times in oracle sql?

1040

---

How to shutdown your 10g xe server from command line?

1084

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4358

---

How to start instance with a minimal initialization parameter file?

1036

---

Explain how you would restore a database using RMAN to Point in Time?

2141

---

How to start your 10g xe server from command line?

1069

---

How to use "for" statements in oracle?

1072

---