FB
PL/SQL Tutorial: Chapter 6

PL/SQL Tutorial: Chapter 6

PL/SQL Tutorial Chapter 6: Record Types and Bulk Collect In this chapter, we’ll learn about: Using data types based on tables and columns Understanding what collections are Using the BULK COLLECT keyword to fetch data in bulk These are all great features of the... Read more

PL/SQL Tutorial: Chapter 5

PL/SQL Tutorial Chapter 5: Cursors, Arrays, and Bulk Collect In this chapter, we’ll learn about some pretty useful concepts in PL/SQL: What a cursor is The two types of cursors Inserting, updating, and deleting data in tables using PL/SQL Selecting data from a... Read more

PL/SQL Tutorial: Chapter 4

PL/SQL Chapter 4: Procedures, Functions, and Exceptions In this chapter, you’ll learn: What procedures and functions are How to create a procedure How to create a function What an exception is and how to handle one Let’s get started! What is a PL/SQL... Read more

PL/SQL Tutorial: Chapter 3

PL/SQL Tutorial Chapter 3: Conditions and Loops In this chapter, you’ll learn about: Conditions (If, Then, Else) Loops Commenting Code These are common features of other programming languages, and PL/SQL lets you use these features as well. What Are Conditions?... Read more
PL/SQL Tutorial: Chapter 1

PL/SQL Tutorial: Chapter 1

PL/SQL Tutorial Chapter 1: Introduction and Your First PL/SQL Program In this chapter, you’ll learn: What PL/SQL is and what it stands for The basic structure and syntax of a PL/SQL program Write and run your first PL/SQL program Let’s get right into it!... Read more