4 Replies Latest reply on Mar 4, 2013 12:32 PM by 986838

    Rows to columns

      Hello everybody,

      I want to display rows as columns, my select is:

      select id, to_char(col2,'dd-mm-yyyy') , to_char(col2,'hh:mi PM') , action from atable

      sample output is:
      id day* time action*
      1 *02-02-2013* 10:10 AM IN
      1 *02-02-2013* 08:40 PM OUT

      I wonder if I could display the output as:

      id date* IN OUT*
      1 *02-02-2013* 10:10 AM *08:40 PM*

      I'm using Oracle 11g R2
      Windows 7
      Oracle Apex4.2
      Glassfish server open source

      Thanks for the time you spent reading my Question..