oracle中的||是什么意思

       select
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-01') then 1 else null end) A,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-02') then 1 else null end) B,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-03') then 1 else null end) C,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-04') then 1 else null end) D,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-05') then 1 else null end) E,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-06') then 1 else null end) F,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-07') then 1 else null end) G,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-08') then 1 else null end) H,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-09') then 1 else null end) I,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-10') then 1 else null end) J,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-11') then 1 else null end) K,
            count(case when (LIBRARY_TYPE='论文' and TO_CHAR(CREATE_TIME, 'YYYY-MM')=#{year} || '-12') then 1 else null end) L
        from ZT_JSZLB_KJZBWCL_LIBRARY

今天看了一个sql是oracle数据库里的,之前学过mysql数据库,百度了之后发现是连接的意思,可以把两个字段拼接

这里就等于年+月