PS, SCN is related to the date last updated, not the date inserted. Mike On Fri, Jul 23, 2010 at 9:03 AM, Michael Moore <michaeljmo...@gmail.com>wrote:
> Normally the way to do this is to have a column named something like > created_date. This would be populated by the application or a trigger. > > Other than that you could try something like: > select scn_to_timestamp(ora_rowscn) from tx_language; > However, if the data is too old, i.e. more than 5 days or so, you will get. > > ORA-08181: specified number is not a valid system change number > ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 > > In that case you can do something like: > select ora_rowscn from tx_language; > > This will not give you a date, but it will give you a system change number. > If you have a different table with known created_date, you can try to find > that same system change number in that other table. If you find it, you will > know the a proximate date from your original table. > > Mike > > > > > > > On Fri, Jul 23, 2010 at 5:36 AM, Oras <deepan...@gmail.com> wrote: > >> Hi, >> >> I have a table named "Temp_Master" In that I want to list the records >> which were inserted on a particular date or today. Is it possible to >> get it?' >> >> Regards, >> DI >> >> -- >> 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