Thank you very much Paul.
Greetings.
Walter.
On Mon, Dec 16, 2013 at 11:40 PM, paul wrote:
>
>
>
> Hallo Walter,
>
>
> > Then, no makes sense to declare a cursor just for retrieving rows?
>
> No, for just retrieving rows FOR SELECT is easier and safer.
>
> If you want to perform positioned u
Hallo Walter,
> Then, no makes sense to declare a cursor just for retrieving rows?
No, for just retrieving rows FOR SELECT is easier and safer.
If you want to perform positioned updates or deletes, use FOR SELECT ...
AS CURSOR.
DECLARE cursor (with the need for OPEN, FETCH, CLOSE, as well as c
Ok, thank you Mark.
Then, no makes sense to declare a cursor just for retrieving rows?
Where I can see an example of WHERE CURRENT OF clause?
Greetings.
Walter.
On Mon, Dec 16, 2013 at 2:04 PM, Mark Rotteveel wrote:
>
>
> On 15-12-2013 20:25, W O wrote:
> > If in a stored procedure I need t
On 15-12-2013 20:25, W O wrote:
> If in a stored procedure I need to extract data from a table I can use a
> FOR SELECT or a DECLARE VARIABLE MyVar CURSOR FOR ( ) statement.
>
> Which would be the advantage of using CURSOR FOR?
>
> In which cases it is better than a FOR SELECT?
For one thing,
Hello everybody
If in a stored procedure I need to extract data from a table I can use a
FOR SELECT or a DECLARE VARIABLE MyVar CURSOR FOR ( ) statement.
Which would be the advantage of using CURSOR FOR?
In which cases it is better than a FOR SELECT?
Greetings.
Walter.