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
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 |
Answer / monika
by creating instead of trigger on table,we can update base
table through view
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is online transaction processing (oltp)?
How do I remove sql plus from windows 10?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
What are sql built in functions?
What are Nested Tables? How will u delete 5 rows from Nested Tables
Is sql open source?
how do you know if your mysql server is alive? : Sql dba
What are stored procedures used for?
Explain the working of primary key?
How to install oracle sql developer?