For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
ORA-01400: cannot insert NULL into ("HR"."EMPLOYEES"."LAST_NAME")
CREATE OR REPLACE VIEW EMP_VW1 AS SELECT EMPLOYEE_ID FROM EMPLOYEES;
DESC EMP_VW1;
INSERT INTO EMP_VW1(EMPLOYEE_ID) VALUES('1000');
SELECT * FROM EMP_VW1;