I have the following statement, which works.
<html>
CREATE TABLE t AS
SELECT level AS id,
CASE round(dbms_random.value(1,2))
WHEN 1 THEN 'Y'
WHEN 2 THEN 'N'
END AS val1
FROM dual
CONNECT BY level <= 5;
</html>
Is there a way to nest level statements or stick a loop within a level statement to create a 7 or N byte string of 'Y' or 'N', which has a column called val1 with a value like this 'YYNNYNY