Re: sysdate for each inserted row

In article <qa19et0s3eodijqqq905q02dvpvpecke34_at_4ax.com>, kilidire <yc_at_hwcn.org> writes:
>Hi all,
>When designing the table , I didn't include a date field for each
>inserted row. Is there a sysdate function that can be called to find
>the date at which a row was inserted ? Thanks all.

If the row has a column of date datatype that is populated with the sysdate function at the time of insert then you have this information, otherwise the answer is 'NO' as Oracle has no need for this information so it does not automatically store it.

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net