a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
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 This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is index? : Sql dba
what is the command line end user interface - mysql? : Sql dba
what are the properties and different types of sub-queries? : Sql dba
What are the differences between in and exists clause?
what is 'mysqlimport'? : Sql dba
Why is a trigger used?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is sap sql?
How do I run pl sql in sql developer?
Why cross join is used?
explain what is mysql? : Sql dba
What are data types in pl sql?
What is a null value?
What is a natural join?
what is innodb? : Sql dba