Re: How can i select the new(or newly updated) records if there is no timestamp filed in my table?

In article <93j8so$8hk$1_at_license1.unx.sas.com>,   "newshost.unx.sas.com" <bill.ding_at_sas.com> wrote:
> How can i select the new(or newly updated) records if there is no
 timestamp
> filed in my table of Oracle Database?
>
> Are there any Oracle system options that i can trace these records?Or
 exist
> other tools to help me?
>
> Thanks,
>
> Bill Ding,
> Oracle Developer
>
>

Tracking when and which records are updated/inserted is a programming problem. If this is needed, generally one would add a field for a creation/update timestamp, and add triggers to update this field during all inserts and updates.

In many databases, there is really little need to know who or when a row is updated. Within the design of any given table/object should be sufficient information to identify records. IMHO tracking when (and who) changes a record has only been useful when debugging the process and/or when the process was lacking in appropriate control. Generally, i have noticed it is often carried over from older system.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/