Oracle教程 2023-02-27

Oracle 视图 ALL_UPDATABLE_COLUMNS 官方解释，作用，如何使用详细说明

Oracle视图ALL_UPDATABLE_COLUMNS用于列出所有可以更新的列或字段。使用方法如下：

1、先查询需要更新的表的所有可更新的列：SELECT * FROM all_updatable_columns WHERE table_name = ‘你的表名’;

2、然后在SELECT * FROM 你的表名 WHERE 条件 …… SET 时，将你要添加（或者更新）的字段值添加进去即可，比如：

UPDATE 表名 SET 可更新列1= ‘新值’, 可更新列2=’新值’ WHERE ……

ALL_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the current user, subject to appropriate privileges.

Related Views

DBA_UPDATABLE_COLUMNS describes all columns in a join view that are updatable by the database administrator, subject to appropriate privileges.
USER_UPDATABLE_COLUMNS describes all columns owned by the current user that are in a join view and are updatable by the current user, subject to appropriate privileges.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the table
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Column name
`UPDATABLE`	`VARCHAR2(3)`		Indicates whether the column is updatable (`YES`) or not (`NO`)
`INSERTABLE`	`VARCHAR2(3)`		Indicates whether the column is insertable (`YES`) or not (`NO`)
`DELETABLE`	`VARCHAR2(3)`		Indicates whether the column is deletable (`YES`) or not (`NO`)