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

From: gazzag <>
Date: Fri, 7 Nov 2008 04:18:14 -0800 (PST)
Message-ID: <>

On 6 Nov, 20:41, 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.

Look into the LAST_DDL_TIME column in the DBA_OBJECTS view.

HTH -g Received on Fri Nov 07 2008 - 06:18:14 CST

Original text of this message