Determining if a column is Null quickly
From: Bob Chow <Dlee_at_rogers.com>
Date: 1995/04/10
Message-ID: <Dlee.69.000DA3B4_at_rogers.com>#1/1
Date: 1995/04/10
Message-ID: <Dlee.69.000DA3B4_at_rogers.com>#1/1
Hi,
I am trying to determine quickly, if there are any columns in any of my tables in my Oracle 7 database which has a Null values for every single row for each table. I know is can do this by simply doing a Select statement on the column in question and testing with the IS NULL clause, but to do this would be more time consuming and tedious. I was wondering if there are any system tables that keeps track of this information. Thanks in advance.
Bob Received on Mon Apr 10 1995 - 00:00:00 CEST