Is there any way to find out whether a View is updatable or not i.e any DBA/ALL views to quickly get this info ?
:)
Printable View
Is there any way to find out whether a View is updatable or not i.e any DBA/ALL views to quickly get this info ?
:)
Yep.
{DBA | ALL | USER}_UPDATABLE_COLUMNS
Tx - mgd. to find that in the admin gde. my brains not functioning as it's Monday morning I guess.
Something else:
When I select owner from dba_views for a view I get 3 owners - what could be happening here ?
:)
3 people have a view with the same name
Something tells me that this is not possible or am I forgetting something here too ?
:)
of course it is possible, different schemas can have objects with the same name
Have you got developers working on/in their own schemas? Often happens.
Yeah - since I was looking at prd. it kinda stumped me - looks like I gotta dig deeper into this db. !!
:)