All You Need To Know About PL-SQL Programming
This article will walk you through with the basics of Pl-SQL programming.
Each topic includes basic programming tutorial and related interview question.
PL-SQL Introduction
This article explains its advantages and briefly describes its main features and its architecture.
PL-SQL architecture with flow diagram.
PL-SQL Engine, PL-SQL Unit and PL-SQL Block structure with example.
How to write and execute the PL-SQL block.
continue reading...
PL-SQL Fundamentals
This article will guide you through the basic fundamentals of PL-SQL programming.
Character Sets and Lexical Units (Delimiters,Identifiers, Literals and Comments).
Declaration of identifiers with example. Using DEFAULT and NOT NULL.
Using the %TYPE and %ROWTYPE Attribute. Aggregate Assignment. Naming Convention, Scope and Visibility.
CASE Expression and Handling NULL values.
continue reading...
PL/SQL Datatypes
This article explains the basic, frequently used predefined PL/SQL data types and subtypes, how to define and use your own PL/SQL subtypes, and PL/SQL data type conversion
Predefined PL/SQL Datatypes. Subtypes of predefined Datatypes.
What is Subtypes? User defined subtypes with example.
Datatype conversions.
continue reading...
PL/SQL Control Statement
This article shows you how to structure the flow of control through a PL/SQL program. PL/SQL provides conditional tests, loops, and branches that let you produce well-structured programs.
IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. CASE Statement and Searched CASE Statement.
Basic Loop Statement. WHILE and FOR statement. Usage of CONTINUE and EXIT in Loop statement
Sequential Control (GOTO and NULL Statements)
continue reading...
PL/SQL Collections and Records
This article explains how to create and use PL/SQL collection and record variables.
What is Collections and Records? How to declare and define Collection and Records
Types of PL/SQL Collection: Associative array (or index-by table), Variable-Size Arrays (Varrays), Nested Tables
Difference between Nested Tables and Associative Arrays? Difference between Nested Tables and Varrays?
Important Collection Methods and their usage.
continue reading...
PL-SQL Subprograms (Procedure and Function)
This article explains how to turn sets of statements into reusable subprograms. Subprograms are the building blocks of modular, maintainable applications
What is Subprogram? How to create Subprogram?
What is Procedure and Function? How to create Procedure and Function?
Nested Subprograms. Overloading Subprograms
continue reading...
Declaring and Passing Subprogram Parameters
This article explains hot to declare and pass parameteres in Subprograms.
What are the types Parameter? What are the modes of Parameter?
Passing Actual parameter as Positional, Named, or Mixed Notation with example.
Passing Default value in Formal parameter with example.
continue reading...
PL/SQL Packages
This article explains how to bundle related PL/SQL code and data into a package.
What is PL-SQL Packages? How to create PL-SQL Package Specs and Body?
What Goes in a PL/SQL Package? Private and Public Items in PL/SQL Packages.
Overview of Product-Specific PL/SQL Packages
continue reading...
PL/SQL Triggers
This article will guide you through the basics of PL-SQL Triggers.
What is PL-SQL Triggers? Types of Triggers?
What is Trigger States? How to Create Triggers? When Does the Trigger Fire?
continue reading...
PL/SQL Exception Handling
This article will guide you through the basics of PL-SQL Exception Handling.
What is PL/SQL Exception or Errors? What is PL/SQL Exception Handling?
User Defined Exception? Declaring & Invoking PL/SQL Exceptions. Scope Rules for PL/SQL Exceptions.
Usage of RAISE_APPLICATION_ERROR, SQLCODE, SQLERRM and EXCEPTION_INIT Pragma.
continue reading...