How to display the column value adjacent to each other?

Oracle Certification, Database Administration, SQL, Application, Programming Reference Books How to display the column value adjacent to each other?

The general format of the query is :

   SELECT a.dnum, b.cnum
   FROM
   (select rownum num1,
    decode(mod(rownum,2),1,your_column_name) dnum
    from your_table_name ) a,
   (select rownum num2,
    decode(mod(rownum,2),0,your_column_name) cnum
    from your_table_name ) b
    where (a.dnum is not null and b.cnum is not null)
    AND b.num2=a.num1+1

A particular example is :
   SELECT a.dnum, b.cnum
   FROM
   (select rownum num1,
    decode(mod(rownum,2),1,ename) dnum
   from emp ) a,
   (select rownum num2,
    decode(mod(rownum,2),0,ename) cnum
   from emp ) b
   where (a.dnum is not null and b.cnum is not null)
   AND b.num2=a.num1+1

Return to : Oracle Database, SQL, Application, Programming Tips