Oracle/SQL Tutorial - Emory University

Oracle/SQL Tutorial1 Michael 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 Priby

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 ...

Loading..

Tags:

  Oracle, User, Tutorials, Elements, Oracle sql tutorial

Information