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 not equal to in oracle?

981

---

Write a syntax for update query in oracle?

1013

---

What happens in oracle commit?

1002

---

Will you be able to store pictures in the database?

1093

---

How to divide query output into groups in oracle?

977

---

What is clustered table in Oracle?

1170

---

How to use subqueries in the from clause in oracle?

1088

---

Explain an index?

1113

---

How to save query output to a local file?

1004

---

What types of joins are used in writing subqueries?

966

---

State the difference between a primary key and foreign key?

921

---

How to assign values to data fields in record variables?

1011

---

Explain how are indexes update?

1055

---

Write a trigger example in oracle?

1032

---

How to sort the query output in oracle?

1007

---