This discussion is archived
2 Replies Latest reply: Mar 19, 2013 7:29 AM by HamidHelal RSS

How to achive this in Oracle SQL

508329 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points