Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL create new view with Insert Into statement

2665709Nov 26 2019 — edited Nov 26 2019

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.

This post has been answered by jaramill on Nov 26 2019
Jump to Answer
Comments
Post Details
Added on Nov 26 2019
8 comments
3,096 views