如何在Oracle中允许更新视图的结果? [英] How to permit update of a view's results in Oracle?

问题描述

我了解数据库视图是只读的，或者默认情况下至少是只读的.

I understand that database views are read-only, or at least read-only by default.

是否可以启用由oracle视图带来的数据更改?

Is it possible to enable the change of data brought by an oracle view?

重述::如果我仅查看一个表，只是为了隐藏一些列，对数据的更改会在表上更新吗?

Rephrasing: If I make a view of just one table, just to hide some columns, will changes to this data be updated on the table?

推荐答案

是的，可以修改Oracle视图.

Yes, Oracle views can be modified.

但是，有一些限制:

• 包含集合运算符，集合，GROUP的视图BY，DISTINCT和联接(通常)不可修改
• 仅一些联接视图是可修改的

• views that contain set operators, aggregates, GROUP BY, DISTINCT and joins (in general) are not modifiable
• only some join views are modifiable

这篇关于如何在Oracle中允许更新视图的结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！