toad를 통한 Oracle 쿼리 실행

toad로 개발툴을 바꾼뒤 기존 테이블을 건드리지 않고 결과를 도출해보기 위해 실행한 소스 

WITH PERSON AS (

                SELECT 'A1' AS ID, '삼각' AS NAME, '남' AS SEX FROM DUAL

                UNION ALL SELECT 'A2' AS ID, '사각' AS NAME, '여' AS SEX FROM DUAL

                UNION ALL SELECT 'A3' AS ID, '오각' AS NAME, '남' AS SEX FROM DUAL

                ),

     GRADE AS (

                 SELECT 'A1' AS ID, 'LANG' AS SUB_ID, '50' AS SUB_GRD FROM DUAL

                UNION ALL SELECT 'A2' AS ID, 'MUS' AS SUB_ID, '20' AS SUB_GRD FROM DUAL

                UNION ALL SELECT 'A1' AS ID, 'MATH' AS SUB_ID, '90' AS SUB_GRD FROM DUAL

                UNION ALL SELECT 'A3' AS ID, 'LIM' AS SUB_ID, '100' AS SUB_GRD FROM DUAL

                ),

     SUBJECT AS (

                 SELECT 'LANG' AS SUB_CD, '국어' AS SUB_NM FROM DUAL

                 UNION ALL SELECT 'MATH' AS SUB_CD, '수학' AS SUB_NM FROM DUAL

                 UNION ALL SELECT 'ENG' AS SUB_CD, '영어' AS SUB_NM FROM DUAL

                 UNION ALL SELECT 'MUS' AS SUB_CD, '음악' AS SUB_NM FROM DUAL

                 UNION ALL SELECT 'PHY' AS SUB_CD, '체육' AS SUB_NM FROM DUAL

                )

SELECT P.*, G.*

   FROM  PERSON P

INNER JOIN  GRADE G ON P.ID = G.ID