{"id":971,"date":"2015-09-07T12:35:54","date_gmt":"2015-09-07T12:35:54","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=971"},"modified":"2015-09-07T13:29:52","modified_gmt":"2015-09-07T13:29:52","slug":"common-errors-in-oracle","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/common-errors-in-oracle\/","title":{"rendered":"Common Errors in Oracle"},"content":{"rendered":"<p>The data you are trying to insert already exists and its a primary key with unique value<\/p>\n<pre>\r\n unique constraint (DATABASENAME.PK_COLUMN_NAME) violated\r\n<\/pre>\n<p>When you try to insert some value which are not allowed for the column this error is thrown.Similar to ENUM of Java.<\/p>\n<p>In the below example CATEGORY Column may have MALE and FEMALE But when you try to insert BOTH this is going to throw  error since it is not allowed value.<\/p>\n<pre>\r\nCATEGORY IN ('MALE','FEMALE')\r\n<\/pre>\n<pre>\r\ncheck constraint (DATABASENAME.CHK_CATEGORY) violated\r\n<\/pre>\n<p>If the Parent table referred by Foreign Key does not have the value then this is thrown<\/p>\n<pre>\r\nintegrity constraint (DATABASENAME.FK_CATEGORY) violated - parent key not found\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>The data you are trying to insert already exists and its a primary key with unique value unique constraint (DATABASENAME.PK_COLUMN_NAME) violated When you try to insert some value which are not allowed for the column this error is thrown.Similar to ENUM of Java. In the below example CATEGORY Column may have MALE and FEMALE But&hellip; <a href=\"https:\/\/codethataint.com\/blog\/common-errors-in-oracle\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[166],"tags":[],"class_list":["post-971","post","type-post","status-publish","format-standard","hentry","category-errors"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=971"}],"version-history":[{"count":6,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/971\/revisions"}],"predecessor-version":[{"id":977,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/971\/revisions\/977"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}