Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert rows from a materialized view? Is it possible?

Re: Insert rows from a materialized view? Is it possible?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Jun 2006 09:45:00 -0700
Message-ID: <1150389906.695616@bubbleator.drizzle.com>


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:

  1. Better explain what you are trying to do.
  2. State the Oracle version
  3. Which type of Materialized View? -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
Received on Thu Jun 15 2006 - 11:45:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US