Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: when is a variable not a variable

Re: when is a variable not a variable

From: Chris Sarjent <SARJENT_CHRIS_J_NONLILLY_at_LILLY.COM>
Date: 1997/01/29
Message-ID: <32EFA77E.1C48@LILLY.COM>#1/1 







John Steinbach wrote:


>

> <snip>

> 

> Any Thoughts?

> 

> John STeinbach

> Bartlett Tree Experts




Another option besides the dynamic SQL is to run ANALYZE on each table
you wanted the count for and then query dba_tables for table_name and
num_rows.



Chris Sarjent
Received on Wed Jan 29 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US