Row generator targeting an output size if exported to CSV

test_row_generator.sql

--Row generator query to give us a rougly n MB output to CSV, as specified in the first term of the connect by clause
--thanks to excellent inspiration and resource from Natalka Roshak, https://blogs.oracle.com/sql/entry/row_generators_part_2
select level, rownum,'zero_one_two_three_four_five_six_seven_eight_nine_ten_eleven_twelve_thirteen_fourteen_fifteen' number_names ,1234567890 ten_digit_number --about 115 bytes per row once csv'd
from dual
connect by level <= ( 80 * (1048576 / 112))
;