Do you know how to join two table?
Submitted by: AdministratorThere are two types of join inner join and outer join.
(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;
(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables
Submitted by: Administrator
(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;
(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables
Submitted by: Administrator
Read Online Database Management Job Interview Questions And Answers
Top Database Management Questions
| ☺ | What is ORACLE CLINICAL? |
| ☺ | What is the difference between oracle CPU and PSU? |
| ☺ | Explain What are the uses of Oracle clinical? |
| ☺ | What is the difference between inline query and corelated subquery? |
| ☺ | How to store space between two strings in database i.e |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
