Re: getting the date of table's modification

Not without creating a date column and putting a trigger on he table.

Daniel Morgan

Paolo wrote:

> Daniel,
> you're right, sorry for my wrong explanation.
>
> My question is now well stated: is it possible to get date of last
> DML (Data Manipulation Language) operation ?
>
> Thanks again for you attention,
> kind regards.
>
> Paolo
>
> On Fri, 22 Feb 2002 17:19:00 GMT, damorgan
> <dan.morgan_at_ci.seattle.wa.us> wrote:
>
> --->Excuse me ... But ...
> --->
> --->"I updated all rows for a given field" is NOT DDL. It is DML.
> --->
> --->DML stands for "Data Manipulation Language" and that is what you
> did ...
> --->you manipulated the data.
> --->
> --->If you want DDL try
> --->
> --->ALTER TABLE xyz
> --->ADD (new_column VARCHAR2(20));
> --->
> --->and see what happens.
> --->
> --->Daniel Morgan
> --->
> --->
Received on Tue Feb 26 2002 - 15:03:47 CST