stored procedure in oracle9i

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sheena09
    New Member
    • Oct 2007
    • 2
    #1

    stored procedure in oracle9i

    how to retrieve top 5 rows from a table in a stored procedure.
    Tags: None
    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358
      #2
      Originally posted by sheena09
      how to retrieve top 5 rows from a table in a stored procedure.
      Sheena,

      Why you need to get top 5 rows using a PROCEDURE when you can do that using a simple SQL query itself.

        Comment

        • debasisdas
          Recognized Expert Expert
          • Dec 2006
          • 8119
          #3
          Originally posted by sheena09
          how to retrieve top 5 rows from a table in a stored procedure.
          Kindly post the procedure code that you have written for the purpose for reference of our experts.

            Comment

            Previous template Next
            Working...