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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL - Count of Rows into a table

Re: SQL - Count of Rows into a table

From: Marc <mlatham23_at_yahoo.com>
Date: 2000/01/29
Message-ID: <s977tjra1cf17@corp.supernews.com>#1/1 






Look at the dynamic sql option.  It will create the sql on the fly to count
the records and populate your table. 7.3 - 8.0 dbms_sql 8.1.5 built in
dynamic sql.



To automate this create an oracle job that runs at the desired interval.
dbms_jobs



O'reilys book on oracle's built in packages has excellent information on
both of these packages.



>

Received on Sat Jan 29 2000 - 00:00:00 CST












Original text of this message













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