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

What is analyze command used for?

1012

---

How to connect to oracle using service name instead of sid?

964

---

How to bring a tablespace offline?

1001

---

How to define default values for formal parameters?

985

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2656

---

How to convert times to characters in oracle?

978

---

How to execute a stored procedure in oracle?

1031

---

What is translate in oracle?

1051

---

What happens if the update subquery returns multiple rows?

1046

---

What happens to the current transaction if a ddl statement is executed?

952

---

What is an index associated with a constraint?

975

---

What is the difference between substr and instr?

980

---

How to use select statement to count the number of rows in oracle?

990

---

What are the parameters that we can pass through a stored procedure?

1000

---

How to create a testing table in oracle?

948

---