Thread: timestamp of a row
Dear all,
I look into mails-archive but I didn't find any hint for this question: is there a way to retrieve the timestamp of the creation/last modification of a row in a table?
Many thanks and regards,
Marco Bomben
--
"Human existence is based upon two pillars: Compassion and knowledge.
Compassion without knowledge is ineffective; knowledge without compassion is inhuman."
(Victor Frederick Weisskopf)
----------------------------------------------
http://marco.bomben.googlepages.com/
I look into mails-archive but I didn't find any hint for this question: is there a way to retrieve the timestamp of the creation/last modification of a row in a table?
Many thanks and regards,
Marco Bomben
--
"Human existence is based upon two pillars: Compassion and knowledge.
Compassion without knowledge is ineffective; knowledge without compassion is inhuman."
(Victor Frederick Weisskopf)
----------------------------------------------
http://marco.bomben.googlepages.com/
On 24 May 2010 13:09, Marco Bomben <marco.bomben@gmail.com> wrote: > Dear all, > I look into mails-archive but I didn't find any hint for this > question: is there a way to retrieve the timestamp of the creation/last > modification of a row in a table? > > Many thanks and regards, > Marco Bomben > I don't believe there is. I wanted to do something similar, but the only way I found of doing it was to create a trigger on the table which updates a timestamp column on the row being updated. Regards Thom
Dear Thom,
thanks for the suggestion. I will look for 'trigger' into documentation.
Regards,
Marco
--
"Human existence is based upon two pillars: Compassion and knowledge.
Compassion without knowledge is ineffective; knowledge without compassion is inhuman."
(Victor Frederick Weisskopf)
----------------------------------------------
http://marco.bomben.googlepages.com/
thanks for the suggestion. I will look for 'trigger' into documentation.
Regards,
Marco
On 24 May 2010 13:09, Marco Bomben <marco.bomben@gmail.com> wrote:I don't believe there is. I wanted to do something similar, but the
> Dear all,
> I look into mails-archive but I didn't find any hint for this
> question: is there a way to retrieve the timestamp of the creation/last
> modification of a row in a table?
>
> Many thanks and regards,
> Marco Bomben
>
only way I found of doing it was to create a trigger on the table
which updates a timestamp column on the row being updated.
Regards
Thom
--
"Human existence is based upon two pillars: Compassion and knowledge.
Compassion without knowledge is ineffective; knowledge without compassion is inhuman."
(Victor Frederick Weisskopf)
----------------------------------------------
http://marco.bomben.googlepages.com/
Marco Bomben wrote: > Dear all, > I look into mails-archive but I didn't find any hint for > this question: is there a way to retrieve the timestamp of the > creation/last modification of a row in a table? Of course there is. You should create an auditing trigger to record the time of the modification, the primary key of the row that was modified and the nature of the modification itself. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com