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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Nov 26 2019
8 comments
2,454 views