ALTER VIEW MY_VIEW_NAME ADD NUMVALUE DECIMAL TO_NUMBER(STRVALUE)
Yes. Please see the docs which illustrate how to create views.
On 7/28/20 2:12 AM, Arun J wrote:
> Can we create or alter a view to add a column which is pseudo columns
> such as
> # FULLNAME from other columns such as FIRSTNAME + LASTNAME
> # NUMVALUE from other columns TO_NUMBER(STRVALUE)
> This would be quite helpful to avoid changing data types everytime in
> the client query.
> Thanks in advance.