{"id":55963,"date":"2024-03-14T08:52:29","date_gmt":"2024-03-14T08:52:29","guid":{"rendered":"https:\/\/dbtut.com\/?p=55963"},"modified":"2024-03-14T08:54:27","modified_gmt":"2024-03-14T08:54:27","slug":"make-a-flashback-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/","title":{"rendered":"Make A Flashback Database"},"content":{"rendered":"

In today’s article, we will learn how to create a Flashback Database with the help of commands.<\/p>\n

1. We check the existing data of the table on which Logical Corruption will be performed.<\/p>\n

\t[Primary-1] SQL> select * from hr.locations;\r\n\t\r\n\tLOCATION_ID STREET_ADDRESS                           POSTAL_CODE  CITY                           STATE_PROVINCE            CO\r\n\t----------- ---------------------------------------- ------------ ------------------------------ ------------------------- --\r\n\t       1200 2017 Shinjuku-ku                         1689         Tokyo                          Tokyo Prefecture          JP\r\n\t       1300 9450 Kamiya-cho                          6823         Hiroshima                                                JP\r\n\t       1400 2014 Jabberwocky Rd                      26192        Southlake                      Texas                     US\r\n\t       1500 2011 Interiors Blvd                      99236        South San Francisco            California                US\r\n\t       1600 2007 Zagora St                           50090        South Brunswick                New Jersey                US\r\n\t       1700 2004 Charade Rd                          98199        Seattle                        Washington                US\r\n\t       1800 147 Spadina Ave                          M5V 2L7      Toronto                        Ontario                   CA\r\n\t       1900 6092 Boxwood St                          YSW 9T2      Whitehorse                     Yukon                     CA\r\n\t       2000 40-5-12 Laogianggen                      190518       Beijing                                                  CN\r\n\t       2100 1298 Vileparle (E)                       490231       Bombay                         Maharashtra               IN\r\n\t       2200 12-98 Victoria Street                    2901         Sydney                         New South Wales           AU\r\n\t\r\n\tLOCATION_ID STREET_ADDRESS                           POSTAL_CODE  CITY                           STATE_PROVINCE            CO\r\n\t----------- ---------------------------------------- ------------ ------------------------------ ------------------------- --\r\n\t       2400 8204 Arthur St                                        London                                                   UK\r\n\t       2500 Magdalen Centre, The Oxford Science Park OX9 9ZB      Oxford                         Oxford                    UK\r\n\t       2600 9702 Chester Road                        09629850293  Stretford                      Manchester                UK\r\n\t       2700 Schwanthalerstr. 7031                    80925        Munich                         Bavaria                   DE\r\n\t       2800 Rua Frei Caneca 1360                     01307-002    Sao Paulo                      Sao Paulo                 BR\r\n\t       2900 20 Rue des Corps-Saints                  1730         Geneva                         Geneve                    CH\r\n\t       3000 Murtenstrasse 921                        3095         Bern                           BE                        CH\r\n\t       3100 Pieter Breughelstraat 837                3029SK       Utrecht                        Utrecht                   NL\r\n\t       3200 Mariano Escobedo 9991                    11932        Mexico City                    Distrito Federal,         MX\r\n\t\r\n20 rows selected.<\/pre>\n
2. We create a restore point before the transaction is performed.<\/p>\n
\t11:24:37 [Primary-1] SQL> create restore point delete_locations;\r\n\t\r\nRestore point created.<\/pre>\n
3. We are learning SCN.<\/p>\n
\t11:25:07 [Primary-1] SQL> select current_scn from v$database;\r\n\t\r\n\tCURRENT_SCN\r\n\t-----------\r\n\t   20608714\r\n<\/pre>\n
4. We perform deletion.<\/p>\n
\t11:25:58 [Primary-1] SQL> delete hr.locations where location_id like '3%';\r\n\t\r\n\t3 rows deleted.\r\n\t\r\n\t11:26:11 [Primary-1] SQL> commit;\r\n\t\r\nCommit complete.<\/pre>\n
5. We close the database.<\/p>\n
\t11:27:30 [Primary-1] SQL> ! srvctl stop database -d primary\r\n<\/pre>\n
6. The database opens in MOUNT mode.<\/p>\n
\t11:28:03 [Primary-1] SQL> ! srvctl start database -d primary -o mount\r\n\t[Primary-1] SQL> select status from gv$instance;\r\n\t\r\n\tSTATUS\r\n\t------------\r\n\tMOUNTED\r\n\tMOUNTED\r\n<\/pre>\n
7. Flashback Database is created.<\/p>\n
\t[Primary-1] SQL> flashback database to restore point delete_locations;\r\n\t\r\n\tFlashback complete.\r\n<\/pre>\n
8. By opening the database read only, it is checked whether the deleted data has been retrieved or not.<\/p>\n
\t[Primary-1] SQL> alter database open read only;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Primary-1] SQL> set linesize 9000\r\n\t[Primary-1] SQL> select * from hr.locations;\r\n\t\r\n\tLOCATION_ID STREET_ADDRESS                           POSTAL_CODE  CITY                           STATE_PROVINCE            CO\r\n\t----------- ---------------------------------------- ------------ ------------------------------ ------------------------- --\r\n\t       1200 2017 Shinjuku-ku                         1689         Tokyo                          Tokyo Prefecture          JP\r\n\t       1300 9450 Kamiya-cho                          6823         Hiroshima                                                JP\r\n\t       1400 2014 Jabberwocky Rd                      26192        Southlake                      Texas                     US\r\n\t       1500 2011 Interiors Blvd                      99236        South San Francisco            California                US\r\n\t       1600 2007 Zagora St                           50090        South Brunswick                New Jersey                US\r\n\t       1700 2004 Charade Rd                          98199        Seattle                        Washington                US\r\n\t       1800 147 Spadina Ave                          M5V 2L7      Toronto                        Ontario                   CA\r\n\t       1900 6092 Boxwood St                          YSW 9T2      Whitehorse                     Yukon                     CA\r\n\t       2000 40-5-12 Laogianggen                      190518       Beijing                                                  CN\r\n\t       2100 1298 Vileparle (E)                       490231       Bombay                         Maharashtra               IN\r\n\t       2200 12-98 Victoria Street                    2901         Sydney                         New South Wales           AU\r\n\t\r\n\tLOCATION_ID STREET_ADDRESS                           POSTAL_CODE  CITY                           STATE_PROVINCE            CO\r\n\t----------- ---------------------------------------- ------------ ------------------------------ ------------------------- --\r\n\t       2400 8204 Arthur St                                        London                                                   UK\r\n\t       2500 Magdalen Centre, The Oxford Science Park OX9 9ZB      Oxford                         Oxford                    UK\r\n\t       2600 9702 Chester Road                        09629850293  Stretford                      Manchester                UK\r\n\t       2700 Schwanthalerstr. 7031                    80925        Munich                         Bavaria                   DE\r\n\t       2800 Rua Frei Caneca 1360                     01307-002    Sao Paulo                      Sao Paulo                 BR\r\n\t       2900 20 Rue des Corps-Saints                  1730         Geneva                         Geneve                    CH\r\n\t       3000 Murtenstrasse 921                        3095         Bern                           BE                        CH\r\n\t       3100 Pieter Breughelstraat 837                3029SK       Utrecht                        Utrecht                   NL\r\n\t       3200 Mariano Escobedo 9991                    11932        Mexico City                    Distrito Federal,         MX\r\n\t\r\n20 rows selected.<\/pre>\n
9. The database is closed and opened with RESETLOGS.<\/p>\n
\t[Primary-1] SQL> shu immediate;\r\n\tDatabase closed.\r\n\tDatabase dismounted.\r\n\tORACLE instance shut down.\r\n\t[Primary-1] SQL> startup mount;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area 5428244480 bytes\r\n\tFixed Size                  2262856 bytes\r\n\tVariable Size            1124075704 bytes\r\n\tDatabase Buffers         4294967296 bytes\r\n\tRedo Buffers                6938624 bytes\r\n\tDatabase mounted.\r\n\t[Primary-1] SQL> alter database open resetlogs;\r\n\t\r\n\tDatabase altered.\r\n<\/pre>\n
10. Other instances are also opened.<\/p>\n
\t[Primary-2] SQL> startup mount;\r\n\tORACLE instance started.\r\n\t\r\n\tTotal System Global Area 5428244480 bytes\r\n\tFixed Size                  2262856 bytes\r\n\tVariable Size            1124075704 bytes\r\n\tDatabase Buffers         4294967296 bytes\r\n\tRedo Buffers                6938624 bytes\r\n\tDatabase mounted.\r\n\t[Primary-2] SQL> alter database open;\r\n\t\r\n\tDatabase altered.\r\n\t\r\n\t[Primary-2] SQL> select status from gv$instance;\r\n\t\r\n\tSTATUS\r\n\t------------\r\n\tOPEN\r\n\tOPEN\r\n<\/pre>\n
11. Other Flashback commands.<\/p>\n
\t[Primary-1] SQL> flashback database to scn ...;\r\n\t[Primary-1] SQL> flashback database to timestamp to_timestamp('23-05-2018 10:00:00','DD-MM-YYYY HH24:MI:SS');\r\n\t[Primary-1] SQL> flashback database to timestamp (SYSDATE -1\/24);\r\n<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will learn how to create a Flashback Database with the help of commands. 1. We check the existing data of the table on which Logical Corruption will be performed. [Primary-1] SQL> select * from hr.locations; LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE CO ———– —————————————- ———— —————————— ————————- — 1200 2017 Shinjuku-ku 1689 …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":55964,"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-55963","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nMake A Flashback Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will learn how to create a Flashback Database with the help of commands.\" \/>\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\/03\/14\/make-a-flashback-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Make A Flashback Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will learn how to create a Flashback Database with the help of commands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T08:52:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T08:54:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png\" \/>\n\t<meta property=\"og:image:width\" content=\"704\" \/>\n\t<meta property=\"og:image:height\" content=\"294\" \/>\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\/03\/14\/make-a-flashback-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Make A Flashback Database\",\"datePublished\":\"2024-03-14T08:52:29+00:00\",\"dateModified\":\"2024-03-14T08:54:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\"},\"wordCount\":101,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\",\"name\":\"Make A Flashback Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png\",\"datePublished\":\"2024-03-14T08:52:29+00:00\",\"dateModified\":\"2024-03-14T08:54:27+00:00\",\"description\":\"In today's article, we will learn how to create a Flashback Database with the help of commands.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png\",\"width\":704,\"height\":294},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Make A Flashback 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":"Make A Flashback Database - Database Tutorials","description":"In today's article, we will learn how to create a Flashback Database with the help of commands.","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\/03\/14\/make-a-flashback-database\/","og_locale":"en_US","og_type":"article","og_title":"Make A Flashback Database - Database Tutorials","og_description":"In today's article, we will learn how to create a Flashback Database with the help of commands.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/","og_site_name":"Database Tutorials","article_published_time":"2024-03-14T08:52:29+00:00","article_modified_time":"2024-03-14T08:54:27+00:00","og_image":[{"width":704,"height":294,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.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\/03\/14\/make-a-flashback-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Make A Flashback Database","datePublished":"2024-03-14T08:52:29+00:00","dateModified":"2024-03-14T08:54:27+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/"},"wordCount":101,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/","url":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/","name":"Make A Flashback Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png","datePublished":"2024-03-14T08:52:29+00:00","dateModified":"2024-03-14T08:54:27+00:00","description":"In today's article, we will learn how to create a Flashback Database with the help of commands.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/03\/Ekran-goruntusu-2024-03-14-115123.png","width":704,"height":294},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/03\/14\/make-a-flashback-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Make A Flashback 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\/55963","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=55963"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55963\/revisions"}],"predecessor-version":[{"id":55965,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55963\/revisions\/55965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55964"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}