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.

Explain what is sql?

1176

---

Explain the uses of a database trigger?

1086

---

How do I run pl sql in sql developer?

1166

---

What is pl sql record in oracle?

1087

---

Is left join same as join?

1035

---

What is bind reference and how can it be created?

1066

---

What does pl sql stand for?

1156

---

How many developers work on postgresql?

1037

---

What are the parameter modes supported by pl/sql?

1147

---

Explain 3 basic parts of a trigger.

1372

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7476

---

What is delimiter sql?

1058

---

Are subqueries faster than joins?

1074

---

Whis is not false in primary key?

1516

---

What is where clause in sql?

1086

---