Re: When a Column/Field was Added to a Table
From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Fri, 07 Nov 2008 22:38:47 GMT
Message-ID: <4914c323.2486468@news.hetnet.nl>
Date: Fri, 07 Nov 2008 22:38:47 GMT
Message-ID: <4914c323.2486468@news.hetnet.nl>
On Thu, 6 Nov 2008 12:41:35 -0800 (PST), yorgle7_at_yahoo.com wrote:
>I'm trying to create a report that will tell me what new fields are
>added to a database by software patches. I'd like to be able to run
>the report after applying the patches, and have the report give me the
>new fields that were added. Does Oracle store the date that a new
>column was added to a table? Thanks in advance.
Store the result of
select * from dba_tab_columns
prior to applying the patches and compare with the result of this query after applying the patches.
Regards,
Jaap.
Received on Fri Nov 07 2008 - 16:38:47 CST