Accessing view USER_TABLES
From: Robert Martin <rmartin_at_mindspring.com>
Date: Sun, 19 Mar 1995 22:35:09 -0400
Message-ID: <rmartin.5.00459AA8_at_mindspring.com>
Date: Sun, 19 Mar 1995 22:35:09 -0400
Message-ID: <rmartin.5.00459AA8_at_mindspring.com>
I am using the NUM_ROWS column from the built in view USER_TABLES. It works well most of the time, but sometimes the NUM_ROWS value is NULL, even when the table actually has rows.
Are the tables that make up the view only updated periodically? How can I ensure from within a PL/SQL program unit that the NUM_ROWS value is correct? Received on Mon Mar 20 1995 - 03:35:09 CET