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

Answer Posted / monika

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sequence in sql?

720


describe mysql connection using mysql binary. : Sql dba

754


Where the sql database files are stored?

692


Is primary key clustered index?

688


What is the difference between the sql*loader and import utilities? : aql loader

756






What is cost in sql execution plan?

683


how does a local variable is defined using t-sql? : Transact sql

730


What is pessimistic concurrency control? : Transact sql

831


What are the two types of exceptions in pl/sql?

733


How do you change a value in sql?

738


How to run sql*plus commands in sql developer?

800


How do you know if a relationship is 2nf?

689


what is the use of double ampersand (&&) in sql queries?

820


What is right join sql?

711


What is where clause in sql?

734