create a view

[thorny00]

I have a table in a warehouse, with FIRSTNAME, LASTNAME, INSTNAME i.e.

FIRSTNAME LASTNAME INSTNAME
HULK HOGAN
FRED FLINTSTONE
GEORGE BUSH
JOE BLOWS
STEVE SURFIN

What I'd like to do is create a new view with a field named FULLNAME that would look at INSTNAME to see if its null then concatenate LASTNAME, FIRSTNAME and move it to the new FULLNAME field, if INSTNAME is not null move INSTNAME to FULLNAME

All help is greatly appreciated

 

[swampBoogie]

create view x as
select coalesce(instname,lastname||', '||firstname) as fullname
from tableInAWarehouse

 

[sem]

And "more Oracle" syntax:

select
nvl(INSTNAME, FIRSTNAME||' '||LASTNAME) FULLNAME
from <your tab> Regards, Dima