Re: Loop a Stored Procedure
Quote
I want to run a query which will loop through all employees and pass the employee_id to param_employee_id to show the result.
Why?
Relational Databases do things best when working in a
Set-Based way; you retrieve a "set" of data and do something with it in your application. By introducing the use of loops, you're
seriously limiting the performance of your application.
Regards, Phill W.
Subject
Written By
Posted
Re: Loop a Stored Procedure
April 27, 2015 06:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.