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.

What is break?

1140

---

What is sql profiler in oracle?

1013

---

Is primary key a clustered index?

910

---

Why is pl sql needed?

874

---

what is a materialized view? : Sql dba

996

---

Can we join 3 tables in sql?

955

---

How do I make my sql query run faster?

891

---

Does sqlite need a server?

994

---

What is join view in sql?

897

---

What is rename command in sql?

950

---

Why do we use view in sql?

909

---

What is benefit of creating memory optimized table?

907

---

What is dense_rank?

879

---

How to fetch alternate records from a table?

1158

---

How global cursor can be declare with dynamic trigger ?

2146

---