Answer Posted / rama mohan reddy

ACTUALLY PRIOR 8i THERE ARE 4 TYPES OF JOINS ARE THERE THEY ARE
1. EQUI JOIN
2. NON EQUIJOIN
3. SELF JOIN
4. OUTER JOIN
A) LEFT OUTER JOIN
B) RIHT OUTER JOIN

BUT ANSI PROIDES NEW JOINS FROM 1999 THEY ARE
1. CROSS JOIN
2. NATURAL JOIN
3. USING CLAUSE
4. INNER JOIN //SAME AS EQUI JOIN PRIOR 1999
5. SELF JOIN //SAME AS SELF JOIN PRIOR 1999
6. RIHT OUTER JOIN
7. LEFT OUTER JOIN
8.FULL OUTER JOIN

How to drop a tablespace?

1055

---

Where are the settings stored for each instance in oracle?

1111

---

In oracle there is column command, how will you explain that?

1065

---

What is oracle rownum?

960

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2243

---

if you ctreate table identity

2380

---

What is blob datatype?

1134

---

What are the differences between char and varchar2 in oracle?

1181

---

How to insert a record into a table?

1076

---

What is user managed backup in Oracle?

1148

---

What are the various types of snapshots ?

1032

---

What happens if you use a wrong connect identifier?

1073

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2631

---

What is set verify off in oracle?

1108

---

What is a directory object?

1101

---