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

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 1996-7 Computational Science Track on Base 
    Technology for the Information Age: 
    Oracle RDBMS and Web Integration
    Module 2: Data Access and Progamming 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 SQL and Parallelism
013 Data Types and Operators in Oracle SQL
014 Functions in Oracle SQL
015 Classes of Oracle SQL Statements
016 Data Manipulation Language statements (DML)
017 DML Examples - I
018 DML Examples - II
019 Data Definition Language statements (DDL)
020 DDL Statement Examples
021 Transaction Control Statements
022 Session and System Control Statements
023 Embedded and Recursive Sequel Statements
024 Oracle 7 Cursors or Named Memory
025 Shared SQL Statements
026 PL/SQL - Oracle's Procedural Language to SQL
027 Advantages of PL/SQL
028 Basic 3GL Programming Language features in PL/SQL
029 Architecture of The PL/SQL "Engine"
030 PL/SQL Data Types
031 Program Units in PL/SQL
032 PL/SQL Stored Procedure
033 How to use Example of PL/SQL Stored Procedure
034 PL/SQL Packages
035 Example of A PL/SQL Package Structure
036 Cursors in PL/SQL - I
037 Cursors in PL/SQL - II
038 An Example of PL/SQL Stored Procedure - I
039 An Example of PL/SQL Stored Procedure - II
040 An Example of PL/SQL Stored Procedure - III
041 Explanation of Example of PL/SQL Stored Procedure
042 Scope and Life time of Procedure and Package Variables, Constants,
     and Cursors
043 Oraperl - Oracle Data Access From a Perl Program
044 Major Built-in Functions in Oraperl
045 An Example in OraPerl - Query a Person's Phone Number By Last or 
    First Name - I
046 An Example in OraPerl - Query a Person's Phone Number By Last or 
    First Name - II
047 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