Basic Foilset Search HELP! * GREY=local Full Index for

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

Given by Gang Cheng, C.W. Ou, Geoffrey C. Fox at CPS616 Basic Information Track for Computational Science on Winter-Spring Semester 96. Foils prepared 4 April 1996
More Detail! * Foil Index from this file * See also color IMAGE

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

A denotes presence of Additional linked information
_ 1 Separate IMAGE * Separate HTML 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
_ 2 Separate IMAGE * Separate HTML Abstract of: Module 2: Data Access and Progamming in Oracle
_ 3 Separate IMAGE * Separate HTML Data Access and Progamming in Oracle
_ 4 Separate IMAGE * Separate HTML What we will do in These Lectures
_ 5 Separate IMAGE * Separate HTML Some Basic Terminology for Relational Database Model
_ 6 Separate IMAGE * Separate HTML Examples of Typical Relational Operations
_ 7 Separate IMAGE * Separate HTML Examples of SELECT and PROJECT
A 8 Separate IMAGE * Separate HTML Examples of JOIN and UNION Select Operations
_ 9 Separate IMAGE * Separate HTML Examples of INTERSECT and recursive embedded Operations
A 10 Separate IMAGE * Separate HTML Structure Query Language (SQL) - I
_ 11 Separate IMAGE * Separate HTML Structure Query Language - II
_ 12 Separate IMAGE * Separate HTML SQL and Parallelism
_ 13 Separate IMAGE * Separate HTML Data Types and Operators in Oracle SQL
_ 14 Separate IMAGE * Separate HTML Functions in Oracle SQL
_ 15 Separate IMAGE * Separate HTML Classes of Oracle SQL Statements
_ 16 Separate IMAGE * Separate HTML Data Manipulation Language statements (DML)
A 17 Separate IMAGE * Separate HTML DML Examples - I
A 18 Separate IMAGE * Separate HTML DML Examples - II
_ 19 Separate IMAGE * Separate HTML Data Definition Language statements (DDL)
A 20 Separate IMAGE * Separate HTML DDL Statement Examples
_ 21 Separate IMAGE * Separate HTML Transaction Control Statements
_ 22 Separate IMAGE * Separate HTML Session and System Control Statements
_ 23 Separate IMAGE * Separate HTML Embedded and Recursive Sequel Statements
_ 24 Separate IMAGE * Separate HTML Oracle 7 Cursors or Named Memory
_ 25 Separate IMAGE * Separate HTML Shared SQL Statements
_ 26 Separate IMAGE * Separate HTML PL/SQL - Oracle's Procedural Language to SQL
_ 27 Separate IMAGE * Separate HTML Advantages of PL/SQL
_ 28 Separate IMAGE * Separate HTML Basic 3GL Programming Language features in PL/SQL
_ 29 Separate IMAGE * Separate HTML Architecture of The PL/SQL "Engine"
_ 30 Separate IMAGE * Separate HTML PL/SQL Data Types
_ 31 Separate IMAGE * Separate HTML Program Units in PL/SQL
_ 32 Separate IMAGE * Separate HTML PL/SQL Stored Procedure
_ 33 Separate IMAGE * Separate HTML How to use Example of PL/SQL Stored Procedure
_ 34 Separate IMAGE * Separate HTML PL/SQL Packages
_ 35 Separate IMAGE * Separate HTML Example of A PL/SQL Package Structure
_ 36 Separate IMAGE * Separate HTML Cursors in PL/SQL - I
_ 37 Separate IMAGE * Separate HTML Cursors in PL/SQL - II
A 38 Separate IMAGE * Separate HTML An Example of PL/SQL Stored Procedure - I
A 39 Separate IMAGE * Separate HTML An Example of PL/SQL Stored Procedure - II
A 40 Separate IMAGE * Separate HTML An Example of PL/SQL Stored Procedure - III
_ 41 Separate IMAGE * Separate HTML Explanation of Example of PL/SQL Stored Procedure
_ 42 Separate IMAGE * Separate HTML Scope and Life time of Procedure and Package Variables, Constants, and Cursors
_ 43 Separate IMAGE * Separate HTML Oraperl - Oracle Data Access From a Perl Program
_ 44 Separate IMAGE * Separate HTML Major Built-in Functions in Oraperl
_ 45 Separate IMAGE * Separate HTML An Example in OraPerl - Query a Person's Phone Number By Last or First Name - I
_ 46 Separate IMAGE * Separate HTML An Example in OraPerl - Query a Person's Phone Number By Last or First Name - II
_ 47 Separate IMAGE * Separate HTML 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
Full WebWisdom URL and this Foilset Search
Alias List This contains all WebWisdom links preceded by those referenced in this foilset

List of WebWisdom URL's Used in this Foilset

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

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sat May 24 1997