ORACLE WHERE DECODE

在oracle中，where条件中使用decode函数

split函数请参考http://awen7916.iteye.com/admin/blogs/2198380

select DISTINCT SITEID
    from WORKORDER
   where siteid in
         (select *
            from table(split((select DECODE('PGC', 'PGC', 'TSQ,GZX', 'GZX')from dual),',')));