Okay, for all my occasional preaching/sanctimony about Q/A, project control, effectiveness and efficiency, doin' it right, etc, I am only too human and therefore have a bit of management mess on my hands. I have too many redundant/unversioned/undated copies of databases on my hard drive, but they are not simply copies with incremental additions. Taken together, they'd have all the data I could possibly want or need, plus all the redundancies ; that is, altogether, they are 100% of my data, including duplicates. However, I am now trying to coalesce these, which requires that I inspect the values of certain "audit" fields in the various tables, `InsertedOnDT`, `InsertedOnTM`, `ETC`, in order to look for the most recent INSERTS.
Anyway, what I'm specifically looking for, is a good way to get :
A list of distinct table_names that have a column named like this, "Insert%"
I guess along the lines of :
SELECT DISTINCT SYS_TABLE_NAME FROM SYS_whatever WHERE SYS_COLUMN_NAME LIKE "Insert%"
Would anyone be able to correct this/advise me?
Steve,
LIST COLUMN Insert%
That will give you the list of all related table(s) with column name starting with "Insert".
Have fun!
Very Best R:egards,
Razzak.
