Cacher is the code snippet organizer for pro developers

--view creation
create or replace view emp_dept as
select	e.empno, ename,ename
from 	emp e, dept d , salgrade s
where 	e.deptno = d.deptno
and 	s.job 	 = e.job
order by empno;

--Trigegr creation
create or replace trigger m_update_view
instead of update on emp_dept_view
begin
update emp set ename = :new.ename where empno = :new.empno;
end;