This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Mar 4, 2013 5:47 AM by Purvesh K Go to original post RSS
  • 15. Re: Pl Sql Block Logic to get dates in ASC
    Purvesh K Guru
    Currently Being Moderated
    Shoaib581 wrote:
    Thanks Purvesh,


    Your query is my second option if i cant get what i want from jeneesh's query i will go for yours. As Oracle M told i do want to get my output into excel(Download from Oracle Application Express).

    Thanks alot,
    Shoaib
    I do doubt about you having to go for my solution than for Jeneesh's because both are along similar lines and as demonstrated (probably) produce same output.

    If you wish to pass the result of query to APEX, then you just need to return a ref cursor (I am not so sure as I do not have experience about APEX).

    Contradicting to what Oracle M has said (probably flawed concepts about pl/sql), you need to minimize PL/SQL and maximize SQL inorder to derive better performance. If all your questions are answered, then please consider closing the Thread by marking it as Answered.
1 2 Previous Next

Legend

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