1、可以使用“||”来拼接字符串:
select
b.province || '-' || b.city || '-' || b.Address as location_descr
FROM
elearning.Opt_User a
JOIN
elearning.Opt_Training b ON a.Trainingid = b.Id
JOIN
elearning.Core_Userprofile u ON a.Userid = u.Id
WHERE
a.Orgid = '21d0b041-13d4-4670-a107-626443693182'
AND
a.IS_DELETED = 0
AND
b.Type = 0
AND
to_char(a.Updatedate,'yyyy-MM-dd') = '2020-03-18';
2、通过concat()函数实现:
select
concat(b.province,'@@@@@@') as location_descr
FROM
elearning.Opt_User a
JOIN
elearning.Opt_Training b ON a.Trainingid = b.Id
JOIN
elearning.Core_Userprofile u ON a.Userid = u.Id
WHERE
a.Orgid = '21d0b041-13d4-4670-a107-626443693182'
AND
a.IS_DELETED = 0
AND
b.Type = 0
AND
to_char(a.Updatedate,'yyyy-MM-dd') = '2020-03-18';
注意:
oracle的concat函数只支持两个参数的方法,即只能拼接两个参数,如要拼接多个参数则嵌套使用concat可实现,如:
select
concat(concat(concat(concat(b.province,'-'), b.city), '-'), b.Address) as location_descr
FROM
elearning.Opt_User a
JOIN
elearning.Opt_Training b ON a.Trainingid = b.Id
JOIN
elearning.Core_Userprofile u ON a.Userid = u.Id
WHERE
a.Orgid = '21d0b041-13d4-4670-a107-626443693182'
AND
a.IS_DELETED = 0
AND
b.Type = 0
AND
to_char(a.Updatedate,'yyyy-MM-dd') = '2020-03-18';