Find this at http://www.npac.syr.edu/users/gcf/cps616oracleaccess97/

Access of Data using SQL-PL/SQL-OraPerl in Oracle

General Structure of SQL

Features of Oracle SQL and Examples

The six classes of SQL commands: Data Manipulation Language statements (DML), Data Definition Language statements (DDL), Transaction Control statements, Session Control statements, System Control statements, Embedded SQL statements

Programming in PL/SQL with examples and discussion of difference between SQL and PL/SQL

Oraperl - Access Oracle RDBMS from Perl

Table of Contents for Access of Data using SQL-PL/SQL-OraPerl in Oracle

001 CPS 616 January-April 1997
    Technologies for the Information Age
    Oracle RDBMS and Web Integration
    Module 2: Data Access SQL and Progamming PL/SQL in Oracle
002 Abstract of: Module 2: Data Access and Progamming in Oracle
003 Data Access and Progamming in Oracle
004 What we will do in These Lectures
005 Some Basic Terminology for Relational Database Model 
006 Examples of Typical Relational Operations
007 Examples of SELECT and PROJECT
008 Examples of JOIN and UNION Select Operations
009 Examples of INTERSECT and recursive embedded Operations
010 Structure Query Language (SQL) - I
011 Structure Query Language - II
012 Data Types and Operators in Oracle SQL
013 Functions in Oracle SQL
014 Classes of Oracle SQL Statements
015 DDL Contrasted to DML
016 Data Definition Language statements (DDL)
017 DDL Statement Examples
018 Data Manipulation Language statements (DML)
019 DML Examples - I
020 DML Examples - II
021 Transaction Control Statements
022 PL/SQL - Oracle's Procedural Language to SQL
023 Advantages of PL/SQL
024 Architecture of The PL/SQL "Engine"
025 PL/SQL Data Types
026 Program Units in PL/SQL
027 PL/SQL Stored Procedure
028 PL/SQL Packages
029 Example of A PL/SQL Package Structure
030 Cursors in PL/SQL - I
031 Cursors in PL/SQL - II
032 An Example of PL/SQL Stored Procedure - I
033 An Example of PL/SQL Stored Procedure - II
034 An Example of PL/SQL Stored Procedure - III
035 How to use Example of PL/SQL Stored Procedure
036 Explanation of Example of PL/SQL Stored Procedure
037 Scope and Life time of Procedure and Package Variables, Constants,
     and Cursors
038 Oraperl - Oracle Data Access From a Perl Program
039 Major Built-in Functions in Oraperl
040 An Example in OraPerl - Query a Person's Phone Number By Last or 
    First Name - I
041 An Example in OraPerl - Query a Person's Phone Number By Last or 
    First Name - II
042 More detailed information about SQL, PL/SQL and Oraperl,  
    including examples, can be found in the handout and on-line at 
    http://osprey7.npac.syr.edu
    :1997/database

Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu