{"id":4742,"date":"2026-10-07T19:21:18","date_gmt":"2026-10-07T17:21:18","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/"},"modified":"2026-10-08T12:29:36","modified_gmt":"2026-10-08T10:29:36","slug":"oracle-database-plsql-fundamentals-2-program-units","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/","title":{"rendered":"Oracle Database PL\/SQL Fundamentals 2 Program Units"},"content":{"rendered":"<p>Deze module is bestemd voor de beheerder en ontwikkelaar van de Oracle Database en van applicaties in Oracle Forms en Reports Deze module verschaft de deelnemer kennis en vaardigheden in de procedurele programmeertaal PL\/SQL binnen de ontwikkeltools van Oracle. De cursist is in staat om na de cursus Database Triggers, Libraries, en Packages in PL\/SQL te maken en te gebruiken binnen de Oracle-tools. <\/p>\n<ul>\n<li>DML triggers\n<\/li>\n<li>Cre&#xEB;ren van Compound, DDL en Event Database triggers\n<\/li>\n<li>Maken van program units en libraries\n<\/li>\n<li>Packages\n<ul>\n<li>beschrijving,opbouw en eigenschappen van packages<\/li>\n<li>toegangsrechten<\/li>\n<li>Package functies en restricties<\/li>\n<\/ul>\n<\/li>\n<li>Dependent en Referenced Objecten\n<\/li>\n<li>Dynamic SQL\n<\/li>\n<li>Implementatie van en werken met Oracle packages\n<ul>\n<li>STANDARD, DBMS_OUTPUT, UTL_FILE, UTL_MAIL packages<\/li>\n<\/ul>\n<\/li>\n<li>Ontwerp overwegingen bij PL\/SQL code\n<ul>\n<li>Standaardisatie van constanten en exceptions<\/li>\n<li>Local Subprograms<\/li>\n<li>Autonomous Transactions<\/li>\n<li>NOCOPY compiler hint, PARALLEL_ENABLE hint, DETERMINISTIC functies<\/li>\n<li>Cross-section function result cache<\/li>\n<li>Performance verbetering met bulk binding<\/li>\n<\/ul>\n<\/li>\n<li>PL\/SQL compiler: Beschrijving, Instellingen en compiler warnings.\n<\/li>\n<li>Beheer van PL\/SQL code\n<ul>\n<li>Conditioneel Compileren<\/li>\n<li>Selectie, Inquiry en Compiler Error directieven<\/li>\n<li>Version management<\/li>\n<li>Bekijken en afdrukken van source code met DBMS_PREPROCESSOR procedures<\/li>\n<li>Code verbergen en inpakken<br \/>\nmet PL\/SQL wrapper<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p> Op deze module is geen aparte certificering van toepassing<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance.<\/p>\n<p>Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.<\/p>\n","protected":false},"featured_media":4746,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[506],"product_tag":[],"class_list":["post-4742","product","type-product","status-publish","has-post-thumbnail","product_cat-cb-klassikaal","first","instock","taxable","shipping-taxable","purchasable","product-type-variable"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Database PL\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database PL\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/\" \/>\n<meta property=\"og:site_name\" content=\"Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-08T10:29:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1672\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/\",\"name\":\"Oracle Database PL\\\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"datePublished\":\"2026-10-07T17:21:18+00:00\",\"dateModified\":\"2026-10-08T10:29:36+00:00\",\"description\":\"Verdiep je PL\\\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\\\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/#primaryimage\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"width\":1672,\"height\":941},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-2-program-units\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Products\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/shop\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Database PL\\\/SQL Fundamentals 2 Program Units\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"name\":\"Train IT Now | Netherlands\",\"description\":\"Opleidingen op gebied van IT\",\"publisher\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\"},\"alternateName\":\"Train IT Now B.V.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\",\"name\":\"Train IT Now B.V.\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"width\":846,\"height\":564,\"caption\":\"Train IT Now B.V.\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/p\\\/Train-it-Now-61573405935953\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/106495503\",\"https:\\\/\\\/www.instagram.com\\\/trainitnow\\\/\",\"https:\\\/\\\/nl.linkedin.com\\\/company\\\/train-it-now\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database PL\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands","description":"Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.","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:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/","og_locale":"nl_NL","og_type":"article","og_title":"Oracle Database PL\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands","og_description":"Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.","og_url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/","og_site_name":"Train IT Now B.V. | Netherlands","article_publisher":"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","article_modified_time":"2026-10-08T10:29:36+00:00","og_image":[{"width":1672,"height":941,"url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/","url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/","name":"Oracle Database PL\/SQL Fundamentals 2 Program Units | Train IT Now B.V. | Netherlands","isPartOf":{"@id":"https:\/\/trainitnow.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","datePublished":"2026-10-07T17:21:18+00:00","dateModified":"2026-10-08T10:29:36+00:00","description":"Verdiep je PL\/SQL skills en bouw krachtige Oracle-programmablokken met triggers, libraries en packages voor maximale herbruikbaarheid en performance. Deze cursus verdiept je kennis van PL\/SQL, de procedurele programmeertaal van Oracle, en richt zich op het ontwikkelen van geavanceerde programmablokken binnen Oracle-ontwikkeltools. Je leert hoe je krachtige en herbruikbare structuren bouwt met Database Triggers, Libraries en Packages.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/#primaryimage","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","width":1672,"height":941},{"@type":"BreadcrumbList","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-2-program-units\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trainitnow.com\/nl\/"},{"@type":"ListItem","position":2,"name":"Products","item":"https:\/\/trainitnow.com\/nl\/shop\/"},{"@type":"ListItem","position":3,"name":"Oracle Database PL\/SQL Fundamentals 2 Program Units"}]},{"@type":"WebSite","@id":"https:\/\/trainitnow.com\/nl\/#website","url":"https:\/\/trainitnow.com\/nl\/","name":"Train IT Now | Netherlands","description":"Opleidingen op gebied van IT","publisher":{"@id":"https:\/\/trainitnow.com\/nl\/#organization"},"alternateName":"Train IT Now B.V.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trainitnow.com\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/trainitnow.com\/nl\/#organization","name":"Train IT Now B.V.","url":"https:\/\/trainitnow.com\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","width":846,"height":564,"caption":"Train IT Now B.V."},"image":{"@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","https:\/\/www.linkedin.com\/company\/106495503","https:\/\/www.instagram.com\/trainitnow\/","https:\/\/nl.linkedin.com\/company\/train-it-now"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product\/4742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/comments?post=4742"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media\/4746"}],"wp:attachment":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media?parent=4742"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4742"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4742"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}