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 |
what is oltp (online transaction processing)? : Sql dba
What is the purpose of the primary key?
what is cross join? : Sql dba
Does group by remove duplicates?
What are triggers and its uses?
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
Why partition by is used in sql?
Can a table have no primary key?
how to rename an existing table in mysql? : Sql dba
Does truncate free space?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What are the differences between in and exists clause?