join...
SQL> -----JOINS ---
SQL> ---ORACLE STND JOIN : EQUI JOIN , NON EQUI JOIN , OUTER JOIN , SELF JOIN
SQL> ---SQL 1999 STND JOIN : INNER JOIN , LEFT OUTER JOIN , RIGHT OUTER JOIN
SQL> --- FULL OUTER JOIN , CROSS JOIN
SQL> ---JOIN : WHERE CONDITION , NUMBER OF CONDITION : N-1
SQL> ---EUQI JOIN
SQL> SELECT E.ENAME,E.SAL,E.DEPTNO,D.DNAME,D.LOC FROM EMP E,DEPT D WHERE E.DEPTNO=
2 D.DEPTNO;
SQL> ---ORACLE STND JOIN : EQUI JOIN , NON EQUI JOIN , OUTER JOIN , SELF JOIN
SQL> ---SQL 1999 STND JOIN : INNER JOIN , LEFT OUTER JOIN , RIGHT OUTER JOIN
SQL> --- FULL OUTER JOIN , CROSS JOIN
SQL> ---JOIN : WHERE CONDITION , NUMBER OF CONDITION : N-1
SQL> ---EUQI JOIN
SQL> SELECT E.ENAME,E.SAL,E.DEPTNO,D.DNAME,D.LOC FROM EMP E,DEPT D WHERE E.DEPTNO=
2 D.DEPTNO;
Comments
Post a Comment