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

On Nov 7, 7:18 am, gazzag <gar..._at_jamms.org> wrote:
> On 6 Nov, 20:41, yorg..._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.
>
> Look into the LAST_DDL_TIME column in the DBA_OBJECTS view.
>
> HTH
>
> -g

That will give me a Table that is added, with the date it was created, but it doesn't show new fields that are added to a table. Received on Fri Nov 07 2008 - 08:24:16 CST