Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert rows from a materialized view? Is it possible?
nkunkov_at_escholar.com wrote:
> Hi,
> Is it possible to do an insert from a materialized view?
> I'd like to call a function from the view to do the insert.
> Will this work?
> Do I need to use execute immediate?
> Your help is greatly appreciated.
> Thank you.
You need to:
![]() |
![]() |