{"id":13896,"date":"2019-12-18T06:34:46","date_gmt":"2019-12-18T06:34:46","guid":{"rendered":"https:\/\/dbtut.com\/?p=13896"},"modified":"2019-12-18T06:34:47","modified_gmt":"2019-12-18T06:34:47","slug":"how-to-find-the-last-modified-date-of-a-table-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/","title":{"rendered":"How To Find the Last Modified Date of a Table in Oracle"},"content":{"rendered":"<p>ORA_ROWSCN returns the SCN information for the last modified date of the row for each row in a table. You can use this pseudo-column to determine last update date of rows approximately.<\/p>\n<h2>CREATE TABLE By Specifying ROWDEPENDENCIES<\/h2>\n<p>For row-based change tracking, the relevant table should be created by specifying ROWDEPENDENCIES. If not specified, tables are created as NOROWDEPENDENCIES. Each row in tables created by specifying ROWDEPENDENCIES will contain an extra 6 bytes of data.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; create table a(id number,ad varchar(50)) ROWDEPENDENCIES;<\/pre>\n<h2>Query ORA_ROWSCN<\/h2>\n<p>ORA_ROWSCN information of the rows can be queried as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select to_char(ORA_ROWSCN),ID  from aduruoz.a;\n\nTO_CHAR(ORA_ROWSCN)\t\t\t ID\n-------------------------- -------\n1301894904749\t\t\t\t  1\n1301894900367\t\t\t\t  2\n1301894900627\t\t\t\t  3\n1301894903961\t\t\t\t  4\t\n<\/pre>\n<h2>Query Last Updated Date of a Table<\/h2>\n<p>The largest ORA_ROWSCN value will give you the last modified date.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select max(to_char(ORA_ROWSCN)) from aduruoz.a;\n\nMAX(TO_CHAR(ORA_ROWSCN))\n------------------------------------------------------------------------------------------------------------------------\n1301894904749<\/pre>\n<h2>Convert ORA_ROWSNC to Date<\/h2>\n<p>You can convert ORA_ROWSCN to date with the command below.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select scn_to_timestamp(1301894904749) as timestamp from dual;\n\nTIMESTAMP\n---------------------------------------------------------------------------\n28-MAY-19 02.36.32.000000000 PM<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13896\" class=\"pvc_stats all  \" data-element-id=\"13896\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ORA_ROWSCN returns the SCN information for the last modified date of the row for each row in a table. You can use this pseudo-column to determine last update date of rows approximately. CREATE TABLE By Specifying ROWDEPENDENCIES For row-based change tracking, the relevant table should be created by specifying ROWDEPENDENCIES. If not specified, tables are &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13896\" class=\"pvc_stats all  \" data-element-id=\"13896\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":13897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[5894,5893,5890,5889,5881,5892,5886,5887,5888,5885,5882,5891,5896,5895,5884,5883],"class_list":["post-13896","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-convert-ora_rowsnc-to-date","tag-create-table-by-specifying-rowdependencies","tag-how-to-check-last-updated-date-in-oracle","tag-how-to-check-the-last-updated-date-of-a-table-in-oracle","tag-how-to-find-the-last-modified-date-of-a-table-in-oracle","tag-how-to-get-last-updated-date-in-oracle","tag-last-updated-date-of-a-table","tag-last-updated-date-of-a-table-in-oracle","tag-last-updated-time-of-a-table-in-oracle","tag-norowdependencies","tag-ora_rowscn","tag-oracle-last_update_date","tag-query-last-updated-date-of-a-table","tag-query-ora_rowscn","tag-rowdependencies","tag-what-is-ora_rowscn"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Find the Last Modified Date of a Table in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find the Last Modified Date of a Table in Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find the Last Modified Date of a Table in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find the Last Modified Date of a Table in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-18T06:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-18T06:34:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png\" \/>\n\t<meta property=\"og:image:width\" content=\"633\" \/>\n\t<meta property=\"og:image:height\" content=\"363\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find the Last Modified Date of a Table in Oracle\",\"datePublished\":\"2019-12-18T06:34:46+00:00\",\"dateModified\":\"2019-12-18T06:34:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\"},\"wordCount\":138,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png\",\"keywords\":[\"Convert ORA_ROWSNC to Date\",\"CREATE TABLE By Specifying ROWDEPENDENCIES\",\"how to check last updated date in oracle\",\"how to check the last updated date of a table in oracle\",\"how to find the last modified date of a table in oracle\",\"how to get last updated date in oracle\",\"last updated date of a table\",\"last updated date of a table in oracle\",\"last updated time of a table in oracle\",\"NOROWDEPENDENCIES\",\"ORA_ROWSCN\",\"oracle last_update_date\",\"Query Last Updated Date of a Table\",\"Query ORA_ROWSCN\",\"ROWDEPENDENCIES\",\"What is ORA_ROWSCN\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\",\"name\":\"How To Find the Last Modified Date of a Table in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png\",\"datePublished\":\"2019-12-18T06:34:46+00:00\",\"dateModified\":\"2019-12-18T06:34:47+00:00\",\"description\":\"How To Find the Last Modified Date of a Table in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png\",\"width\":633,\"height\":363},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find the Last Modified Date of a Table in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Find the Last Modified Date of a Table in Oracle - Database Tutorials","description":"How To Find the Last Modified Date of a Table in Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Find the Last Modified Date of a Table in Oracle - Database Tutorials","og_description":"How To Find the Last Modified Date of a Table in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-18T06:34:46+00:00","article_modified_time":"2019-12-18T06:34:47+00:00","og_image":[{"width":633,"height":363,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find the Last Modified Date of a Table in Oracle","datePublished":"2019-12-18T06:34:46+00:00","dateModified":"2019-12-18T06:34:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/"},"wordCount":138,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png","keywords":["Convert ORA_ROWSNC to Date","CREATE TABLE By Specifying ROWDEPENDENCIES","how to check last updated date in oracle","how to check the last updated date of a table in oracle","how to find the last modified date of a table in oracle","how to get last updated date in oracle","last updated date of a table","last updated date of a table in oracle","last updated time of a table in oracle","NOROWDEPENDENCIES","ORA_ROWSCN","oracle last_update_date","Query Last Updated Date of a Table","Query ORA_ROWSCN","ROWDEPENDENCIES","What is ORA_ROWSCN"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/","name":"How To Find the Last Modified Date of a Table in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png","datePublished":"2019-12-18T06:34:46+00:00","dateModified":"2019-12-18T06:34:47+00:00","description":"How To Find the Last Modified Date of a Table in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-53.png","width":633,"height":363},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-find-the-last-modified-date-of-a-table-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find the Last Modified Date of a Table in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13896"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13896\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13897"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}