The ideal solution is to have a PL/SQL procedure as a wrapper for any table you want to insert or update. Unfortunately, most shops are not sufficiently organized to enforce this type of architecture.
See http://www.oracle.com/technology/oramag/oracle/08-sep/o58asktom.html <http://www.oracle.com/technology/oramag/oracle/08-sep/o58asktom.html>Mike. On Tue, Jul 20, 2010 at 12:40 PM, Clay C. <clay.colb...@gmail.com> wrote: > I would like to have a date column updated when the row is modified. > Basically I would like to see the same behavior as you get with a > "default sysdate" attribute on a date column when a new record is > inserted, but also on update. > > I'm aware of the following options to accomplish this: > 1. using the ora_rowscn > 2. using a trigger > > I would like to know if there is any other way to do this that doesn't > require either of the above. Both mysql and mssql provide a more > native solution to this problem and so I just assumed that oracle > would have something like this, but my internet searching isn't coming > up with anything. > > Thanks. > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
