Learn PL/SQL in 24 Hours

PL/SQL is an extension of SQL for the Oracle Database.

Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.

The book contains tons of examples that prepare you for real-world development project.

This book is considered the best Oracle PL/SQL programming guide by the Oracle community.

The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.

Here is what you will learn

Chapter 1: What Is PL/SQL? Introduction & Architecture

Chapter 2: SQL Vs PL/SQL Vs T-SQL: Key Differences

Chapter 3: PL/ SQL Block: STRUCTURE, Syntax, ANONYMOUS Example

Chapter 4: PL/SQL First Program: Hello World Example

Chapter 5: Oracle PL/SQL Data Types: Character, Number, Boolean, Date, LOB

Chapter 6: Oracle PL/SQL Variable Identifiers Tutorial with Examples

Chapter 7: Oracle PL/SQL Collections: Varrays, Nested & Index by Tables

Chapter 8: Oracle PL/SQL Records Type with Examples

Chapter 9: Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF

Chapter 10: Oracle PL/SQL: CASE Statement with Examples

Chapter 11: Oracle PL/SQL LOOP with Example

Chapter 12: Oracle PL/SQL FOR LOOP with Example

Chapter 13: Oracle PL/SQL WHILE LOOP with Example

Chapter 14: Oracle PL/SQL Stored Procedure & Functions with Examples

Chapter 15: Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception

Chapter 16: Oracle PL/SQL Insert, Update, Delete & Select Into [Example]

Chapter 17: Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]

Chapter 18: Oracle PL/SQL BULK COLLECT: FORALL Example

Chapter 19: Autonomous Transaction in Oracle PL/SQL: Commit, Rollback

Chapter 20: Oracle PL/SQL Package: Type, Specification, Body [Example]

Chapter 21: Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]

Chapter 22: Oracle PL/SQL Object Types Tutorial with EXAMPLES

Chapter 23: Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL

Chapter 24: Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]

Dettagli