26Trs1KP

1CREATE TABLE IF NOT EXISTS dual
2AS
3SELECT 'X' AS dummy
4;
5SELECT x,
6       (row_number() over ()) - 1 as r0,
7       row_number() over () AS r
8  FROM dual
9LATERAL VIEW
10        EXPLODE(SENTENCES(RPAD('',256 * 3,'a. '))[0]) c AS x
11 ORDER BY r0
12;