Write a query for creating an Updateable view.

[jhbalaji]

PROGRAM CODE:
create view vw_client as
select client_no, name, address1, bal_due
from client_master;

insert into vw_client values('C00110','Robert','40/2, Vinayak Nagar', 1000);

update vw_client set bal_due=12000 where client_no='C00110';

delete vw_client where client_no='C00110';

OUTPUT:
[attachment=14367]