Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
hay friends,
Can we auto update base tables after updating view using ORACLE
for example i have three base tables, and one view when i update view then also changes made in base tables..
if you have then please give me examples
Posted
Comments
Sandeep Mewara 10-May-13 13:26pm    
You talking of TRIGGERs?

1 solution

Please note that you can not update multiple tables simultaneously using a complex view (consisting multiple tables). Please refer to this [LINK] for more details.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900