 | |
user_updatable_columns
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
user_updatable_columns -
06-11-2008
, 02:36 AM
#2
| |||
| |||
|
|
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! |
by the current user.
Shakespeare
#3
| |||
| |||
|
|
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! |
by the current user.
Shakespeare
#4
| |||
| |||
|
|
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! |
by the current user.
Shakespeare
#5
| |||
| |||
|
|
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! |
by the current user.
Shakespeare
#6
| |||
| |||
|
|
"Tomo" <tkokoska (AT) varteks (DOT) com> schreef in bericht news:g2nvi8$e70$1 (AT) ss408 (DOT) 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. |
table statement??
Quote:
|
Shakespeare |
#7
| |||
| |||
|
|
"Tomo" <tkokoska (AT) varteks (DOT) com> schreef in bericht news:g2nvi8$e70$1 (AT) ss408 (DOT) 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. |
table statement??
Quote:
|
Shakespeare |
#8
| |||
| |||
|
|
"Tomo" <tkokoska (AT) varteks (DOT) com> schreef in bericht news:g2nvi8$e70$1 (AT) ss408 (DOT) 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. |
table statement??
Quote:
|
Shakespeare |
#9
| |||
| |||
|
|
"Tomo" <tkokoska (AT) varteks (DOT) com> schreef in bericht news:g2nvi8$e70$1 (AT) ss408 (DOT) 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. |
table statement??
Quote:
|
Shakespeare |
#10
| |||
| |||
|
|
"Shakespeare" <whatsin (AT) xs4all (DOT) nl> wrote in message news:484f879d$0$14345$e4fe514c (AT) news (DOT) xs4all.nl... "Tomo" <tkokoska (AT) varteks (DOT) com> schreef in bericht news:g2nvi8$e70$1 (AT) ss408 (DOT) 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 |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.