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

Home -> Community -> Usenet -> c.d.o.server -> Re: delete from a view

Re: delete from a view

From: Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM>
Date: Thu, 29 Apr 2004 15:37:57 +0200
Message-Id: <pan.2004.04.29.13.37.57.550938@ionicsoft.comNOSPAAAAM>


On Thu, 29 Apr 2004 12:55:59 +0000, Brian Peasland wrote:

>> Of course, that's why I wanted to know if there is a way to tell the
>> database that column X in the view is a primary key

>
> There is no such way. A view does not have a primary key. PK constraints
> are applied only on the table level.
>
> Any reason why you can't just delete from the table? Or use an INSTEAD
> OF trigger?
>
> Cheers,
> Brian

In fact, I made the view because I get a uuid, and I don't know of which type it is (see first posts for explanation of structure). So, the view gather all the tables with good performance. I have the same problem with the delete.

Fred Received on Thu Apr 29 2004 - 08:37:57 CDT

Original text of this message

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