Still alive (without life), very busy! I couldn't resist this one although I knew it was coming based on the trend of your previous emails last two weeks :) Regards, Waleed -----Original Message----- From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx] Sent: Tuesday, February 17, 2004 5:25 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Counting number of rows Waleed, I haven't seen you on the list for a long time. If writing a function like that was what it takes to get you back, it was more then worth it. On 02/17/2004 04:55:53 PM, "Khedr, Waleed" wrote: > It did not work for me, for some reason it always returns zero > > Waleed > > -----Original Message----- > From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx] > Sent: Tuesday, February 17, 2004 4:15 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: Counting number of rows > > > The function below would count rows extremely quickly, and is > independent of the table size. Even better, it is completely accurate > and doesn't rely on the underlying statistics. The table > in question may not even be analyzed. It does have one minor > shortcoming, however. > > <PRANK> > create or replace > function count_rows(tbl in varchar2) return number deterministic > as > TRUNC VARCHAR2(128):='truncate table '||tbl; > begin > execute immediate trunc; > return(0); > end; > / > </PRANK> > On 02/17/2004 03:27:31 PM, "Potluri, Venu (CT Appl Suppt)" wrote: > > Is there a quick way to count number of rows in a table? Don't want > > > to > > do select count(*) from..... on a table (such as GL_BALANCES) with > > more than 250 million rows. > > -------------------------------------------------------- > > > > If you are not an intended recipient of this e-mail, please notify > > the > > sender, delete it and do not read, act upon, print, disclose, copy, > > retain or redistribute it. Click here for important additional > terms > > relating to this e-mail. http://www.ml.com/email_terms/ > > -------------------------------------------------------- > > > > > ============================================================================ > == > > > > If you are not an intended recipient of this e-mail, please notify > > the sender, delete it and do not read, act upon, print, disclose, > > copy, retain or redistribute it. > > > > Click here for important additional terms relating to this e-mail. > > <http://www.ml.com/email_terms/> > > > > > ============================================================================ > == > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------