FB
PL/SQL Tutorial: Chapter 7

PL/SQL Tutorial: Chapter 7

PL/SQL Tutorial Chapter 7: Nested Blocks and Packages In this section, you’ll learn: What nested blocks are and how to create them What packages are, why you should use them, and how to create them What is a Nested Block in PL/SQL? A nested block is where a... Read more

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