Toad World® Forums

Is that possible to write an insert statement into a view from mutli-tables

Message from: Decaventa

Using oracle,

I am able to write an insert statement into a view that is constructed from one
table.

My question is,

Is that possible to write an insert statement into a view that is constructed
from multi tables?

Regards,


Historical Messages

Author: Decaventa
Date: Mon Dec 05 02:41:03 PST 2011

Using oracle,

I am able to write an insert statement into a view that is constructed from one
table.

My question is,

Is that possible to write an insert statement into a view that is constructed
from multi tables?

Regards,

__


On Mon, Dec 5, 2011 at 11:41 AM, Decaventa wrote:

Using oracle,
I am able to write an insert statement into a view that is constructed from one table.
My question is,
Is that possible to write an insert statement into a view that is constructed from multi tables?

That’s possible. Depends on your constraints, madatory fields,…
Please post your tables (with sample content) and the view to give
more detailed answer.

cheers Sven

Morning,

Is that possible to write an insert statement into a view that is
constructed from multi tables?
Yes. Use an INSTEAD OF INSERT trigger.

http://www.jlcomp.demon.co.uk/faq/joinview.html has details on an
INSTEAD OF UPDATE - a little something I wrote back in 2003!

Have fun.


Cheers,
Norm. [TeamT]