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 information schema in sql?
What does data normalization mean?
How do I upgrade sql?
Can we edit a view in sql?
Is stored procedure faster than query?
What do you understand by case manipulation functions?
How will you distinguish a global variable with a local variable in pl/sql?
what is cross join? : Sql dba
How to start the command-line sql*plus?
which operator is used in query for pattern matching? : Sql dba
What is function and procedure in pl sql?
What is raid? How does it help storage of databases?
What is bulk collect in pl sql?
What are analytical functions in sql?
How to place comments in pl/sql?