Consider the following code
create or replace view crs_offerings as select o.course as course_code, c.description, o.begindate from offerings o join courses c on (o.course = c.code); The CRS_OFFERINGS view is based on a join of two tables: OFFERINGS and COURSES.
You can perform some data manipulation via this view, as long as the data manipulation can be translated into corresponding actions against the two underlying base tables.
CRS_OFFERINGS is an example of an updatable join view.
The following code demonstrates testing some DML commands against this view.
delete from crs_offerings where course_code = 'ERM'; insert into crs_offerings (course_code, begindate) values ('JSON' , trunc(sysdate));
You may get the following error when update an updatable join view: