Answer Posted / suman

Yes we can insert records if view having one to one table. but we cannot create insert if we have multiple table join query

create or replace view v_emp
as select * from emp;

insert into v_emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
values(1111,'suman','CLERK',1111,SYSDATE,11,1,20);

create or replace view v_emp
as select empno,ENAME,job,deptno from emp;

insert into v_emp(empno,ename,job,deptno)
values(1112,'suman','CLERK',20);



SELECT * FROM V_EMP WHERE EMPNO=1111;
SELECT * FROM V_EMP WHERE EMPNO=1112;

create or replace view v_emp_dept
as select empno,e.deptno,dname from emp e, dept b where e.deptno=b.deptno;

insert into v_emp_dept(empno,deptno,dname)
values(1112,'suman','CLERK');

select * from v_emp_dept where empno=1111;
01776. 00000 - "cannot modify more than one base table through a join view"
*Cause: Columns belonging to more than one underlying table were either
inserted into or updated.
*Action: Phrase the statement as two or more separate statements.

Is json a nosql?

972

---

Name three sql operations that perform a sort.

997

---

Why we use pl sql?

955

---

what is an extent ? : Sql dba

1082

---

What are the types of keys?

988

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1084

---

What is sql resultset?

979

---

How to handle bulk data?

1304

---

what is the difference difference between procedure and packages

10382

---

How to load data with sql*loader?

1042

---

What is sql entity?

1087

---

How many unique keys can a table have?

1007

---

What has stored procedures in sql?

1057

---

What is the execution plan in sql?

1014

---

What are the two different parts of the pl/sql packages?

1076

---