Re: Newbie ? - Howto find nbr records in a table

From: <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Wed, 07 Oct 1998 12:43:29 GMT
Message-ID: <6vfnlh$st8$1@nnrp1.dejanews.com>

SELECT COUNT (*) FROM table_name;

In article <361A2ED4.D8B940C6_at_kscgws00.ksc.nasa.gov>, Brian Richardson <RichaBK_at_kscgws00.ksc.nasa.gov> wrote:
> Hello,
>
> I want to find out how many records (total) are in a table. I'm writing
> some
> PL/SQL to allow a user to interact with an Oracle database from a
> pc-based
> browser.
>
> Can anyone suggest a simple method for this ?
>
> Environment: Oracle v.7.3.x, Sun Solaris, Netscape clients, PL/SQL
> Packages
>
> Thanks in advance.
>
> Brian Richardson
>
>

--
Ed Stevens
Nissan Motor Mfg. Corp., USA

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 07 1998 - 07:43:29 CDT