updating tables from views

Hi,
I have created a view:

Create View sturec as (
Select sid,slname,grade,assessnumber
from student,enrolment,assessment
where student.sid=enrolment.sid
and enrollment.cid=assessment.cid);

Now when i insert a record into this view using SQL:

insert into sturec values ....

or using Oracle Forms 6.0,

how can i effect the inserts into the base tables from the views (after authentication and validation ofcourse).

Kind Regards,
Girish Received on Mon Sep 17 2001 - 10:40:41 CEST