By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl (id integer);
SELECT row_number() OVER (ORDER BY id RANGE UNBOUNDED PRECEDING) AS rn
FROM tbl;
ORA-00907: missing right parenthesis
ORA-00907: missing right parenthesis