View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 07:46 AM
steph
 
Posts: n/a
Default 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

Reply With Quote