Thanks Mike, I'll move forward with the trigger. I read somewhere that you could convert the ora_rowscn to a timestamp, but it seemed like it was inconsistent at best.
Thanks again! On Tue, Jul 20, 2010 at 1:43 PM, Michael Moore <michaeljmo...@gmail.com>wrote: > I think a trigger will be your best. We have several tables where we want > the updated_date column to truly reflect the date when that record was last > updated. We don't trust each application program to set updated_date to > sysdate, so we do it with a trigger. Frankly, I don't see how ora_rowscn > could solve your problem. > > Regards, > Mike > > > On Tue, Jul 20, 2010 at 1:00 PM, Clay Colburn <clay.colb...@gmail.com>wrote: > >> The refactor to introduce a procedure wrapper is not really feasible at >> this point, but that method could definitely be used on new objects. Are >> there any other alternatives that are more native to the table object itself >> beyond the procedure wrapper or trigger? >> >> Thanks. >> >> >> On Tue, Jul 20, 2010 at 12:47 PM, Michael Moore >> <michaeljmo...@gmail.com>wrote: >> >>> 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 >>> >> >> -- >> 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 > -- 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
