|| 连接字符串 相当于 +
select rws.pk,
'../../loadfile/showPic.action?objectId='||rb.pk imgSrc,
'资源名称:'||rb.RESOURCE_NAME || '<br>' ||'资源条码:'|| rws.BAR_CODE resourceName,
rws.UNIT_PRICE unitPrice
from RM_BASE rb
inner join RM_WAREHOUSING_STOCK rws
on rb.pk = rws.rm_base_pk
where
rws.STOCK_STATUS='1'
and rws.CONSTANT_PACKET_MARKING='1'
只连接字符串 如果不是字符串类型 用to_char转为字符串
select
PK,
CALENDAR_TITLE,
to_date(
(case WEEK_DAY
when '1' then #day1#
when '2' then #day2#
when '3' then #day3#
when '4' then #day4#
when '5' then #day5#
when '6' then #day6#
when '7' then #day7#
end
)||' '||TO_CHAR(CALENDAR_START_TIME,'hh24:mi:ss')
,'yyyy-mm-dd HH24:MI:SS') CALENDAR_START_TIME,
to_date(
( case WEEK_DAY
when '1' then #day1#
when '2' then #day2#
when '3' then #day3#
when '4' then #day4#
when '5' then #day5#
when '6' then #day6#
when '7' then #day7#
end
)
||' '||TO_CHAR(CALENDAR_END_TIME,'hh24:mi:ss')
,'yyyy-mm-dd HH24:MI:SS') CALENDAR_END_TIME,
IS_ALL_DAY_EVENT,
IS_ACROSS_DAY_EVENT,
IS_CYCLE_DAY_EVENT,
1 COLOR_THEME,
'0' IS_AUTHORITY,
LOCATION,
PARTICIPANT,
RESOURCE_PK,
'2' WORK_FLOW_STATUS
from RM_RESOURCE_PREDISTRIBUTION t
where WAREHOUSING_STOCK_PK = #warehousingStockPk#
order by calendar_start_time