{"id":56563,"date":"2024-08-05T09:57:43","date_gmt":"2024-08-05T09:57:43","guid":{"rendered":"https:\/\/dbtut.com\/?p=56563"},"modified":"2024-08-05T10:00:18","modified_gmt":"2024-08-05T10:00:18","slug":"deferrable-primary-key-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/","title":{"rendered":"Deferrable Primary Key In Oracle"},"content":{"rendered":"

In today’s article, we may want it to come into play later when defining the Primary Key. For this, we will learn how to use “DEFERRABLE INITIALLY DEFERRED”.<\/p>\n

But this does not mean that I will be able to add inconsistent data to the table. Yes, it can be added, but it will not be made permanent.<\/p>\n

The reason is that in the worst case scenario, the primary key will come into play after the session is closed and will act in this way to eliminate the inconsistency.<\/p>\n

Let’s create a new table.<\/strong><\/p>\n

CREATE TABLE HAMZA8\r\n(\r\nCUST_ID8 NUMBER(2),\r\nCUST_NAME8 VARCHAR2 (15)\r\n);<\/pre>\n
Then I will add a primary key to the cust_id field in this table, but I won’t put it into effect right away.<\/p>\n
ALTER TABLE HAMZA8 ADD CONSTRAINT CUST_ID_PK8 PRIMARY KEY (CUST_ID8) DEFERRABLE INITIALLY DEFERRED;<\/pre>\n
Then I try to insert things into the table that violate the primary key.<\/p>\n
INSERT INTO HAMZA8 VALUES (1,'onur');\r\nINSERT INTO HAMZA8 VALUES (1,'burcu');\r\ncommit;<\/pre>\n
It will do the first insert successfully.<\/p>\n
It will do the second insert successfully.<\/p>\n
When I press Commit, I get an error like the one below.<\/p>\n
\"\"<\/p>\n
The disabled constraint is enabled as follows.<\/p>\n
set constraint cust_id_pk8 immediate;<\/pre>\n
Afterwards, when I try new inserts, if it finds any contradictions, it will give an error at the insertion stage.<\/p>\n
INSERT INTO HAMZA8 VALUES (1,'ahmet');\r\nINSERT INTO HAMZA8 VALUES (1,'onur');<\/pre>\n
\"\"<\/p>\n
Commit;<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we may want it to come into play later when defining the Primary Key. For this, we will learn how to use “DEFERRABLE INITIALLY DEFERRED”. But this does not mean that I will be able to add inconsistent data to the table. Yes, it can be added, but it will not be …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":56567,"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-56563","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nDeferrable Primary Key In Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use "DEFERRABLE INITIALLY DEFERRED".\" \/>\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\/08\/05\/deferrable-primary-key-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deferrable Primary Key In Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use "DEFERRABLE INITIALLY DEFERRED".\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-05T09:57:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-05T10:00:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png\" \/>\n\t<meta property=\"og:image:width\" content=\"807\" \/>\n\t<meta property=\"og:image:height\" content=\"318\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Deferrable Primary Key In Oracle\",\"datePublished\":\"2024-08-05T09:57:43+00:00\",\"dateModified\":\"2024-08-05T10:00:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\"},\"wordCount\":190,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\",\"name\":\"Deferrable Primary Key In Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png\",\"datePublished\":\"2024-08-05T09:57:43+00:00\",\"dateModified\":\"2024-08-05T10:00:18+00:00\",\"description\":\"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use \\\"DEFERRABLE INITIALLY DEFERRED\\\".\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png\",\"width\":807,\"height\":318},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deferrable Primary Key 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\/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":"Deferrable Primary Key In Oracle - Database Tutorials","description":"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use \"DEFERRABLE INITIALLY DEFERRED\".","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\/08\/05\/deferrable-primary-key-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Deferrable Primary Key In Oracle - Database Tutorials","og_description":"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use \"DEFERRABLE INITIALLY DEFERRED\".","og_url":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2024-08-05T09:57:43+00:00","article_modified_time":"2024-08-05T10:00:18+00:00","og_image":[{"width":807,"height":318,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Deferrable Primary Key In Oracle","datePublished":"2024-08-05T09:57:43+00:00","dateModified":"2024-08-05T10:00:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/"},"wordCount":190,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/","name":"Deferrable Primary Key In Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png","datePublished":"2024-08-05T09:57:43+00:00","dateModified":"2024-08-05T10:00:18+00:00","description":"We may want it to come into play later when defining the Primary Key. For this, we will learn how to use \"DEFERRABLE INITIALLY DEFERRED\".","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/08\/Ekran-goruntusu-2024-08-05-125534.png","width":807,"height":318},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/08\/05\/deferrable-primary-key-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Deferrable Primary Key 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\/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\/56563","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=56563"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56563\/revisions"}],"predecessor-version":[{"id":56568,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56563\/revisions\/56568"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56567"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}