Answer / haarika valasa

IF view is created based on only one base table we can
perform all DML operations.

If view is created based on multiple table using joins and
goup by functions etc..than we cannot perform directly DML
operations.

Using Instead of Trigger we can perform DML operations on
complex view.

Answer / sql2000

a. Yes
b. NO
c. Yes

Answer / pankaj

you can remove the rows from the view if it does not containing any of the following.
1> group function
2> group by clause
3> distinct keyword
4> rownum keyword

Answer / 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.

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

can we update a view which is created from two tables

11 Answers  

---

Is sql a microsoft product?

0 Answers  

---

What is oracle sql developer?

0 Answers  

---

How to know the last executed procedure?

0 Answers  

---

What is %type in pl sql?

0 Answers  

---

When is a declare statement required?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

Is microsoft sql free?

0 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

Explain the types of joins in sql?

0 Answers  

---