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

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

Question Posted / gavini srikanth

3 Answers
8436 Views
3i Infotech, I also Faced
E-Mail Answers

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