a和b是什么类型，是数值的话如果求和，这样写：create or replace view xx as select a+b a1,c,d,e from teacher 如果a和b是字符串类型，这样写：create or replace view xx as select a || b a1,c,d,e from teacher
