<div>
Out-of-the-box and/or without any effort, there is no way to determine that. You could either turn on Oracle's audit options or (which I prefer more), add some audit columns to your tables, like CREATE_TS (creation timestamp), CREATE_USER (creation user), CHANGE_TS, CHANGE_USER.... With the help of one or more trigger(s), you may fill in the data needed for INSERT, UPDATE, DELETE...
</div>


Out-of-the-box and/or without any effort, there is no way to determine that. You could either turn on Oracle's audit options or (which I prefer more), add some audit columns to your tables, like CREATE_TS (creation timestamp), CREATE_USER (creation user), CHANGE_TS, CHANGE_USER.... With the help of one or more trigger(s), you may fill in the data needed for INSERT, UPDATE, DELETE...

<div>
&gt;&gt;it was last updated or changed ?<br />
<br />
That is two possible questions:<br />
The last time DDL was performed?<br />
&nbsp; &nbsp;Depending on your Oracle version there was a LAST_DDL_TIME added to the &quot;_OBJECTS&quot; view (DBA, ALL or USER: &nbsp;USER_OBJECTS). &nbsp;<br />
The last time DML was performed?<br />
&nbsp; &nbsp;As suggested above: &nbsp;I would use Auditing or a trigger.
</div>


>>it was last updated or changed ?

That is two possible questions:
The last time DDL was performed?
   Depending on your Oracle version there was a LAST_DDL_TIME added to the "_OBJECTS" view (DBA, ALL or USER:  USER_OBJECTS).  
The last time DML was performed?
   As suggested above:  I would use Auditing or a trigger.

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
&nbsp;How do I know in Oracle SQL for specific table when ( the time ) it was last updated or changed ?<br />
<br />
Thanks
</div>
</div>


Dear Experts,

 How do I know in Oracle SQL for specific table when ( the time ) it was last updated or changed ?

Thanks

Oracle SQL table - Time for last update / Change

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.