CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: last modified?

  1. August 22nd, 2007, 04:44 AM #1
    codeexpert123
    codeexpert123 is offline Junior Member
    Join Date
    Aug 2007
    Posts
    23

    last modified?

    Does anyone know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.
    www.coderewind.com
    Best Place to hunt for Code
    Reply With Quote Reply With Quote
  2. August 22nd, 2007, 05:33 AM #2
    andreasblixt
    andreasblixt is offline Member
    Join Date
    Jul 2007
    Location
    Sweden
    Posts
    331

    Re: last modified?

    If you are using Oracle 10g, this might be of interest:
    http://www.builderau.com.au/program/...9271944,00.htm

    Otherwise, add a column that holds a timestamp.
    Reply With Quote Reply With Quote
  3. August 23rd, 2007, 02:36 AM #3
    davide++
    davide++ is offline Member
    Join Date
    Jun 2006
    Posts
    437

    Re: last modified?

    Hi all.

    In addition what andreasblixt said, you might add a trigger on your table that updates the timestamp field during INSERT / UPDATE operations.
    Reply With Quote Reply With Quote
  4. September 8th, 2007, 06:26 AM #4
    codeexpert123
    codeexpert123 is offline Junior Member
    Join Date
    Aug 2007
    Posts
    23

    Re: last modified?

    Thanks for the reply.The problem is solved.
    www.coderewind.com
    Best Place to hunt for Code
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured