Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent: Equivalent of @@rowcount in Oracle
On 9 Dec 2005 21:53:34 -0800, pankaj_wolfhunter_at_yahoo.co.in wrote:
>Greetings,
> Sybase has a global variable, @@rowcount, that returns
>the
>number of rows affected by the previous query.
>Is there some equivalent for that in oracle?
>Any help will be appreciated
sql%rowcount
Can be looked up in the documentation at http://tahiti.oracle.com
And there is no such thing as 'urgent' here, as this is a volunteer forum.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Dec 10 2005 - 00:26:26 CST