   .       (  ),   (  )  - .       ,      (        ,   ).  ,    INSTEAD OF            ,     .
,   Oracle Forms,     (pre-join)    ,             post-query-  .      ,      "ON-" ,      Oracle Forms.    INSTEAD OF    ,     , '   INSERT, DELETE  UPDATE   .
:
   ,     ,     (LOCK), ,      ,   -   ,      ,  . ,     Oracle Forms     .      ON LOCK           .    ,     ,        ,  -   .
 
     ,         INSTEAD OF,   -,       :
CREATE VIEW totsal
( dname
, sal_amount
) AS SELECT d.dname
, SOM(e.sal) FROM emp  e
, dept d
WHERE d.deptno = e.deptno GROUP BY d.dname;
3.    OracleS	31