「Oracle」ビュー(view)テーブルを作成するサンプル

2021年8月19日

書式
CREATE OR REPLACE VIEW ｛ビュー名前｝ AS　｛SELECT構文｝
使用例

CREATE

OR REPLACE VIEW TT_VIEW AS

SELECT

, UID

, USER_ADDR

FROM

AA_TBL A

LEFT JOIN BB_TBL B

ON A.NO = B.NO

LEFT JOIN CC_TBL C

ON A.UID = C.UID

ORDER BY

CREATE OR REPLACE VIEW TT_VIEW AS SELECT NO , UID , USER_ADDR FROM AA_TBL A LEFT JOIN BB_TBL B ON A.NO = B.NO LEFT JOIN CC_TBL C ON A.UID = C.UID ORDER BY NO

CREATE 
OR REPLACE VIEW TT_VIEW AS 
SELECT
  NO
  , UID
  , USER_ADDR 
FROM
  AA_TBL A 
  LEFT JOIN BB_TBL B 
    ON A.NO = B.NO 
  LEFT JOIN CC_TBL C 
    ON A.UID = C.UID 
ORDER BY
  NO

Oracle

Posted by arkgame

関連投稿: