UPDATE DPIT.DEDUCTIONS SET END_DATE = '01-DEC-05' WHERE EMPLOYEE# = '09039351' AND PAYCODE = 'EVBIN';

SELECT OBJECT_TYPE
FROM ALL_OBJECTS
WHERE OBJECT_NAME = 'DEDUCTIONS'
AND OWNER = 'DPIP' -- or DPIT - whatever

scott@TESTDB> desc staff

 Name       Null?    Type
 ---------- -------  ---------
 EMPNO      NOT NULL NUMBER(10)
 ENAME               VARCHAR2(1000)
 STATUS     NOT NULL VARCHAR2(10)			

scott@TESTDB> desc staff_details;

 Name        Null?    Type
 ----------- -------- ---------
 DESIGNATION          VARCHAR2(1000)
 ENAME                VARCHAR2(1000)
 JOIN_DATE            DATE

scott@TESTDB> select * from staff;

EMPNO   ENAME     STATUS 
-----   ------    -------
123	ABC	ACTIVE
456	DEF	INACTIVE
789	GHI	ACTIVE


scott@TESTDB> select * from staff_details;

DESIGNATION	ENAME	JOIN_DATE
-----------       ------  ----------
ACCOUNTANT	ABC	12/12/2004
DRIVER	         DEF	22/06/2004

scott@TESTDB> CREATE OR REPLACE VIEW ABC AS
2   SELECT S.EMPNO EMPNO, S.ENAME ENAME, S.STATUS STATUS, 
3   D.DESIGNATION DESIG, D.JOIN_DATE J_DATE
4   FROM STAFF S, STAFF_DETAILS D
5   WHERE S.ENAME = D.ENAME
/  

View created.

scott@TESTDB> UPDATE abc
  2  SET j_date = '01-JAN-2003'
  3  WHERE empno = 456
  4  /
set j_date = '01-JAN-2003'
    *
ERROR at line 2:
ORA-01779: cannot modify a column which maps to a non key-preserved table

alter session set nls_date_format='DD-MON-YYYY';

select to_char(to_date('01-DEC-05'),'mm/dd/yyyy') from dual;

TO_CHAR(TO
----------
12/01/0005