All Questions
1 question
1
vote
2
answers
93
views
What is equivalent of TOKEN_GENERATOR ORACLE SQL statement in SQLite
I'm working with some SQL queries in ORACLE which have the following construct:
WITH TOKEN_GENERATOR AS (
SELECT REGEXP_SUBSTR(:token_0, '[^,]+', 1, LEVEL) token
FROM DUAL
CONNECT BY LEVEL ...