Re: getting the date of table's modification

Do you mean the data in the field? Or issued DDL to alter the field's properties?

If the former ... that is something you must design into your table structure and update with your SQL or through a trigger.

Daniel Morgan

Scott Mattes wrote:

> Is there some table/field that shows the last time someone added/changed a
> table field?
>
> Thank you.
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
> news:3C752C6C.F2040A46_at_ci.seattle.wa.us...
> > SELECT created, last_ddl_time
> > FROM user_objects
> > WHERE object_name = 'XXX';
> >
> > Daniel Morgan
> >
> >
> >
> >
> > Paolo wrote:
> >
> > > Hi everybody,
> > >
> > > how may I get date of table's modification ?
> > > ( modification = newly created, or just insert, delete, update)
> > >
> > > I tried something like:
> > >
> > > select object_name, last_ddl_time
> > > from dba_objects
> > > where object_name = 'MY_TABLE'
> > >
> > > But after I modified table MY_TABLE (for example with an update)
> > > the result from the query above is the same, and nothing changed.
> > > I wonder where my mistake is.
> > >
> > > Thanks in advance for any help, kind regards,
> > > Paolo
> > >
> > > PS:
> > > using Oracle 7.3.3 under AIX 4.3.1
> >
Received on Thu Feb 21 2002 - 15:26:22 CST