sql 语句合并列

来源:互联网 发布:软件体系结构包含 编辑:程序博客网 时间:2024/05/19 16:33

select USER_ID||USER_NAME as a from ecs_user where ROWNUM<10


select USER_ID||'_'||USER_NAME as a from ecs_user where ROWNUM<10  //加间隔符的


select "CONCAT"(USER_ID,USER_NAME) as a from ecs_user where ROWNUM<10