{"id":4116,"date":"2022-05-19T09:15:45","date_gmt":"2022-05-19T08:15:45","guid":{"rendered":"https:\/\/republify.se\/?post_type=product&#038;p=4116"},"modified":"2025-08-18T14:01:27","modified_gmt":"2025-08-18T13:01:27","slug":"oracle-database-pl-sql-fundamentals","status":"publish","type":"product","link":"https:\/\/republify.se\/index.php\/produkt\/oracle-database-pl-sql-fundamentals\/","title":{"rendered":"Oracle Database: PL\/SQL Fundamentals"},"content":{"rendered":"<p><strong>This Oracle Database: PL\/SQL Fundamentals training introduces you to PL\/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.<\/strong><\/p>\n<p>In this course, you&#8217;ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You&#8217;ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.<\/p>\n<p>Learn To:<\/p>\n<ul>\n<li>Describe the features and syntax of PL\/SQL.<\/li>\n<li>Design a PL\/SQL anonymous block that executes efficiently.<\/li>\n<li>Write PL\/SQL code to interface with the database.<\/li>\n<li>Use PL\/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors<\/li>\n<li>Handle runtime errors.<\/li>\n<li>Describe stored procedures and functions.<\/li>\n<li>Apply declaring identifiers and trapping exceptions.<\/li>\n<li>Create PL\/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.<\/li>\n<\/ul>\n<h3><strong>Benefits to You<\/strong><\/h3>\n<p>Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.<\/p>\n<p>Gain Experience through Hands-On Practice<\/p>\n<p>&nbsp;<\/p>\n<h3>Audience<\/h3>\n<ul>\n<li>PL\/SQL Developer<\/li>\n<li>System Analysts<\/li>\n<li>Technical Consultant<\/li>\n<li>Forms Developer<\/li>\n<li>Portal Developer<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div>\n<h3 class=\"h2\">Prerequisites<\/h3>\n<div class=\"donotcrop\">\n<div>\n<ul>\n<li>Familiarity with data processing concepts and technique<\/li>\n<li>Familiarity with programming languages<\/li>\n<\/ul>\n<ul>\n<li><a class=\"prerequisiteLink\" href=\"http:\/\/education.oracle.com\/pls\/web_prod-plq-dad\/db_pages.getCourseDescRedesign?dc=D80174GC10\" shape=\"rect\">Oracle Database 12c: Introduction to SQL Ed 1.1<\/a><\/li>\n<\/ul>\n<p>Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our\u00a0<a href=\"https:\/\/www.qa.com\/legal\/partner-data-sharing-statement\">QA Partner data sharing page<\/a>. If you have any questions or concerns please contact your QA account manager.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<h3 class=\"h2\">Delegates will learn how to<\/h3>\n<div class=\"donotcrop\">\n<div>\n<ul>\n<li>Describe the features and syntax of PL\/SQL<\/li>\n<li>Design PL\/SQL anonymous block that execute efficiently<\/li>\n<li>Write PL\/SQL code to interface with the database<\/li>\n<li>Use PL\/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)<\/li>\n<li>Handle runtime errors<\/li>\n<li>Create and execute simple stored procedures and functions<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"readall\">\n<h2 class=\"h2\">Outline<\/h2>\n<div>\n<div>\n<p>Introduction<\/p>\n<ul>\n<li>Course Objectives, Course Agenda and Class Account Information<\/li>\n<li>Describe the Human Resources (HR) Schema<\/li>\n<li>Identify the Appendices Used in this Course<\/li>\n<li>Introduction to PL\/SQL Development Environments<\/li>\n<li>Oracle Database 19c SQL Documentation and Additional Resources<\/li>\n<\/ul>\n<p>Introduction to PL\/SQL<\/p>\n<ul>\n<li>Understanding the benefits and structure of PL\/SQL<\/li>\n<li>Examining PL\/SQL Blocks<\/li>\n<li>Generating output messages in PL\/SQL<\/li>\n<\/ul>\n<p>Declaring PL\/SQL Variables<\/p>\n<ul>\n<li>Identify valid and invalid identifiers<\/li>\n<li>Declare and initialize variables<\/li>\n<li>List and describe various data types<\/li>\n<li>Identify the benefits of using the %TYPE attribute<\/li>\n<li>Declare, use, and print bind variables<\/li>\n<\/ul>\n<p>Writing Executable Statements<\/p>\n<ul>\n<li>List Lexical Units in a PL\/SQL Block<\/li>\n<li>Use SQL Functions in PL\/SQL<\/li>\n<li>Use Data Type Conversion<\/li>\n<li>Use Nested Blocks as Statements<\/li>\n<li>Reference an Identifier Value in a Nested Block<\/li>\n<li>Qualify an Identifier with a Label<\/li>\n<li>Use Operators in PL\/SQL<\/li>\n<li>Using Sequences in PL\/SQL Expressions<\/li>\n<\/ul>\n<p>Using SQL Statements within a PL\/SQL Block<\/p>\n<ul>\n<li>Identify and use the SQL Statements in PL\/SQL<\/li>\n<li>Retrieve Data in PL\/SQL with the SELECT statement<\/li>\n<li>Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements<\/li>\n<li>Manipulate Data in the Server Using PL\/SQL<\/li>\n<li>The SQL Cursor concept<\/li>\n<li>Use SQL Cursor Attributes to Obtain Feedback on DML<\/li>\n<li>Save and Discard Transactions<\/li>\n<\/ul>\n<p>Writing Control Structures<\/p>\n<ul>\n<li>Control PL\/SQL Flow of Execution<\/li>\n<li>Conditional processing Using IF and CASE Statements<\/li>\n<li>Handle Nulls to Avoid Common Mistakes<\/li>\n<li>Build Boolean Conditions with Logical Operators<\/li>\n<li>Use Iterative Control with Looping Statements<\/li>\n<\/ul>\n<p>Working with Composite Data Types<\/p>\n<ul>\n<li>Learn the Composite Data Types of PL\/SQL Records and Tables<\/li>\n<li>Use PL\/SQL Records to Hold Multiple Values of Different Type<\/li>\n<li>Inserting and Updating with PL\/SQL Records<\/li>\n<li>Use INDEX BY Tables to Hold Multiple Values of the Same Data Type<\/li>\n<\/ul>\n<p>Using Explicit Cursors<\/p>\n<ul>\n<li>Define Cursors<\/li>\n<li>Explain Explicit Cursor Operations<\/li>\n<li>Controlling Explicit Cursors<\/li>\n<li>Use Explicit Cursors to Process Rows<\/li>\n<li>Cursors and Records<\/li>\n<li>Cursor FOR Loops Using Subqueries<\/li>\n<li>Explicit Cursor Attributes<\/li>\n<li>The %NOTFOUND and %ROWCOUNT Attributes<\/li>\n<\/ul>\n<p>Handling Exceptions<\/p>\n<ul>\n<li>Define Exception<\/li>\n<li>Handling Exceptions with PL\/SQL<\/li>\n<li>Predefined Exceptions<\/li>\n<li>Trapping Predefined and Non-predefined Oracle Server Errors<\/li>\n<li>Functions that Return Information on Encountered Exceptions<\/li>\n<li>Trapping User-Defined Exceptions<\/li>\n<li>Propagate Exceptions<\/li>\n<li>Basic RAISE Statement<\/li>\n<\/ul>\n<p>Creating Stored Procedures and Functions<\/p>\n<ul>\n<li>Overview of Stored Procedures and Functions<\/li>\n<li>Differentiate between anonymous blocks and subprograms<\/li>\n<li>Show the CREATE OR REPLACE PROCEDURE | FUNCTION<\/li>\n<li>Understand the Header Area of a Stored Procedure and Function<\/li>\n<li>Create Simple Procedures and Functions<\/li>\n<li>Create a Simple Procedure with an IN Parameter<\/li>\n<li>Execute a Procedure and a Function<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h3>Kursen levereras i samarbete med<\/h3>\n<p><img decoding=\"async\" class=\"alignnone wp-image-4027 lazyload\" data-src=\"https:\/\/republify.se\/wp-content\/uploads\/2022\/05\/qa_logo.png\" alt=\"\" width=\"200\" height=\"136\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 200px; --smush-placeholder-aspect-ratio: 200\/136;\" \/><\/p>\n<h2>Kontakta oss om denna kurs<\/h2>\n<div data-test='contact-form'\n\t\t\tid='contact-form-4116'\n\t\t\tclass='jetpack-contact-form-container '\n\t\t\tdata-wp-interactive='jetpack\/form' data-wp-context='{\"formId\":\"4116\",\"formHash\":\"d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\",\"showErrors\":false,\"errors\":[],\"fields\":[],\"isMultiStep\":false,\"useAjax\":true,\"submissionData\":null,\"formattedSubmissionData\":[],\"submissionSuccess\":false,\"submissionError\":null,\"elementId\":\"jp-form-d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\",\"isSingleInputForm\":false,\"isForcedHorizontal\":false}'\n\t\t\tdata-wp-watch--scroll-to-wrapper=\"callbacks.scrollToWrapper\"\n\t\t>\n<div class=\"contact-form-submission contact-form-ajax-submission\" data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" data-wp-class--submission-success=\"context.submissionSuccess\" id=\"contact-form-success-d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\" tabindex=\"-1\" aria-labelledby=\"contact-form-success-header-d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\"><p class=\"go-back-message\"><a class=\"link\" role=\"button\" tabindex=\"0\" data-wp-on--click=\"actions.goBack\" href=\"\/index.php\/wp-json\/wp\/v2\/product\/4116\">\u2190 Tillbaka<\/a><\/p><h4 data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" id=\"contact-form-success-header-d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\">Tack f\u00f6r din respons. \u2728<\/h4>\n\n<template data-wp-each--submission=\"context.formattedSubmissionData\">\n\t\t\t\t\t<div class=\"jetpack_forms_contact-form-success-summary\">\n\t\t\t\t\t\t<div class=\"field-name-wrapper\">\n\t\t\t\t\t\t\t<div class=\"field-type-icon\" data-wp-watch=\"callbacks.watchFieldTypeIcon\"><\/div>\n\t\t\t\t\t\t\t<div class=\"field-name\" data-wp-text=\"context.submission.label\" data-wp-bind--hidden=\"!context.submission.label\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-value\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.showPlainValue\"><\/div>\n\t\t\t\t\t\t<a class=\"field-url\" data-wp-bind--href=\"context.submission.url\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.url\" target=\"_blank\" rel=\"noopener noreferrer\"><\/a>\n\t\t\t\t\t\t<div class=\"field-rating\" data-wp-bind--hidden=\"!context.submission.rating\" data-wp-watch=\"callbacks.watchRatingIcons\"><\/div>\n\t\t\t\t\t\t<div class=\"field-images\" data-wp-bind--hidden=\"!context.submission.images\">\n\t\t\t\t\t\t\t<template data-wp-each--image=\"context.submission.images\">\n\t\t\t\t\t\t\t\t<div class=\"field-image-option\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t<figure class=\"field-image-option__image\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t\t<img data-wp-bind--src=\"context.image.src\" data-wp-bind--hidden=\"!context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAAD\/ACwAAAAAAQABAAACADs=\" data-wp-bind--hidden=\"context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<div class=\"field-image-option__label-wrapper\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label-code\" data-wp-text=\"context.image.letterCode\"><\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label\" data-wp-text=\"context.image.label\" data-wp-bind--hidden=\"!context.image.label\"><\/span>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-files\" data-wp-bind--hidden=\"!context.submission.files\">\n\t\t\t\t\t\t\t<template data-wp-each--file=\"context.submission.files\">\n\t\t\t\t\t\t\t\t<div class=\"field-file\">\n\t\t\t\t\t\t\t\t\t<div class=\"field-file__thumbnail\" data-wp-style--background-image=\"context.file.previewUrl\" data-wp-style--mask-image=\"context.file.iconUrl\" data-wp-bind--hidden=\"!context.file.hasPreview\"><\/div>\n\t\t\t\t\t\t\t\t\t<svg class=\"field-file__icon\" data-wp-bind--hidden=\"context.file.hasPreview\" width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t<path d=\"M14 2H6C4.9 2 4 2.9 4 4V20C4 21.1 4.89 22 5.99 22H18C19.1 22 20 21.1 20 20V8L14 2ZM18 20H6V4H13V9H18V20Z\" fill=\"currentColor\"\/>\n\t\t\t\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__name\" data-wp-text=\"context.file.name\"><\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__size\" data-wp-text=\"context.file.size\"><\/span>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/template><\/div><form action='https:\/\/republify.se\/index.php\/produkt\/oracle-database-pl-sql-fundamentals\/'\n\t\t\t\tid='jp-form-d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1'\n\t\t\t\tmethod='post'\n\t\t\t\tclass='contact-form commentsblock jetpack-contact-form__form has-no-jetpack-form-layout' aria-label=\"Oracle Database: PL\/SQL Fundamentals\"\n\t\t\t\tdata-wp-on--submit=\"actions.onFormSubmit\"\n\t\t\t\tdata-wp-on--reset=\"actions.onFormReset\"\n\t\t\t\tdata-wp-class--submission-success=\"context.submissionSuccess\"\n\t\t\t\tdata-wp-class--is-first-step=\"state.isFirstStep\"\n\t\t\t\tdata-wp-class--is-last-step=\"state.isLastStep\"\n\t\t\t\tdata-wp-class--is-ajax-form=\"context.useAjax\"\n\t\t\t\tnovalidate >\n<input type='hidden' name='jetpack_contact_form_jwt' value='eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbmNyeXB0ZWRfYXR0cmlidXRlcyI6InM2U28zUjdlalN2OThkUXBJV2xLUitoVEhXVHFOeStSWnF6WGhxVFk2dTVOdDRKOTRTMWZHdmhzeW5ON2l0ZXdLS1dBRTdsZVVZdXozekplRmI5ZzRGRUgwS3cxTVJaOFoxNFFrQkVNeEFvMU5DODQwNk1GVE9QbWJ1bVVaVjFZSDd4YzBUaEsyM0U4bVdoOExPNHh6c01iNjJ5c2VZZHIxL1A0WVpVNEFmUm5KQXlyMjYwU3BNMGF5ejZMY2ZoUC80TCt4emtSR29qbnpHVmVOSE11T2hyOGRSdVp1MTJCZTNGenVIbHplTTByVXN6cVl6Yjh2NEpPdzIyL0hhUm9HWXEwMkNxSEZYcWpXd2hLb0ppVUtiem9ONGJydzlDM0FSLzlVbzJFVENtWUlHQTZJdG81MjdHVmJLeWtHek56MDFqMDBxcTRMMkhaOGl3blpOWjRubmQ0SGJESHhDcnlqWkt0WVB5Sk00WFhWUmg0L1NOV2RwbjVrVzBtL3hTN2NQVFZyTU1RalRQclNUWHUwRld4SE9UMlZ1RjdsRGhBclRLYU1YVnhTWlI4c3htNXliQ2MwZW9jaDlJVjQwd0RHQVlsU1BlZ3ZIN3BSblVXREZxZndsNFhGeFF5d3FUMmdlbEFlZUFTTnhiazdRVDdWck9VTURLV1h4RmRHSnJmZXhwWVR5cEFqNm9GZ1Q2bjNqTWhlR0RUMFpGWUVENjhNeWpsQ050eDdaeUNIck9BVFIvYVVSMVl3dVh2TmtvOWNYUFNIOStBbndnbDdFSFJZTGUzZytjSXpnQVNHU1lhbDZTQzNQMEJqTmpCa0YxVzVFc1JQRlU0SkJodDNzckN1UDQveUlhUG1nSmpTdEszcjVpNVFOUkJ1NURQYU1ZSkZ3R2grRHQyaXcwSG5scjl5bG9EZXZnTVcyRUI2bU51dWQycUpEMy9BVy8wN0x2Mko4RTFlNUxzWFQvQ3REQjBnQ0hPc25YdTR0NWtDR3l2Um5wYzlLSy9MZ2ZLd09LQktsblBiWktYamlWaXB2RkdMZ2x3dkxkdm1IdllMZEE1SUY4RHlIenFoRVdMRVllenc2dzNVa1ZWSTIxemY3bGt0eVc4MFZnOXg1Y2xZMEYyZVRqQ2dHVmFUajd2dGJNRmY4VFB1bWhQdXBLVmJPaHN6Q1J5cC8yZXc0VmcyNC9FQXBTWE9EcGVTWExWQUQyS0Q1ODRJUHB1RnVZQUVmdTUvNXIwMEE9PSIsImNvbnRlbnQiOiJbY29udGFjdC1maWVsZCBsYWJlbD1cIk5hbW5cIiB0eXBlPVwibmFtZVwiIHJlcXVpcmVkPVwiMVwiXVtjb250YWN0LWZpZWxkIGxhYmVsPVwiRS1wb3N0XCIgdHlwZT1cImVtYWlsXCIgcmVxdWlyZWQ9XCIxXCJdW2NvbnRhY3QtZmllbGQgbGFiZWw9XCJNZWRkZWxhbmRlXCIgdHlwZT1cInRleHRhcmVhXCJdIiwiaGFzaCI6ImQ5MmMwZGMzYmQ3ZWI4MTgwZjk3YjNhYWZmYmQwNjMxYzA1NjdlZjEiLCJzb3VyY2UiOnsiZW50cnlfdGl0bGUiOiJPcmFjbGUgRGF0YWJhc2U6IFBML1NRTCBGdW5kYW1lbnRhbHMiLCJlbnRyeV9wYWdlIjoxLCJzb3VyY2VfaWQiOjQxMTYsInNvdXJjZV90eXBlIjoic2luZ2xlIiwicmVxdWVzdF91cmwiOiJodHRwczovL3JlcHVibGlmeS5zZS93cC1qc29uL3dwL3YyL3Byb2R1Y3QvNDExNiJ9LCJ2ZXJzaW9uIjoyLCJjaXBoZXIiOiJhZXMtMjU2LWdjbSJ9.1OxEfZJbfewiJMI6cdY7UB-hkKCfRbn0W9lauRXYm60' \/>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g4116-namn\",\"fieldType\":\"name\",\"fieldLabel\":\"Namn\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\"}'  class='grunion-field-name-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g4116-namn' class=\"grunion-field-label name\" >Namn<span class=\"grunion-label-required\" aria-hidden=\"true\">(obligatoriskt)<\/span><\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g4116-namn'\n\t\t\t\t\tid='g4116-namn'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g4116-namn-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='name  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g4116-namn-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g4116-namn-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g4116-epost\",\"fieldType\":\"email\",\"fieldLabel\":\"E-post\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\"}'  class='grunion-field-email-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g4116-epost' class=\"grunion-field-label email\" >E-post<span class=\"grunion-label-required\" aria-hidden=\"true\">(obligatoriskt)<\/span><\/label>\n<input\n\t\t\t\t\ttype='email'\n\t\t\t\t\tname='g4116-epost'\n\t\t\t\t\tid='g4116-epost'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g4116-epost-email-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='email  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g4116-epost-email-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g4116-epost-email-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g4116-meddelande\",\"fieldType\":\"textarea\",\"fieldLabel\":\"Meddelande\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1\"}'  class='grunion-field-textarea-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='contact-form-comment-g4116-meddelande' class=\"grunion-field-label textarea\" >Meddelande<\/label>\n<textarea\n\t\t                style=''\n\t\t                name='g4116-meddelande'\n\t\t                id='contact-form-comment-g4116-meddelande'\n\t\t                rows='20'\n\t\t\t\t\t\tdata-wp-text='state.getFieldValue'\n\t\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\t\t\t\t\t\taria-describedby='g4116-meddelande-textarea-error-message'\n\t\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\t\tclass='textarea  grunion-field'  ><\/textarea>\n \n\t\t\t<div id=\"g4116-meddelande-textarea-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g4116-meddelande-textarea-error-message\"><\/span>\n\t\t\t<\/div>\n\t<\/div>\n\t<p class='contact-submit'>\n<div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showFormErrors\"><span class=\"contact-form__warning-icon\" aria-hidden=\"true\"><i><\/i><\/span><span class=\"contact-form__error-message\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnValidationError\" data-wp-text=\"state.getFormErrorMessage\"><\/span><ul aria-label=\"Formul\u00e4rfel\">\n\t\t\t\t<template data-wp-each=\"state.getErrorList\" data-wp-key=\"context.item.id\">\n\t\t\t\t\t<li><a data-wp-bind--href=\"context.item.anchor\" data-wp-on--click=\"actions.scrollIntoView\" data-wp-text=\"context.item.label\"><\/a><\/li>\n\t\t\t\t<\/template>\n\t\t\t\t<\/ul><\/div><div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showSubmissionError\" data-wp-text=\"context.submissionError\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnSubmissionError\"><\/div>\t\t<button type='submit' class='pushbutton-wide'>Skicka<\/button>\t\t<input type='hidden' name='contact-form-id' value='4116' \/>\n\t\t<input type='hidden' name='action' value='grunion-contact-form' \/>\n\t\t<input type='hidden' name='contact-form-hash' value='d92c0dc3bd7eb8180f97b3aaffbd0631c0567ef1' \/>\n\t<\/p>\n<\/form>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><strong>This Oracle Database: PL\/SQL Fundamentals training introduces you to PL\/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.<\/strong><\/p>\n<p>In this course, you&#8217;ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You&#8217;ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.<\/p>\n","protected":false},"featured_media":4115,"comment_status":"open","ping_status":"closed","template":"","meta":{"wds_primary_product_brand":0,"wds_primary_product_cat":0},"product_brand":[],"product_cat":[144,29],"product_tag":[],"class_list":{"0":"post-4116","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-oracle","7":"product_cat-technical","9":"first","10":"instock","11":"taxable","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product\/4116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/comments?post=4116"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media\/4115"}],"wp:attachment":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media?parent=4116"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_brand?post=4116"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_cat?post=4116"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_tag?post=4116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}