Featured resource
2026 Tech Forecast
2026 Tech Forecast

Stay ahead of what’s next in tech with predictions from 1,500+ business leaders, insiders, and Pluralsight Authors.

Get these insights
  • Course

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL

Companies rely on the backend developers when meeting SLAs with customers. This course will teach you how to proficiently write PL/SQL executable blocks using DML and the INTO clause to hold values returned by PL/SQL for the Oracle database.

Intermediate
1h 18m
(7)

Created by Ed Freitas

Last Updated Feb 22, 2022

Course Thumbnail
  • Course

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL

Companies rely on the backend developers when meeting SLAs with customers. This course will teach you how to proficiently write PL/SQL executable blocks using DML and the INTO clause to hold values returned by PL/SQL for the Oracle database.

Intermediate
1h 18m
(7)

Created by Ed Freitas

Last Updated Feb 22, 2022

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

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.

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL
Intermediate
1h 18m
(7)
Table of contents

About the author
Ed Freitas - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL
Ed Freitas
55 courses 4.2 author rating 1186 ratings

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. He's a well-known specialist in the Enterprise Content Management market segment, specifically focusing on data capture & extraction and document process automation.

Get started with Pluralsight