{"id":3149,"date":"2003-12-01T10:43:46","date_gmt":"2003-12-01T10:43:46","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3149"},"modified":"2021-07-12T12:06:32","modified_gmt":"2021-07-12T12:06:32","slug":"some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/","title":{"rendered":"Some object features of Oracle PL \/ SQL 9i language"},"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\">In 1997, Oracle Corporation announced new version of his DBMS, called Oracle 8.0 Object-Relational database. PL\/SQL programming language (as well as SQL) was upgraded with new &#8220;object&#8221; features. But Oracle 8.0, and the following Oracle 8i version with Java capabilities, did not have all expected and important object features e.g. inheritance, overriding, polymorphism. During 2001 all that features are added in Oracle 9i. In the article are shown some object features of Oracle PL\/SQL 9i R2 programming language but without SQL object features (how to work with transient and not with persistent objects is shown). So comparison PL\/SQL with other popular object languages (C++, Java, Eiffel) is possible.<\/p>\n\n\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2003\/12\/case2003.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Comparison with OOPL languages C ++, Eiffel and Java<\/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,329,330],"tags":[],"class_list":["post-3149","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-case-en","category-conferences"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Some object features of Oracle PL \/ SQL 9i language &#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\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Some object features of Oracle PL \/ SQL 9i language &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"Comparison with OOPL languages C ++, Eiffel and Java\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2003-12-01T10:43:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-12T12:06:32+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\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:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"Some object features of Oracle PL \\\/ SQL 9i language\",\"datePublished\":\"2003-12-01T10:43:46+00:00\",\"dateModified\":\"2021-07-12T12:06:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/\"},\"wordCount\":122,\"commentCount\":0,\"articleSection\":[\"Blog\",\"CASE\",\"Conferences\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/\",\"name\":\"Some object features of Oracle PL \\\/ SQL 9i language &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2003-12-01T10:43:46+00:00\",\"dateModified\":\"2021-07-12T12:06:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Some object features of Oracle PL \\\/ SQL 9i language\"}]},{\"@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":"Some object features of Oracle PL \/ SQL 9i language &#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\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/","og_locale":"en_US","og_type":"article","og_title":"Some object features of Oracle PL \/ SQL 9i language &#8211; Istra Tech","og_description":"Comparison with OOPL languages C ++, Eiffel and Java","og_url":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/","og_site_name":"Istra Tech","article_published_time":"2003-12-01T10:43:46+00:00","article_modified_time":"2021-07-12T12:06:32+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"Some object features of Oracle PL \/ SQL 9i language","datePublished":"2003-12-01T10:43:46+00:00","dateModified":"2021-07-12T12:06:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/"},"wordCount":122,"commentCount":0,"articleSection":["Blog","CASE","Conferences"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/","url":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/","name":"Some object features of Oracle PL \/ SQL 9i language &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2003-12-01T10:43:46+00:00","dateModified":"2021-07-12T12:06:32+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/some-object-features-of-oracle-pl-sql-9i-language-comparison-with-oopl-languages-c-eiffel-and-java\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"Some object features of Oracle PL \/ SQL 9i language"}]},{"@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\/3149","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=3149"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3149\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}