Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Declaring PL/SQL Variables

Focused View

Esteban Herrera

1:11:39

110 View

01. Course Overview

01. Course Overview.mp4

01:33

02. Introducing Variables in PL SQL

02. Introduction.mp4

03:47

03. Installing the HR Schema.mp4

07:33

04. What Are Variables and How Are They Used.mp4

02:40

05. Summary.mp4

01:22

03. Declaring Variables

06. Declaring Variables and Constants.mp4

05:05

07. Assigning Values to Variables.mp4

02:39

08. Bind Variables.mp4

05:31

09. Summary.mp4

01:46

04. Recognizing Valid Variable Identifiers

10. Introduction.mp4

02:26

11. User-defined Identifiers.mp4

06:48

12. Reserved Words and Keywords.mp4

03:19

13. Summary.mp4

01:54

05. Working with Data Types and %TYPE and %ROWTYPE Attributes

14. Introduction.mp4

01:15

15. The NUMBER CHAR VARCHAR2 and BOOLEAN Types.mp4

04:54

16. Demo-The NUMBER CHAR VARCHAR2 and BOOLEAN Types.mp4

04:14

17. The %TYPE Attribute.mp4

03:51

18. The %ROWTYPE attribute.mp4

05:12

19. Course Summary.mp4

05:50

Description

This course will teach you everything you need to know about PL/SQL variables to help you prepare for the 1Z0-149 exam.

What You'll Learn?

Becoming a certified PL/SQL developer requires knowledge of variables. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Declaring PL/SQL Variables, you’ll learn everything you need to know about declaring and using PL/SLQ variables. First, you’ll explore what variables are and how to declare them. Next, you’ll discover how to recognize valid and invalid variable identifiers. Finally, you’ll see how to use different types of variables. When you’re finished with this course, you’ll have the skills and knowledge of PL/SQL variables needed to answer the exam questions related to this topic.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Esteban Herrera

Instructor's Courses

Esteban Herrera has more than twelve years of experience in the software development industry. He has worked in many roles and projects, but mostly architecting and developing enterprise systems with Java and Javascript. Among others, Esteban holds the PMI's Project Manager certification and the Oracle Java EE 6 Enterprise Architect Master Certification. Nowadays, he spends all of his time learning new things, writing articles, teaching programming, and enjoying his kids.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.