I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column.

I want to know the SQL statement to find out the base tables of th view and also the base columns for the virtual column.

Regards,
Dinil

try this

select * from user_views

try this

select * from user_views

I want to find out the base tables of the view and also a way to update the virtual columns.

Regards,
Dinil

can't you find the base tables of the view from SQL(in the TEXT column of above mentioned dictionary object) ?

and once you have the SQL, that can be modified for any new requirement.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.