Re: canot update view On 7 Nov., 11:01, eliot06 <p.hi...@gmail.com> wrote:
> hi,
> someone could help me :
> I have create a vue :
>
> CREATE OR REPLACE VIEW MARKETING.VUE_JEULST026
> (
> NUCLI,
> TYNOM,
> NULST,
> NOLST,
> PRLST,
> ANNAISLST,
> MONAISLST,
> JONAISLST,
> NUCLI_MRK,
> NUCLI_ENT,
> COMPTE,
> NAME_ID,
> NUCLI_CARDEX,
> CD_CLIENT,
> ID_CLI,
> NUCLI_DEPOT,
> NUTIT
> )
> AS
> SELECT
> "NUCLI","TYNOM","NULST","NOLST","PRLST","ANNAISLST ","MONAISLST","JONAISLST","NUCLI_MRK","NUCLI_ENT", "COMPTE","NAME_ID","NUCLI_CARDEX","CD_CLIENT","ID_ CLI","NUCLI_DEPOT","NUTIT"
> FROM marketing.jeulst026
> /
>
> And i can't update or insert or delete !!! anything
>
> Why
Hi,
Update or insert into a view is only working under certain
circumstances. Maybe you should offer the information of your Oracle
version. And maybe consultation of the manuals is also helpful
(obviously ...).
cheers,
stephan |