Inserting into Oracle Views and Using

Sometimes you need to update or insert into a view. But say your view has multiple tables like the outemp view: create or replace view outemp as select EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,dname from emp e ,dept d where d.deptno = e.deptno

Read More - Register for Free Membership