ora-01733:virtual column not allowed here error
864933May 27 2011 — edited May 27 2011i created a view on emp table by below syntax:
create or replace view my_view as (select empno, ename, job, mgr, hiredate,
decode(ename, user,sal, 'KING', sal,0) as sal,
decode(ename, user,comm, 'KING', sal,0) as comm,
deptno from emp);
my view is created but when i update this view its give me ORA-01733:virtual column not allowed here error
can u tell my y this is giving error, but the main thing is that my data in view is updating, and still its giving an error,
can u tell me why this is happening ??
Thank u.
Edited by: 861930 on May 27, 2011 3:51 AM