WITH 절

WITH EXAMPLE AS
(
 SELECT 'WITH절' AS STR1
 FROM DUAL
)

SELECT * FROM EXAMPLE

✔️간단한 with절

with 절 안의 내용을 EXAMPLE이라는것으로 명칭을 짓는다.