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: Patrick Connors <pmc_at_finger-rock.com>
Date: 28 Apr 2004 12:08:07 -0700
Message-ID: <c0f4d322.0404281108.67c59cc6@posting.google.com>


Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM> wrote in message news:<pan.2004.04.28.14.18.37.460759_at_ionicsoft.comNOSPAAAAM>...
> Hi
>
> I have a view that is a union all of several select. If I try to delete a
> row, I get ora 01752 error.
>
> I'm sure that I can delete the row directly, there is no constraint of FK
> on it.
>
> Any idea ?
>
>
> Thanks
>
> Frederic

Not enough information. At a minimum, I'd need to know the following in order to answer this:
- Is the view over more than one table?
- What version of Oracle?

Received on Wed Apr 28 2004 - 14:08:07 CDT

Original text of this message

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