union

查询了三个结果，一起输出到表格上，使用函数union，还使用了字符串拼接|| || ，chr()换行输出
--论文    KEYANLUNWEN

select  
kk1.id_ as 编号,
dbms_lob.substr(kk1.name_,4000,1)||' '||p2.name||' '||kk1.belong_subject_  as 内容
from KEYANLUNWEN kk1
left join FM_CODE_PUB p2 on kk1.wenxian_=p2.code and p2.code_define='KEYANLUNWEN_WXLX'
--where kk1.emp_id_=${ID}
union

--出版著作 CHUBANZHUZUO
select
zz.id_ as 编号,
chr(10)|| zz.name_ ||' '||p3.name ||' '||zz.jibie_ as 内容
from  CHUBANZHUZUO zz
left join FM_CODE_PUB p3 on zz.type_=p3.code and p3.code_define='ZHUZUOLEIBIE'
--where zz.emp_id_=${ID}d

--出版教材 BENKESHENGCHUBANJIAOCAI
union
select
bb.id_ as 编号,
chr(10)|| bb.name_ ||' '||pp1.name||' '||bb.chubanshe_  as 内容
from BENKESHENGCHUBANJIAOCAI bb
left join FM_CODE_PUB pp1 on bb.type_=pp1.code and pp1.code_define='KEYANLUNWEN_WXLX'
--where bb.emp_id_=${ID}