Oracle/SQL Tutorial - Emory University

← Back to document page

Oracle/SQL Tutorial1Michael GertzDatabase and Information Systems GroupDepartment of Computer ScienceUniversity of California, Oracle/SQL Tutorial provides a detailed introduction to the SQL query language and theOracle Relational Database Management System. Further information about oracle and SQLcan be found on the web , corrections, or additions to these notes are welcome. Many thanks to ChristinaChung for comments on the previous LiteratureGeorge Koch and Kevin Loney:Oracle8 The Complete Reference(The Single Most Compre-hensive Sourcebook for oracle Server, Includes CD with electronic version of the book), 1299pages, McGraw-Hill/Osborne, Abbey and Michael Corey:Oracle8 : A Beginner s Guide [A Thorough Introductionfor First-time Users], 767 pages, McGraw-Hill/Osborne, Feuerstein, Bill Pribyl

2. SQL*Plus (Minimal User Guide, Editor Commands, Help System) 20 3. Oracle Data Dictionary 23 4. Application Programming 4.1. PL/SQL 4.1.1 Introduction 26 4.1.2 Structure of PL/SQL Blocks 27 4.1.3 Declarations 27 4.1.4 Language Elements 28 4.1.5 Exception Handling 32 4.1.6 Procedures and Functions 34 4.1.7 Packages 36 4.1.8 Programming in PL ...

  Oracle, User, Tutorials, Elements, Oracle sql tutorial