DEVFYI - Developer Resource - FYI

Can a view be updated/inserted/deleted? If Yes under what conditions ?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

585. Can a view be updated/inserted/deleted? If Yes under what conditions ?

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

(Continued on next question...)

Other Interview Questions