How to insert data in this view using Interactive grid report in oracle apex
CREATE OR REPLACE FORCE EDITIONABLE VIEW "EMP_DEPT" ("EMPNO", "ENAME", "DEPTNO", "SAL", "DNAME", "LOC") AS
SELECT emp.empno, emp.ename, emp.deptno, emp.sal, dept.dname, dept.loc
FROM emp, dept
WHERE emp.deptno = dept.deptno;
CREATE TABLE "EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
PRIMARY KEY ("EMPNO")
USING INDEX ENABLE
) ;
ALTER TABLE "EMP" ADD FOREIGN KEY ("DEPTNO")
REFERENCES "DEPT" ("DEPTNO") ENABLE;
CREATE TABLE "DEPT"
( "DEPTNO" NUMBER(4,0),
"DNAME" VARCHAR2(14),
"LOC" VARCHAR2(13),
PRIMARY KEY ("DEPTNO")
USING INDEX ENABLE
) ;