PL/SQL Tutorial - A procedural programming language for Oracle Database

Table of Contents

• Prerequisites
  • Oracle Database 11g installation - For windows  / Linux
  • Oracle SQL/Developer - Optional (If you are familiar with SQL*PLUS)
• PL/SQL - a procedural programming language
  • Introduction of PL/SQL
  • PL/SQL - Language fundamentals (identifiers, literal and keyword )and Data Types
  • PL/SQL - Declaration and Operators
  • PL/SQL Control Statements - (IF-ELSE, CASE, LOOP, FOR LOOP, WHILE)
  • PL/SQL Composite data type - Collections and Record
    • PL/SQL Collections - Associative array, VARRAY and Nested Tables
    • PL/SQL Records - Table based , Cursor based, User defined
  • PL/SQL Cursor - Implicit & Explicit cursor, Cursor variable
    • PL/SQL Cursor- Implicit & Explicit Cursor
    • PL/SQL Records - Cursor variable
• What’s next?
  

Other PL/SQL post :-

1. How does PL/SQL program executed internally in Oracle Database server.?
2. Interconversion of CHAR and VARCHR in PL/SQL and Database.
3. DBMS_OUTPUT.PUT_LINE not printing - Why do we need set serveroutput on" to see output on console
4. What is difference between weak cursor type and Strong cursor type ?
5. How to test a stored procedure in SQl*PLUS and SQL developer- with primitive or with ref cursor.
6. Difference between REF CURSOR and SYS_REFCURSOR.
7. Difference between explicit cursor and cursor variable - CURSOR vs REF CURSOR