{"id":56509,"date":"2024-07-27T07:46:44","date_gmt":"2024-07-27T07:46:44","guid":{"rendered":"https:\/\/dbtut.com\/?p=56509"},"modified":"2024-07-27T07:51:41","modified_gmt":"2024-07-27T07:51:41","slug":"constraints-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/","title":{"rendered":"Constraints In Oracle"},"content":{"rendered":"

In today’s article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.<\/p>\n

Oracle provides us with great convenience in data integrity with PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK and NOT NULL constraints.<\/p>\n

All constraints in the database can be seen in detail from the DBA_CONSTRAINTS, ALL_CONSTRAINTS and USER_CONSTRAINTS views.<\/p>\n

The information of some columns in these views is as follows.<\/p>\n

Shows the type of Constraint.<\/strong><\/p>\n

C\u00a0(check constraint on a table),<\/p>\n

P\u00a0(primary key),<\/p>\n

U\u00a0(unique key),<\/p>\n

R\u00a0(referential integrity),<\/p>\n

V\u00a0(with check option, on a view),<\/p>\n

O\u00a0(with read only, on a view)<\/p>\n

R_OWNER:<\/strong> Used in constraint types of “Referential Integrity”.<\/p>\n

It shows the table to which the column is connected with PK.<\/p>\n

R_CONSTRAINT_NAME:<\/strong> Used in constraint types of “Referential Integrity”.<\/p>\n

It shows the constraint name of the column to which the column is connected with PK.<\/p>\n

DELETE_RULE:<\/strong> Used in constraint types of “Referential Integrity”.<\/p>\n

It specifies whether the FK column will be deleted if the PK column is deleted.<\/p>\n

DEFERRABLE:<\/strong> Indicates whether the constraint can be deferred.<\/p>\n

DEFERRED:<\/strong> Indicates whether the constraint will be deferred at the beginning.<\/p>\n

INDEX_OWNER:<\/strong> Used in PK and Unique Indexes.<\/p>\n

The name of the user who owns the index is displayed.<\/p>\n

INDEX_NAME:<\/strong> Used in PK and Unique Indexes.<\/p>\n

The name of the index is displayed.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In today’s article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database. Oracle provides us with great convenience in data integrity with PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK and NOT NULL constraints. All constraints in the database can be seen in detail from the DBA_CONSTRAINTS, ALL_CONSTRAINTS …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":484,"featured_media":56510,"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-56509","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nConstraints In Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.\" \/>\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\/07\/27\/constraints-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Constraints In Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-27T07:46:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-27T07:51:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png\" \/>\n\t<meta property=\"og:image:width\" content=\"767\" \/>\n\t<meta property=\"og:image:height\" content=\"305\" \/>\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\/07\/27\/constraints-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Constraints In Oracle\",\"datePublished\":\"2024-07-27T07:46:44+00:00\",\"dateModified\":\"2024-07-27T07:51:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\"},\"wordCount\":233,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\",\"name\":\"Constraints In Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png\",\"datePublished\":\"2024-07-27T07:46:44+00:00\",\"dateModified\":\"2024-07-27T07:51:41+00:00\",\"description\":\"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png\",\"width\":767,\"height\":305},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Constraints 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":"Constraints In Oracle - Database Tutorials","description":"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.","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\/07\/27\/constraints-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Constraints In Oracle - Database Tutorials","og_description":"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2024-07-27T07:46:44+00:00","article_modified_time":"2024-07-27T07:51:41+00:00","og_image":[{"width":767,"height":305,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.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\/07\/27\/constraints-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Constraints In Oracle","datePublished":"2024-07-27T07:46:44+00:00","dateModified":"2024-07-27T07:51:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/"},"wordCount":233,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/","name":"Constraints In Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png","datePublished":"2024-07-27T07:46:44+00:00","dateModified":"2024-07-27T07:51:41+00:00","description":"In today's article, we will be talking about how to use Constraints to ensure data integrity in the Oracle Database.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/07\/Ekran-goruntusu-2024-07-27-104416.png","width":767,"height":305},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/07\/27\/constraints-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Constraints 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\/56509","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=56509"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56509\/revisions"}],"predecessor-version":[{"id":56511,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56509\/revisions\/56511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56510"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}