Foilset Search Full Index for Basic foilset

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

Given by Gang Cheng, C.W. Ou, Geoffrey C. Fox at ARL Database Tutorial on February 98. Foils prepared 7 October 97

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

There are two types of foils -- html and image which are each available in basic and JavaScript enabled "focused" style
(basic:)(focus style:) Denote Foils where Image Critical
(basic:)(focus style:) Denote Foils where HTML is sufficient
1 Technologies for the Information Age
Oracle RDBMS and Web Integration
Module 2: Data Access SQL and Progamming PL/SQL in Oracle
2 Abstract of: Module 2: Data Access and Progamming in Oracle
3 Data Access and Progamming in Oracle
4 What we will do in These Lectures
5 Some Basic Terminology for Relational Database Model
6 Examples of Typical Relational Operations
7 Examples of SELECT and PROJECT
8 Examples of JOIN and UNION Select Operations
9 Examples of INTERSECT and recursive embedded Operations
10 Structure Query Language (SQL) - I
11 Structure Query Language - II
12 Data Types and Operators in Oracle SQL
13 Functions in Oracle SQL
14 Classes of Oracle SQL Statements
15 DDL Contrasted to DML
16 Data Definition Language statements (DDL)
17 DDL Statement Examples
18 Data Manipulation Language statements (DML)
19 DML Examples - I
20 DML Examples - II
21 Transaction Control Statements
22 PL/SQL - Oracle's Procedural Language to SQL
23 Advantages of PL/SQL
24 Architecture of The PL/SQL "Engine"
25 PL/SQL Data Types
26 Program Units in PL/SQL
27 PL/SQL Stored Procedure
28 PL/SQL Packages
29 Example of A PL/SQL Package Structure
30 Cursors in PL/SQL - I
31 Cursors in PL/SQL - II
32 An Example of PL/SQL Stored Procedure - I
33 An Example of PL/SQL Stored Procedure - II
34 An Example of PL/SQL Stored Procedure - III
35 How to use Example of PL/SQL Stored Procedure
36 Explanation of Example of PL/SQL Stored Procedure
37 Scope and Life time of Procedure and Package Variables, Constants, and Cursors
38 Oraperl - Oracle Data Access From a Perl Program
39 Major Built-in Functions in Oraperl
40 An Example in OraPerl - Query a Person's Phone Number By Last or First Name - I
41 An Example in OraPerl - Query a Person's Phone Number By Last or First Name - II
42 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
:3768/reference-docs/cwou/database
Full WebWisdom URL and this Foilset Search
This contains all WebWisdom links preceded by those referenced 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 Thu Feb 5 1998