Counting rows returned from a query

From: <danalynn_at_my-dejanews.com>
Date: Mon, 28 Sep 1998 18:03:21 GMT
Message-ID: <6uoj18$q62$1@nnrp1.dejanews.com>

Hello,

I am trying to find out how many rows were affected by a SQL query (Update or Insert). I know that MSSQL has a background variable @@rowcount that returns exactly this, but what does Oracle have?

(I'd rather not do this in PL/SQL with the sql%rowcount value, I was hoping to find something in basic SQL)

Thank you.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 28 1998 - 13:03:21 CDT