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

Recommended Answers

try this

select * from user_views
Jump to Post

All 3 Replies

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.