Re: When a Column/Field was Added to a Table
From: gazzag <gareth_at_jamms.org>
Date: Fri, 7 Nov 2008 04:18:14 -0800 (PST)
Message-ID: <8a7e7077-f2e3-4860-b645-c5432a8017b3@s9g2000prg.googlegroups.com>
Date: Fri, 7 Nov 2008 04:18:14 -0800 (PST)
Message-ID: <8a7e7077-f2e3-4860-b645-c5432a8017b3@s9g2000prg.googlegroups.com>
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 Received on Fri Nov 07 2008 - 06:18:14 CST