Re: user_updatable_columns

"Tomo" <tkokoska_at_varteks.com> schreef in bericht news:g2o39c$mr8$1_at_ss408.t-com.hr...
>
> "Shakespeare" <whatsin_at_xs4all.nl> wrote in message
> news:484f879d$0$14345$e4fe514c_at_news.xs4all.nl...
>>
>> "Tomo" <tkokoska_at_varteks.com> schreef in bericht
>> news:g2nvi8$e70$1_at_ss408.t-com.hr...
>>> if i
>>> select * from user_updatable_columns
>>> i get information if column in table is updatable or not, insertable or
>>> not, deletable or not.
>>>
>>> What makes column updatable, insertable, deletable?? Primary key, not
>>> null
>>> constraints..??
>>> please clear my mind!
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> USER_UPDATABLE_COLUMNS describes columns in a JOIN VIEW that can be
>> updated by the current user.
>
> Yes, but why one column is updatable or other is not..is it depend on
> create table statement??
>
>>
>> Shakespeare
>>
>
>

No it is how your CREATE OR REPLACE VIEW statement is built. It's not about tables, but about views. If you update a view, Oracle must be able to find (uniquely) the underlying row in one of the tables the view was composed of.

Shakespeare Received on Wed Jun 11 2008 - 03:57:53 CDT