「Oracle」WITH文を使うサンプル

2021年8月4日

書式
WITH 別名 AS (SELECT文)
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
WITH
TTT AS (SELECT * FROM INFO_TBL)
SELECT
CFT.*
FROM
USER_TBL CFT
INNER JOIN TTT KE ON CFT.UNO = KE.UNO
INNER JOIN TTT KF ON CFT.UNO = KF.UNO
;
WITH TTT AS (SELECT * FROM INFO_TBL) SELECT CFT.* FROM USER_TBL CFT INNER JOIN TTT KE ON CFT.UNO = KE.UNO INNER JOIN TTT KF ON CFT.UNO = KF.UNO ;
WITH
    TTT AS (SELECT * FROM INFO_TBL)
SELECT
    CFT.*
FROM
    USER_TBL CFT
    INNER JOIN TTT KE ON CFT.UNO = KE.UNO
    INNER JOIN TTT KF ON CFT.UNO = KF.UNO
;

 

Oracle

Posted by arkgame