Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© Jon Heller 2019

Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_21

21. Level Up Your Skills with PL/SQL

Jon Heller¹ 

(1)

Clive, IA, USA

 

If you use Oracle SQL long enough, you will eventually want to learn PL/SQL. SQL is the primary language for Oracle development, but we at least need PL/SQL to package our work. The first step in PL/SQL development is to create a safe playground for learning PL/SQL. There’s not enough room here for a full PL/SQL tutorial, but we can at least discuss the PL/SQL features most likely to help us enhance our SQL. To become a true Oracle master, you’ll need PL/SQL to help you teach others and create programs.

Is PL/SQL Worth Mastering?

Before you spend even more time learning Oracle, it’s ...