Oracle PL/SQL | Programming in Simple Steps

From: <>
Date: Fri, 5 Feb 2016 09:45:11 -0800 (PST)
Message-ID: <>

This enhanced the capabilities of SQL as PL/SQL allows mixing of SQL statements with procedural constructs. Unlike SQL, PL/SQL is a programming language extending SQL, which includes procedural elements like loops, data types, control structures and others. You can create program blocks, functions, methods, triggers and packages with this extension. In simple terms, while SQL tells the relational database what to do, PL/SQL tells them how to do.

The main sections on language PL/SQL are:

  1. DML Statements
  2. Select Query
  3. Table Joins
  4. Stored Procedures
  5. Functions
  6. Collections and Records
  7. Cursors
  8. Exception Handling
  9. Triggers
  11. Error Messages

Start learning Oracle PL/SQL from basics to advance levels here... Received on Fri Feb 05 2016 - 18:45:11 CET

Original text of this message