Oracle View的 WITH READ ONLY 參數有什麼用途?
限制此視圖只能select,不能進行DML(update,delete,insert)操作,可以保護源表的數據不被改動。
CREATE VIEW XXXXX_V AS select XXX,XXX1,XX2 From a where xxx WITH READ ONLY
限制此視圖只能select,不能進行DML(update,delete,insert)操作,可以保護源表的數據不被改動。
CREATE VIEW XXXXX_V AS select XXX,XXX1,XX2 From a where xxx WITH READ ONLY