2 技術(shù)要點(diǎn) ORACLE系統(tǒng)表中，有一張視圖，記錄所有可以更新和不可以更新的視圖(和數(shù)據(jù)表)：User_Updateable_Columns 該視圖字段如下: Name Type Nullable Default Comments ----------- ------------ -------- ------- --------------- OWNER VARCHAR2(30) Table owner TABLE_NAME VARCHAR2(30) Table name COLUMN_NAME VARCHAR2(30) Column name UPDATABLE VARCHAR2(3) Y Is the column updatable? INSERTABLE VARCHAR2(3) Y Is the column insertable? DELETABLE VARCHAR2(3) Y Is the column deletable?
使用Select * From user_Updateable_Columns Where Table_name=Upper('YourViewname') 即可查詢(xún)視圖中哪些字段是答應(yīng)更新的
