Answer Posted / rakesh

Total Joins of 8 types::
table1: emp[ename,city]
table2: emp_sal[ename,salary]

1]self join
select e2.ename from emp e1, emp e2 where e1.city=e2.city
and e1.ename="Ram"

2]Natural Join
select ename,city,salary from emp natural join emp_sal

3]cross join
select ename,city,salary from emp cross join emp_sal

4]left outer join : all rows from left table
select e1.ename,city,salary
from emp e1,emp_sal e2
where (e1.ename=e2.ename(+))

5]right outer join : all rows from right table
select e1.ename,city,salary
from emp e1,emp_sal e2
where (e1.ename(+)=e2.ename)

6]full outer join : all rows from [left table+right table]
select e1.ename,city,salary
from emp e1,emp_sal e2
where (e1.ename=e2.ename(+))
UNION
select e1.ename,city,salary
from emp e1,emp_sal e2
where (e1.ename(+)=e2.ename)
OR CAN SAY:
select ename,city,salary
from emp e1 full outer join emp_sal e2
where e1.ename=e2.ename

7]Equi Join/simple join/inner join
select e1.ename,e2.salary
from emp e1, emp_sal e2
where e1.ename=e2.ename

8]Non Equi Join
select e1.ename,e2.salary
from emp e1, emp_sal e2
where e2.salary BETWEEN 1000 and 2000

What are a cluster and non-cluster index?

1065

---

What is system tablespace?

1153

---

What is a snapshot log?

1051

---

Can the query output be sorted by multiple columns in oracle?

1061

---

Can we commit inside a function in oracle?

1014

---

How to create tables for odbc connection testing?

1209

---

How to create a table index?

1230

---

Explain about your project and its relation to the current job position you are applying to?

1079

---

How to delete a column in an existing table in oracle?

1130

---

What are the system predefined user roles?

1100

---

How to set a transaction to be read only in oracle?

1140

---

What is the difference between postgresql and oracle?

1108

---

Can we connect to ORACLE db using Windows Authentication?

1308

---

Explain the use of inctype option in exp command.

1083

---

What do you mean by merge in oracle?

1030

---