如何横向合并多个字段为一个字段？谢谢

[ahxu2003]

如表user
id firstname secondname type
1 tom adise 2
合并以为为
id name type
1 tom adise 2

想把合并的这个做成view，谢谢

[daydayupliq]

create view bb as select id,firstname||' '||secondname,type from 原表;

[dinya2003]

create view view_name as select id,firstname||' '||secondname name,type from user

[freddy2003]

CREATE VIEW V_T (ID,NM,type) AS
Select ID,firstname||' '||secondname,type
from user WITH READ ONLY