CREATE OR REPLACE FUNCTION FNCDVAL
(
xCdGrp in varchar2,
xCdKey in varchar2
)
return varchar2
as
nCdVal tb_gnr_cd.cd_val%type;
begin select cd_val
into nCdVal
from tb_gnr_cd
where tb_gnr_cd.cd_id = xCdGrp || xCdKey
; return nCdVal;
end;这段代码中 “||” 的意思是什么?
(
xCdGrp in varchar2,
xCdKey in varchar2
)
return varchar2
as
nCdVal tb_gnr_cd.cd_val%type;
begin select cd_val
into nCdVal
from tb_gnr_cd
where tb_gnr_cd.cd_id = xCdGrp || xCdKey
; return nCdVal;
end;这段代码中 “||” 的意思是什么?
SQL> select 'aa'||'bb' from dual;'AA'
----
aabb
比如'abc'||'def'就成了'abcdef'