SQL>[censored]

SQL> with rainbow (color) as (
  2    select 'red'    from dual union all
  3    select 'orange' from dual union all
  4    select 'yellow' from dual union all
  5    select 'green'  from dual union all
  6    select 'blue'   from dual union all
  7    select 'indigo' from dual union all
  8    select 'violet' from dual
  9  )
 10  select * from rainbow
 11  offset 5 rows -- oracle 12+
 12  fetch next 1 row only;

COLOR
------
orange