ORACLE [Oracle] WITH 구문 예제

WITH ALIAS명 AS ( SUB쿼리 )

SELECT 컬럼명 FROM ALIAS명;

WITH AA AS

 (SELECT ROWNUM, 'TEST1', SYSDATE

    FROM DUAL

  UNION ALL

  SELECT ROWNUM, 'TEST2', SYSDATE

    FROM DUAL

  UNION ALL

  SELECT ROWNUM, 'TEST3', SYSDATE FROM DUAL)

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

SELECT * FROM AA;

WITH ALIAS명_1 AS ( SUB쿼리 ),

          ALIAS명_2 AS ( SUB쿼리 )

SELECT 컬럼명 FROM ALIAS명 where 조인조건;

WITH AA AS
 (SELECT ROWNUM AS SEQ, 'TEST1' AS NAME, SYSDATE
    FROM DUAL
  UNION ALL
  SELECT ROWNUM AS SEQ, 'TEST2' AS NAME, SYSDATE
    FROM DUAL
  UNION ALL
  SELECT ROWNUM AS SEQ, 'TEST3' AS NAME, SYSDATE FROM DUAL),

 BB AS
 (SELECT ROWNUM AS SEQ, 'TEST1' AS NAME, SYSDATE
    FROM DUAL
  UNION ALL
  SELECT ROWNUM AS SEQ, 'TEST2' AS NAME, SYSDATE
    FROM DUAL
  UNION ALL
  SELECT ROWNUM AS SEQ, 'TEST3' AS NAME, SYSDATE FROM DUAL)
 
SELECT * FROM AA, BB WHERE AA.NAME=BB.NAME