How to allow update of viewing results in Oracle?

Question

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

Is it possible to include a change in the data obtained as an oracle?

Paraphrasing: If I scan only one table, just to hide some columns, will the changes in this data be updated in the table?

0

lamcro Apr 18 '09 at 17:27

3 answers

andri · Answer 1 · 2009-04-18T17:33:35+0000

Yes, Oracle views are subject to change.

However, there are some limitations:

cagcowboy · Answer 2 · 2009-04-18T17:30:14+0000

, Oracle ... , , DISTINCT GROUP BY. , , UPDATE VIEW.

, ...

GRANT UPDATE ON your_view_name TO your_user;

UPDATE?

Ian carpenter · Answer 3 · 2009-04-18T21:30:05+0000

. , , .

, "" Oracle.

Additional information can also be found in the sql Create View command.

Hope this helps

Hi