Sql参数是一个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;