1.可以使用union all
select '工程科' as bmxx from dual
union all
select '分局车队' as dept from dual
union all
select '计划科' as dept from dual
union all
select '纪委' as dept from dual
union all
select '离退休人员管理科' as dept from dual
2.可以把将要展示的常量拼成一个字符串(使用逗号连接),然后使用oracle函数REGEXP_SUBSTR()进行拆分成多行
注:https://blog.csdn.net/lixu_csdn/article/details/82760892
注:https://www.cnblogs.com/yuany69/p/6093017.html
注:https://blog.csdn.net/u014514528/article/details/80611128
3.如果执行sql后,有值为null的行,可使用 字段 is not null 作为条件来判断