「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
Coding Changes the World
書式
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