{"id":3141,"date":"2002-12-01T10:20:45","date_gmt":"2002-12-01T10:20:45","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3141"},"modified":"2021-07-12T12:09:52","modified_gmt":"2021-07-12T12:09:52","slug":"three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/","title":{"rendered":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" style=\"text-align:center\"><strong>ABSTRACT<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are business rules that before version 8.0 of Oracle database could not be fully supported only on the database side, but needed &#8220;collaboration&#8221; between the client side and the database.   <br>Probably the simplest example of such a rule is:  <br>&#8220;The master instance must have at least one corresponding instance of the details &#8220;<br>(e.g. &#8220;DEPT must have at least one EMP&#8221;).<\/p>\n\n\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2002\/12\/hroug2002.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>There are business rules that before version 8.0 of Oracle database could not be fully supported only on the database side, but needed &#8220;collaboration&#8221; between the client side and the database. <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,330,327],"tags":[],"class_list":["post-3141","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-conferences","category-hroug-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"There are business rules that before version 8.0 of Oracle database could not be fully supported only on the database side, but needed &quot;collaboration&quot; between the client side and the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2002-12-01T10:20:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-12T12:09:52+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"THREE FROM III (3 PL \\\/ SQL solutions from the company Istria information engineering)\",\"datePublished\":\"2002-12-01T10:20:45+00:00\",\"dateModified\":\"2021-07-12T12:09:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/\"},\"wordCount\":78,\"commentCount\":0,\"articleSection\":[\"Blog\",\"Conferences\",\"HrOUG\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/\",\"name\":\"THREE FROM III (3 PL \\\/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2002-12-01T10:20:45+00:00\",\"dateModified\":\"2021-07-12T12:09:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"THREE FROM III (3 PL \\\/ SQL solutions from the company Istria information engineering)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech","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:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/","og_locale":"en_US","og_type":"article","og_title":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech","og_description":"There are business rules that before version 8.0 of Oracle database could not be fully supported only on the database side, but needed \"collaboration\" between the client side and the database.","og_url":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/","og_site_name":"Istra Tech","article_published_time":"2002-12-01T10:20:45+00:00","article_modified_time":"2021-07-12T12:09:52+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering)","datePublished":"2002-12-01T10:20:45+00:00","dateModified":"2021-07-12T12:09:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/"},"wordCount":78,"commentCount":0,"articleSection":["Blog","Conferences","HrOUG"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/","url":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/","name":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering) &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2002-12-01T10:20:45+00:00","dateModified":"2021-07-12T12:09:52+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/three-from-iii-three-pl-sql-solutions-from-the-company-istra-information-engineering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"THREE FROM III (3 PL \/ SQL solutions from the company Istria information engineering)"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=3141"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}