Re: check how many rows processed of a sql statement

From: <czekala_at_my-dejanews.com>
Date: Tue, 07 Jul 1998 11:48:49 GMT
Message-ID: <6nt1v1$lrq$1@nnrp1.dejanews.com>

If your statment is cursor fetching you can use attribute cursor_name%ROWCOUNT (all rows count will be returned after last fetch), or if you are using non-cursor statment there is SQL%ROWCOUNT attribute (use after sql statment). Please look in PL/SQL User Guide - Using Cursor Attributes.

Rafal

In article <6np80f$43r$0_at_204.179.92.57>, dshi_at_magpage.com (David Shi) wrote:
>
> Is there a way to check how many rows processed of a sql statement? Thanks.
>
> David
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 06:48:49 CDT