Member Avatar for dinilkarun

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

  • 2 Contributors
  • 3 Replies
  • 106 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

try this

select * from user_views
Member Avatar for dinilkarun

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

Member Avatar for debasisdas

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.

Edited by debasisdas because: n/a
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.