Answer Posted / a g srikanth

Amongh outer joins there are three types
1)Left outer join
2)Right outer join
3)Full outer join

Left outer join: In this join the (+) sign is given with
the table to the left of the equal to sign

i.e emp.deptid(+)=dept.deptid

here we are seeking blank columns from the left table i.e.
emp if no matching columns are there in the right table i.e
dept

Right outer join: In this join the (+) sign is given with
the table to the right of the equal to sign

i.e emp.deptid=dept.deptid (+)

here we are seeking blank columns from the right table i.e.
dept if no matching columns are there in the left table i.e
emp.

NOTE:scott.emp and dept values do not give any rows for
right outer joins, for right outer join, assume that there
is some employee in emp table who is not yet assigned any
department number.

Full outer join:in this type of join we force blanks if any
from both the tables

SELECT *
FROM emp
FULL OUTER JOIN dept
ON emp.Deptid = dept.Deptid

What is literal?

1010

---

What happens if recursive calls get out of control?

1083

---

How to Truncate Table in Oracle

1159

---

What is private procedure oracle?

1013

---

How to create a table in a specific tablespace?

977

---

Explain the difference between a procedure and a function?

1175

---

Can you tell me how to add new column in existing views?how?How is possible?

1450

---

What is an oracle function?

1170

---

When do I need to use a semicolon vs a slash in oracle sql?

1090

---

What is a subquery in oracle?

1112

---

How to write numeric literals in oracle?

1187

---

How to pass a cursor variable to a procedure?

1112

---

What is the difference between postgresql and oracle?

1052

---

How to create a table index in oracle?

1134

---

What is the use of oracle?

1030

---