1 Reply Latest reply on Nov 28, 2012 8:08 AM by Marwim

    Sql Query Doubt

    976620
      Dear Experts,

      I writing a one query,that query have two parameter 1.start_date
      2 end_date

      Example :
      select to_date(:start_date,'dd-mon-yyyy')-- + rownum -1 a
      from all_objects
      Where Rownum <=
      to_date(:end_date,'dd-mon-yyyy')-to_date(:start_date,'dd-mon-yyyy')+1;


      Prameter : 01-jan-2012

      :05-jan-2012


      O/p


      Columnwise

      01-jan-2012 02-jan-2012 03-jan-2012 04-jan-2012 05-jan-2012




      each date print in separate column...

      How to frame query..

      Kindly advice me..

      Thanks in advance.....
        • 1. Re: Sql Query Doubt
          Marwim
          Hello,

          welcome to the forum.

          This is the forum for the tool {forum:id=260}. Please ask in {forum:id=75} and mark this question as answered so others can spend their time on answering open questions.

          Best Regards
          Marcus