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

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

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