Re: When a Column/Field was Added to a Table

From: Jaap W. van Dijk <>
Date: Fri, 07 Nov 2008 22:38:47 GMT
Message-ID: <>

On Thu, 6 Nov 2008 12:41:35 -0800 (PST), 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.

Jaap. Received on Fri Nov 07 2008 - 16:38:47 CST

Original text of this message