Sql参数是一个list的最佳实践

有空把它翻译成中文

助记

http://betteratoracle.com/posts/20-how-do-i-bind-a-variable-in-list

with id_generator
        as
        (
          SELECT regexp_substr(:txt, '[^,]+', 1, LEVEL) token
          FROM dual
          CONNECT BY LEVEL <= length(:txt) - length(REPLACE(:txt, ',', '')) + 1
        )
        select u.id, u.username
        from users u, id_generator g
        where u.id = g.token;