This will display the all matching records and the non-matching records from both tables. Ex: SQL> select empno,ename,job,dname...
Oracle SQL Right Outer Join example
This will display the all matching records and the records which are in right hand side table those that are not in left hand side table. E...
Oracle SQL Left Outer Join example
OUTER JOIN Outer join gives the non-matching records along with matching records. LEFT OUTER JOIN Left outer join produces ...
Cross Join | Oracle SQL Cross join example
CROSS JOIN This will gives the cross product. Ex: SQL> select empno,ename,job,dname,loc from emp cross join dept; ...
Natural Join | Oracle SQL Nature join example
NATURAL JOIN Natural join compares all the common columns. Ex: SQL> select empno,ename,job,dname,loc from emp natural jo...
Self Join | Oracle SQL Self Join example
SELF JOIN Joining the table itself is called self join. Ex: SQL> select e1.empno,e2.ename,e1.job,e2.deptno from emp e1,...
Subscribe to:
Posts (Atom)