wubx

CREATE OR REPLACE TABLE probe_kK (s VARCHAR) AS
SELECT REPEAT('A', K-1) || TO_CHAR(SEQ8())
FROM TABLE(GENERATOR(ROWCOUNT => 500000000))
ORDER BY 1;   

SET probe = (SELECT s FROM probe_kK SAMPLE (1 ROWS));
SELECT COUNT(*) FROM probe_kK WHERE s = $probe;