I am a novice with pl/sql and especially with creating views. I have made some simple views that just have select statements using the 'create or replace view' command.
I need to make some views that contain 'Insert Into' statements as well. Can I create a brand new view (using 'create or replace view') that uses 'Insert Into' to update an actual physical table or do I need to create a 'select type'
view first and then create an 'insert view' that looks at the 'select type' view I just created? I have searched how to do this but have had no luck yet.
Thanks.