oracle的concat的用法

最新推荐文章于 2024-06-14 15:21:56 发布

weixin_34275734

最新推荐文章于 2024-06-14 15:21:56 发布

阅读量445

点赞数

文章标签：数据库

    select    concat(
          concat(
            concat(
              (
                select area_name 
                from ec_area  
                where 
                  area_id = 11
              ), (
                select area_name 
                from ec_area 
                where 
                  area_id = 109
              )
              ), (
                select area_name 
                from ec_area 
                where 
                  area_id =1147
              )
          ), '北京****'
        ) as 用户地址
         from ec_area

select (select area_name  from ec_area where area_id = 11 ) ||
       (select area_name from ec_area where area_id = 109) ||
       (select area_name from  ec_area where area_id = 1147) ||( '北京****')
       as  用户地址
  from ec_area