https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686584#M37100 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/76331">@alepage</a>&nbsp; - Check the schema of the table. Does it have column recording when that row was updated? If not as&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/339357">@CurtisMackWSIPP</a>&nbsp;says, Oracle system tables can provide a last updated date.</P> <P>&nbsp;</P> <P>A simple google search found this:&nbsp;<A href="https://stackoverflow.com/questions/265122/how-to-find-out-when-an-oracle-table-was-updated-the-last-time" target="_blank">https://stackoverflow.com/questions/265122/how-to-find-out-when-an-oracle-table-was-updated-the-last-time</A></P> <P>&nbsp;</P> Fri, 25 Sep 2020 00:36:04 GMT SASKiwi 2020-09-25T00:36:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686544#M37098 <P>Hello,</P> <P>&nbsp;</P> <P>I am using SAS EG 7.13&nbsp; and I need to extract some information tomorrow morning.</P> <P>However before excuting the sas program, I would like to check if the oracle table was udpdated and when.</P> <P>&nbsp;</P> <P>Just suppose that the database name is DB1 and table is Table10. Our environment is unix.</P> <P>Thanks in advance for your help.</P> Thu, 24 Sep 2020 21:41:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686544#M37098 alepage 2020-09-24T21:41:10Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686547#M37099 <P>I am afraid that is a question for Oracle.&nbsp; You might be able to get it from one of the Oracle system tables.</P> Thu, 24 Sep 2020 21:50:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686547#M37099 CurtisMackWSIPP 2020-09-24T21:50:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686584#M37100 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/76331">@alepage</a>&nbsp; - Check the schema of the table. Does it have column recording when that row was updated? If not as&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/339357">@CurtisMackWSIPP</a>&nbsp;says, Oracle system tables can provide a last updated date.</P> <P>&nbsp;</P> <P>A simple google search found this:&nbsp;<A href="https://stackoverflow.com/questions/265122/how-to-find-out-when-an-oracle-table-was-updated-the-last-time" target="_blank">https://stackoverflow.com/questions/265122/how-to-find-out-when-an-oracle-table-was-updated-the-last-time</A></P> <P>&nbsp;</P> Fri, 25 Sep 2020 00:36:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-check-when-an-oracle-table-was-updated/m-p/686584#M37100 SASKiwi 2020-09-25T00:36:04Z