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

How to create a new oracle data file?

991

---

How to export several tables together?

1008

---

What is logical backup in oracle?

983

---

types of indexes and the rationale behind choosing a particular index for a situation.

2466

---

Differentiate between pre-select and pre-query?

1066

---

What is the difference between a hot backup and a cold backup in oracle?

973

---

How would you begin to troubleshoot an ORA-3113 error?

2045

---

What happens if you set the sga too low in oracle?

1079

---

How many types of segments in Oracle?

1031

---

What are the logical operations?

1083

---

When system tablespace is created?

989

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2523

---

When do you get a .pll extension in oracle? Explain its importance

1002

---

How can I see all tables in oracle?

971

---

How does Oracle guarantee data integrity of data changes?

2354

---