Row generator (sequence)

For 256 values

select ROWNUM as SEQUENCEID
   from DUAL
  connect by level < 257
  order by SEQUENCEID asc;