Re: canot update view

eliot06 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

Look at user_updatable_columns.

SELECT table_name, column_name, updatable, insertable, deletable FROM user_updatable_columns
WHERE table_name IN (

   SELECT view_name
   FROM user_views);

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org