[DB] Oracle view

取得VIEW 內容

SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME =’WLKN1_VIEW2′

 

更新VIEW

CREATE OR REPLACE VIEW WLKN1_VIEW2 as
select …