{"id":55834,"date":"2024-02-13T17:05:11","date_gmt":"2024-02-13T17:05:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=55834"},"modified":"2024-02-13T17:07:46","modified_gmt":"2024-02-13T17:07:46","slug":"flashback-transaction-query-in-oracle-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/","title":{"rendered":"Flashback Transaction Query In Oracle Database"},"content":{"rendered":"

In today’s article, we will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.<\/p>\n

1. We query the data in the table to be changed.<\/p>\n

\t[Primary-2] SQL> select * from hr.regions;\r\n\t\r\n\t REGION_ID REGION_NAME\r\n\t---------- -------------------------\r\n\t         1 Europe\r\n\t         2 Americas\r\n\t         3 Asia\r\n         4 Middle East and Africa<\/pre>\n
2. DML operations occur on the table.<\/p>\n
\t[Primary-2] SQL> update hr.regions set region_name='Middle East' where region_id=4;\r\n\t\r\n\t1 row updated.\r\n\t\r\n\t[Primary-2] SQL> commit;\r\n\t\r\n\tCommit complete.\r\n\t\r\n\t[Primary-2] SQL> insert into hr.regions values (5,'Africa');\r\n\t\r\n\t1 row created.\r\n\t\r\n\t[Primary-2] SQL> commit;\r\n\t\r\nCommit complete.<\/pre>\n
3. SQL*Plus variable is set to see the time.<\/p>\n
\t[Primary-2] SQL> set time on\r\n<\/pre>\n
4. Observe how the data in the table changes.<\/p>\n
\t14:13:26 [Primary-2] SQL> select versions_xid xid,\r\n\t14:13:47   2    versions_operation operation,\r\n\t14:13:47   3    to_char(versions_starttime,'DD-MON-RR HH24:MI:SS') starttime,\r\n\t14:13:47   4    to_char(versions_endtime,'DD-MON-RR HH24:MI:SS') endtime,\r\n\t14:13:47   5    region_name\r\n\t14:13:47   6    from hr.regions\r\n\t14:13:47   7    versions between timestamp\r\n\t14:13:47   8    to_timestamp('23-MAY-18 14:05:00','DD-MON-RR HH24:MI:SS')\r\n\t14:13:47   9    and systimestamp\r\n\t14:13:47  10    where region_id in (4,5);\r\n\t\r\n\tXID              O STARTTIME                   ENDTIME                     REGION_NAME\r\n\t---------------- - --------------------------- --------------------------- -------------------------\r\n\t14000C0020220000 U 23-MAY-18 14:09:16                                      Middle East\r\n\t                                               23-MAY-18 14:09:16          Middle East and Africa\r\n\t11001F0028110000 I 23-MAY-18 14:09:59                                      Africa\r\n<\/pre>\n
5. New updates are made.<\/p>\n
\t14:16:33 [Primary-2] SQL> update hr.regions set region_name='Afrika' where region_id=5;\r\n\t\r\n\t1 row updated.\r\n\t\r\n\t14:17:32 [Primary-2] SQL> commit;\r\n\t\r\n\tCommit complete.\r\n<\/pre>\n
6. Let’s find out who made the changes and UNDO_SQL.<\/p>\n
\t14:17:34 [Primary-2] SQL> select versions_xid xid,\r\n\t14:17:50   2    versions_operation operation,\r\n\t14:17:50   3    to_char(versions_starttime,'DD-MON-RR HH24:MI:SS') starttime,\r\n\t14:17:50   4    to_char(versions_endtime,'DD-MON-RR HH24:MI:SS') endtime,\r\n\t14:17:50   5    region_name\r\n\t14:17:50   6    from hr.regions\r\n\t14:17:50   7    versions between timestamp\r\n\t14:17:50   8    to_timestamp('23-MAY-18 14:05:00','DD-MON-RR HH24:MI:SS')\r\n\t14:17:50   9    and systimestamp\r\n\t14:17:50  10    where region_id in (4,5);\r\n\t\r\n\tXID              O STARTTIME                   ENDTIME                     REGION_NAME\r\n\t---------------- - --------------------------- --------------------------- -------------------------\r\n\t14000C0020220000 U 23-MAY-18 14:09:15                                      Middle East\r\n\t                                               23-MAY-18 14:09:15          Middle East and Africa\r\n\t140003001B220000 U 23-MAY-18 14:17:32                                      Afrika\r\n\t11001F0028110000 I 23-MAY-18 14:09:59          23-MAY-18 14:17:32          Africa\r\n\t\r\n\t\r\n\t14:26:47 [Primary-2] SQL> column undo_sql format a50\r\n\t14:27:10 [Primary-2] SQL> select operation,\r\n\t14:27:38   2  logon_user,\r\n\t14:27:38   3  undo_sql\r\n\t14:27:38   4  from flashback_transaction_query\r\n\t14:27:38   5  where xid = HEXTORAW('140003001B220000'); \r\n\t\r\n\tOPERATION                        LOGON_USER                     UNDO_SQL\r\n\t-------------------------------- ------------------------------ --------------------------------------------------\r\n\tUNKNOWN                          SYS\r\n\tBEGIN                            SYS\r\n<\/pre>\n
The reason why OPERATION is UNKNOWN is because there is not enough UNDO data. For this reason, some parameters are set.<\/p>\n
7. Let’s set the parameters where we can see UNDO_SQL.<\/p>\n
\t14:27:39 [Primary-2] SQL> alter database add supplemental log data;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t14:29:23 [Primary-2] SQL> alter database add supplemental log data (primary key) columns;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t14:29:29 [Primary-2] SQL> alter database add supplemental log data (foreign key) columns ;\r\n\t\r\n\tDatabase altered.\r\n<\/pre>\n
8. A new DML is run.<\/p>\n
\t14:30:31 [Primary-2] SQL> update hr.regions set region_name='Africa' where region_id=5;\r\n\t\r\n\t1 row updated.\r\n\t\r\n\t14:30:37 [Primary-2] SQL> commit;\r\n\t\r\nCommit complete.<\/pre>\n
9. The changes made are questioned.<\/p>\n
\t14:30:41 [Primary-2] SQL> select versions_xid xid,\r\n\t14:30:47   2    versions_operation operation,\r\n\t14:30:47   3    to_char(versions_starttime,'DD-MON-RR HH24:MI:SS') starttime,\r\n\t14:30:47   4    to_char(versions_endtime,'DD-MON-RR HH24:MI:SS') endtime,\r\n\t14:30:47   5    region_name\r\n\t14:30:47   6    from hr.regions\r\n\t14:30:47   7    versions between timestamp\r\n\t14:30:47   8    to_timestamp('23-MAY-18 14:05:00','DD-MON-RR HH24:MI:SS')\r\n\t14:30:47   9    and systimestamp\r\n\t14:30:47  10    where region_id in (4,5);\r\n\t\r\n\tXID              O STARTTIME                   ENDTIME                     REGION_NAME\r\n\t---------------- - --------------------------- --------------------------- -------------------------\r\n\t14000C0020220000 U 23-MAY-18 14:09:15                                      Middle East\r\n\t                                               23-MAY-18 14:09:15          Middle East and Africa\r\n\t120008003B110000 U 23-MAY-18 14:30:37                                      Africa\r\n\t140003001B220000 U 23-MAY-18 14:17:33          23-MAY-18 14:30:37          Afrika\r\n11001F0028110000 I 23-MAY-18 14:09:59          23-MAY-18 14:17:33          Africa<\/pre>\n
10. UNDO_SQL is displayed.<\/p>\n
\t14:30:48 [Primary-2] SQL> select operation,\r\n\t14:31:10   2  logon_user,\r\n\t14:31:10   3  undo_sql\r\n\t14:31:10   4  from flashback_transaction_query\r\n\t14:31:10   5  where xid = HEXTORAW('120008003B110000'); \r\n\t\r\n\tOPERATION                        LOGON_USER                     UNDO_SQL\r\n\t-------------------------------- ------------------------------ --------------------------------------------------\r\n\tUPDATE                           SYS                            update \"HR\".\"REGIONS\" set \"REGION_NAME\" = 'Afrika'\r\n\t                                                                 where ROWID = 'AAAVS5AAFAAAACLAAA';\r\n\t\r\n\tBEGIN                            SYS\r\n<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries. 1. We query the data in the table to be changed. [Primary-2] SQL> select * from hr.regions; REGION_ID REGION_NAME ———- ————————- 1 Europe 2 Americas 3 Asia 4 Middle …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":55835,"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":[],"class_list":["post-55834","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nFlashback Transaction Query In Oracle Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.\" \/>\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\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flashback Transaction Query In Oracle Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-13T17:05:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T17:07:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png\" \/>\n\t<meta property=\"og:image:width\" content=\"757\" \/>\n\t<meta property=\"og:image:height\" content=\"288\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\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\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Flashback Transaction Query In Oracle Database\",\"datePublished\":\"2024-02-13T17:05:11+00:00\",\"dateModified\":\"2024-02-13T17:07:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\"},\"wordCount\":124,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\",\"name\":\"Flashback Transaction Query In Oracle Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png\",\"datePublished\":\"2024-02-13T17:05:11+00:00\",\"dateModified\":\"2024-02-13T17:07:46+00:00\",\"description\":\"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png\",\"width\":757,\"height\":288},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flashback Transaction Query In Oracle Database\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flashback Transaction Query In Oracle Database - Database Tutorials","description":"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.","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\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Flashback Transaction Query In Oracle Database - Database Tutorials","og_description":"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/","og_site_name":"Database Tutorials","article_published_time":"2024-02-13T17:05:11+00:00","article_modified_time":"2024-02-13T17:07:46+00:00","og_image":[{"width":757,"height":288,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Flashback Transaction Query In Oracle Database","datePublished":"2024-02-13T17:05:11+00:00","dateModified":"2024-02-13T17:07:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/"},"wordCount":124,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/","url":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/","name":"Flashback Transaction Query In Oracle Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png","datePublished":"2024-02-13T17:05:11+00:00","dateModified":"2024-02-13T17:07:46+00:00","description":"We will explain the use of the Flashback transaction query to get extra information about the transactions listed by the flashback version queries.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-13-200332.png","width":757,"height":288},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/13\/flashback-transaction-query-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Flashback Transaction Query In Oracle Database"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55834","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=55834"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55834\/revisions"}],"predecessor-version":[{"id":55836,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55834\/revisions\/55836"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55835"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}