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: UPDATE or INSERT on a view ?

Re: UPDATE or INSERT on a view ?

From: vecna <vecna_at_comtv.ru>
Date: Mon, 22 Sep 2003 16:07:39 +0400
Message-ID: <bkmoq3$189t$1@news.comcor-tv.ru> 






"Zixiong WANG" <z.wang_at_sysium.com> сообщил/сообщила в новостях следующее:
news:1064226325.855394_at_teheran.magic.fr...


> Hi,

>

> Can I execute an UPDATE or an INSERT to a view ?




Yes, but not for all views (view must be with primary keys, update only one
table, no group/distinct etc in view)


or RTFM "INSTEAD OF" triggers
Received on Mon Sep 22 2003 - 07:07:39 CDT












Original text of this message













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