Oracle - INSERT DATA INTO TABLE WITH THE HELP OF VIEW

VIEW – INSERT DATA INTO TABLE WITH THE HELP OF VIEW

CREATE VIEW VIEW_TEMPDEPT

AS

SELECT * FROM TEMPDEPT

SELECT * FROM VIEW_TEMPDEPT

INSERT INTO VIEW_TEMPDEPT VALUES(16,'MANISHBHAI')

SELECT * FROM VIEW_TEMPDEPT

SELECT * FROM TEMPDEPT

COMMIT;