SELECT LEVEL AS ID, LEVEL-1 AS aa, LEVEL AS ab, LEVEL+1 AS ac FROM dual CONNECT BY LEVEL<6 SELECT LEVEL AS ID, LEVEL-1 AS aa ...