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 a record in a database?

1102

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1014

---

Why having clause is used in sql?

1020

---

What is the purpose of design view?

1077

---

What are character functions?

1141

---

What is procedure in pl sql?

1090

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1894

---

how to return query output in html format? : Sql dba

1121

---

What is the difference between sum and count in sql?

1039

---

what is blob? : Sql dba

1220

---

What is cursor explain with example?

1031

---

What is a constraint? Tell me about its various levels.

1247

---

How do you add a column to a table?

1104

---

What is prepared statement in sql?

1101

---

What are the various restrictions imposed on view in terms of dml?

1017

---