undefined

PL/SQL is an extension of SQL for the Oracle Database. Learn PL/SQL in 1 Day serves as beginner guide for a c 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: Introduction What Is PL/SQL? Architecture of PL/SQL Advantage of Using PL/SQL Basic Difference between SQL and PL/SQL Chapter 2: Blocks What is PL/SQL block? Block Structure Types of PL/SQL block Chapter 3: First Program: Hello World SQL Plus Connecting to Database How to write a simple program using PL/SQL Declaring and usage of variables in program Commenting Codes Chapter 4: Data Types CHARACTER NUMBER BOOLEAN DATE LOB Chapter 5: Complex Data Types Record Type Collection Constructor and Initialization Concept in Collections Collection Methods Chapter 6: Decision Making Statements Introduction to Decision Making Statements IF-THEN Statement IF-THEN-ELSE Statement IF-THEN-ELSIF Statement NESTED-IF Statement CASE Statement SEARCHED CASE Statement Chapter 7: Loops Introduction to Loops Concept Loop Control Statements Types of Loop in PL/SQL Nested Loops Labelling of Loops Chapter 8: Subprograms: Procedures and Functions Terminologies in PL/SQL Subprograms Procedure Function Similarities between Procedure and Function Difference between Procedure and Function Built-in Functions in PL/SQL Chapter 9: Exception Handling Exception-Handling Predefined Exceptions User-defined Exception Raising an Exception Important points to note in Exception Chapter 10: SQL DML Transactions in PL/SQL CURSOR Concept in PL/SQL Cursor Attributes FOR Loop Cursor statement BULK COLLECT in PL/SQL TCL Statements in PL/SQL Autonomous Transaction Chapter 11: Packages Components of Packages Package Initialization Forward Declarations Overloading Package Information UTL FILE – An Overview Chapter 12: Triggers Benefits of Triggers Trigger Classification Trigger Creation :NEW and :OLD Clause INSTEAD OF Trigger Compound Trigger Chapter 13: Object Types Components of Object Types Creation of Objects Declaration Initialization of Object Type Constructors Inheritance in Object Type Equality of PL/SQL Objects Chapter 14: Dynamic SQL Ways to write dynamic SQL NDS DBMS_SQL for Dynamic SQL Chapter 15: Nested Blocks Nested Block Structure s in Nested Block Chapter 16: Identifiers Properties of Identifiers Naming Conventions of Identifiers Variables – An Identifier Declaration of Variables Data storing in Variables