Re: Add pseudo columns to an existing view

[Josh Elser]

Yes. Please see the docs which illustrate how to create views.

On 7/28/20 2:12 AM, Arun J wrote:

Team,

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.
JAK