SQL> select max(rownum) from <table_name>;

cheers!!


----- Original Message -----
From: "Cardus Ian "
<oracledba-ezmlmshield-x42277273.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, July 18, 2005 4:57 PM
Subject: RE: Counting The records


> How about
>
> SELECT SUM(1) FROM <table>;
>
>
>
>
> -----Original Message-----
> From: Krystian Zieja
> [mailto:oracledba-ezmlmshield-x89522598.[Email address protected]
> Sent: 18 July 2005 12:28
> To: LazyDBA Discussion
> Subject: Re: Counting The records
>
>
> If you compute statistics on your table
> you can use the following:
>
> select owner,table_name,num_rows
> from dba_tables
> where owner = 'TableOwner' and table_name = 'TableName'
>
> Best Regards
> Krystian Zieja / mob
> > Hi all
> >
> > How can i get the number of records in a table without using the COUNT
> > function
> >
> > please gimme with a query
> >
> >
> >
> > Thanks
> > C Chandra Guptan
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> >
> > Information transmitted by this EMAIL is proprietary to iGATE Group of
> > Companies and is intended for use only by the individual
> > or entity to whom it is addressed and may contain information that is
> > privileged, confidential, or exempt from disclosure under
> > applicable law. If you are not the intended recipient of this EMAIL
> > immediately notify the sender at iGATE or [Email address protected]
> > and delete this EMAIL including any attachments
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>
>
****************************************************************************
*
> This e-mail and its attachments are confidential and are intended for the
above named recipient only. If this has come to you in error, please notify
the sender immediately and delete this e-mail from your system. You must
take no action based on this, nor must you copy or disclose it or any part
of its contents to any person or organisation. Statements and opinions
contained in this email may not necessarily represent those of Littlewoods
Group Limited or its subsidiaries. Please note that e-mail communications
may be monitored. The Registered Office of Littlewoods Group Limited and its
subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. Registered number
of Littlewoods Group Limited is 5059352.
>
****************************************************************************
*
>
>
>
>
> This message has been scanned for viruses by BlackSpider MailControl -
www.blackspider.com
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page