我有一个查询,比如
select a.host_coll_code AS "Code", a.description AS "DESCRIPTION"
from coll_collateral a
当此查询运行时,我得到的结果如下
Code DESCRIPTION
---------------------------
123 ABC
589 UYR
... ...
我想在一列中得到结果,带有分隔符,例如
Code and Description
---------------------
123-ABC
589-UYR
....
我该怎么做?
谢谢
通过使用concat
函数或串联运算符||
:
SQL> with t1(Code, DESCRIPTION) as(
2 select 123, 'ABC' from dual union all
3 select 589, 'UYR' from dual
4 )
5 select concat(concat(to_char(code), '-'), DESCRIPTION) result
6 from t1
7 ;
RESULT
-----------
123-ABC
589-UYR
或
select to_char(code) || '-' || Description result
from t1
RESULT
-----------
123-ABC
589-UYR
select a.host_coll_code || '-' || a.description AS "Code and Description"
from coll_collateral a
select CAST(a.host_coll_code AS VARCHAR(100))
||'-'||
a.description AS "CODE_AND_DESCRIPTION"
from coll_collateral a