■예 1_2_1  || Cartesian Join의 SQL적용예
SELECT   I.SABUN, I.JOIN_DAY, E.RECT_REG_NO
FROM    INSA I, INSA_EMP_PJT E
ORDER BY  E.RECT_REG_NO DESC;

■예 1_2_2 || Dual 테이블
SELECT * FROM DUAL;

■예 1_2_3  ||  Dual 테이블 활용 1
SELECT '20090101' AS SABUN, '이호상' AS NAME FROM DUAL
UNION
SELECT '20090102' AS SABUN, '홍길동' AS NAME FROM DUAL;

■예 1_2_4  ||  Dual 테이블 활용 2
SELECT GREATEST('1996','1222') FROM DUAL;
SELECT LEAST('1996','1222') FROM DUAL;
SELECT INSTR('CORPORATE FLOOR','OR',3,2) "INSTRING"  FROM DUAL;
SELECT 'CHARACTER STRING IN QUOTES'||'AAA'||'AAA' RESULT FROM DUAL;

■예 1_2_5  || COPY_T 테이블 생성
____CREATE TABLE____ COPY_T
AS
SELECT ROWNUM AS COL_1, TO_CHAR(ROWNUM,'009') AS COL_2
FROM CMM_CODE_DETAIL
WHERE ROWNUM < 101;

■예 1_2_6  || Cartesian Join의 SQL적용예
SELECT DECODE(COL_1,1,SABUN,'합계')AS SABUN
  ,DECODE(COL_1,1,NAME,'합계') AS NAME
         ,COUNT(DECODE(COL_1,1,NAME,'합계')) AS TOTAL
FROM  INSA T1, COPY_T T2
WHERE  T1.JOIN_GBN_CODE = 'RGL' --정직
   AND  T2.COL_1 < 3
GROUP BY DECODE(COL_1,1,SABUN,'합계')
      ,DECODE(COL_1,1,NAME,'합계')
ORDER BY SABUN;

■예 1_2_7  || Cartesian Join의 SQL적용예
SELECT *
FROM (
   SELECT '20090101' AS SABUN, '이호상' AS NAME FROM DUAL
         UNION
         SELECT '20090102' AS SABUN, '홍길동' AS NAME FROM DUAL
        ) T1,
        (
          SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL
         UNION
         SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL
        ) T2;

■예 1_2_8  || 카티젼 조인이 아닌 사번으로 조인된 실행쿼리
SELECT *
FROM (
          SELECT '20090101' AS SABUN, '이호상' AS NAME FROM DUAL
          UNION
          SELECT '20090102' AS SABUN, '홍길동' AS NAME FROM DUAL
        ) T1,
        (
          SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL
          UNION
          SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL
        ) T2
WHERE T1.SABUN = T2.SABUN;

■예 1_2_9  || 3개의 테이블로 조인된 실행쿼리
SELECT DECODE(NO,'02',T1.SABUN,'합계')
  ,DECODE(NO,'02',T1.NAME,'-')
         ,DECODE(NO,'02',T2.GUBUN,'-')
         ,COUNT(T2.GUBUN)
FROM (
          SELECT '20090101' AS SABUN, '이호상' AS NAME FROM DUAL
          UNION
          SELECT '20090102' AS SABUN, '홍길동' AS NAME FROM DUAL
        ) T1,
        (
          SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL
          UNION
          SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL
        ) T2,
        (
          SELECT '01' AS NO FROM DUAL
          UNION
          SELECT '02' AS NO FROM DUAL
        ) T3
WHERE T1.SABUN = T2.SABUN
GROUP BY DECODE(NO,'02',T1.SABUN,'합계')
             ,DECODE(NO,'02',T1.NAME,'-')
             ,DECODE(NO,'02',T2.GUBUN,'-')