2 Replies Latest reply: Mar 19, 2013 9:29 AM by HamidHelal RSS

    How to achive this in Oracle SQL

    user505326
      Hi All,

      How to get the below result:

      base table:
      COLA COLB
      112 01-JAN-2012
      113 02-FEB-2012
      114 02-MAR-2013
      115 01-APR-2013


      Result table:

      COLA COLB COLC
      112 01-JAN-2012 01-FEB-2012
      113 02-FEB-2012 01-MAR-2012
      114 02-MAR-2013 31-MAR-2013


      Thanks!
        • 1. Re: How to achive this in Oracle SQL
          riedelme
          Welcome to OTN!!!!!

          This is a SQL question that should apply to any tool that supports SQL. There is a forum for SQL and PL/SQL questions specifically where you will get a better answer faster than you will get one here. This forum is for SQL*Developer issues that are specific to that product.

          Close this thread (mark it as answered) and ask the question in the SQL and PL/SQL fourm to get a better answer.
          • 2. Re: How to achive this in Oracle SQL
            HamidHelal
            user505326 wrote:
            Hi All,

            How to get the below result:

            base table:
            COLA COLB
            112 01-JAN-2012
            113 02-FEB-2012
            114 02-MAR-2013
            115 01-APR-2013


            Result table:

            COLA COLB COLC
            112 01-JAN-2012 01-FEB-2012
            113 02-FEB-2012 01-MAR-2012
            114 02-MAR-2013 31-MAR-2013

            Wrong Forum !!! Post at {forum:id=75}. Before posting there close this thread marking as answered.