Re: SQL - Count of Rows into a table

From: Marc <mlatham23_at_yahoo.com>
Date: 2000/01/29
Message-ID: <s977tjra1cf17_at_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 CET

This message: [ Message body ]
Next message: Stefan Rudolph-Klindtwort: "Re: User Interface for selecting a file"
Previous message: lazymoo_at_my-deja.com: "Re: Trouble installing JDBC driver for Java 1.2 in Solaris"
In reply to: RxB: "SQL - Count of Rows into a table"
Next in thread: Stefan Rudolph-Klindtwort: "Re: User Interface for selecting a file"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message