how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?

Answers were Sorted based on User's Feedback



how to insert the data through views? The view is depending upon more than two tables? how to upd..

Answer / rajesh venati

If we create a view on more than one table, or using
distinct keyword or use any group functions it is called
complex view.
If we want perform DML operations on complex views the we
will go for Instead of Triggers.Through the instead of
triggers we can perform DML operations on complex views.

Is This Answer Correct ?    4 Yes 0 No

how to insert the data through views? The view is depending upon more than two tables? how to upd..

Answer / monika

by creating instead of trigger on table,we can update base
table through view

Is This Answer Correct ?    2 Yes 1 No

how to insert the data through views? The view is depending upon more than two tables? how to upd..

Answer / manikanta.srinu

DML Operations also is done by the view,if view have only
one table.For multiple tables in a view,DML operation was
not support.
how to update materalized views?
If ur master table is updated, your materialized view will
automatically get refreshed if ur materialized view is
create with ON COMMIT option. Else, you
have to REFRESH evertime once ur master is
inserted/deleted/updated.

CREATE MATERIALIZED VIEW departments FOR UPDATE AS
SELECT * FROM departmentsworld;

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What does count (*) mean in sql?

0 Answers  


how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  


What is memory optimized?

0 Answers  


What are the types of SQL Statement?

3 Answers  


Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  






How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  


What are the different types of sql commands?

0 Answers  


how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,


What is the order of sql select?

0 Answers  


What is pl/sql table? Why it is used?

0 Answers  


how to get a list of columns in an existing table? : Sql dba

0 Answers  


What is difference between db2 and sql?

0 Answers  


Categories