Re: Creating Views

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 23 Aug 1999 20:55:54 GMT
Message-ID: <37c1af97.482428@news.siol.net>

On Mon, 23 Aug 1999 08:15:32 -0400, Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote:

>You cannot insert into a view that is defined with a join.

Yes you can, if you are using Oracle8 or 8i. "INSTEAD OF" triggers were introduced in 8.0 to allow modification of joined tables through views.

>Ken

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Aug 23 1999 - 15:55:54 CDT