oracle ||

|| 连接字符串 相当于 +

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