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
Explain the difference between triggers and constraints?
What are % type and % rowtype?
How to connect a sql*plus session to an oracle server?
How can check sql version from command line?
State some properties of relational databases?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I debug a stored procedure?
How do I view a view in sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Can we rollback after truncate?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is inner join in sql?
What does subquery mean in sql?
Can we update views in sql?
Explain lock escalation? : Transact sql