Consider the following statements SQL CREATE TABLE branch001

Consider the following statements:

SQL> CREATE TABLE branch_001

( id number(5),

name varchar2(25),

location varchar2(20),

credit_limit number(9,2));

SQL> CREATE TABLE branch_002 AS SELECT * FROM branch_001 ;

SQL> CREATE TABLE branch_003 AS SELECT * FROM branch_001 ;

SQL> CREATE TABLE branch_004 AS SELECT * FROM branch_001 ;

SQL> CREATE VIEW broward AS

SELECT * FROM branch_001

UNION

SELECT * FROM branch_002

UNION

SELECT * FROM branch_003

UNION

SELECT * FROM branch_004;

Is it possible to perform DML operations on a VIEW ?

Solution

Yes, it is possible to perform DML operations on VIEW.

DML is used to retrieve, store, delete, insert and update data in the database

View is a virtual table. A view contains rows and columns so we can insert, update and delete and select the view.

If data is accessed and entered through a view, the database management system can automatically check the data to ensure that it meets specified integrity constraints.