Writing high-performing database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 – Writing SQL in PL/SQL, you’ll learn to apply the guidelines and recommendations offered by Oracle in structuring your PL/SQL program and writing maintainable code. First, you’ll explore the lexical units that make up a PL/SQL program. Next, you’ll use Data Manipulation Language (DML) and discover how to select, insert, delete, and update data in an Oracle database. Finally, you’ll learn to use the INTO clause to hold the values returned by a SQL statement. When you finish this course, you’ll have the skills and knowledge to write effective PL/SQL code needed to create a fast-performing backend.
Author Name: Ed Freitas
Author Description:
Eduardo is a technology enthusiast, software architect and customer success advocate. He’s designed enterprise .NET solutions that extract, validate and automate critical business processes such as Accounts Payable and Mailroom solutions for all types of organizations. He’s designed and supported production systems for global names such as Coca Cola, Enel, Pirelli, Fiat-Chrysler, Xerox and many others. He’s a well-known specialist in the Enterprise Content Management market segment, specifically… more