Oracle Database 10g PL/SQL Tutorial

Author: (USA) Christopher Allen
Publisher:
Publish Date: 2005-10-01
Features: This book comprehensively and systematically introduces the basic content and practical techniques of Oracle Database 10g PL/SQL. Oracle expert Christopher Allen first introduces the basics of databases, then explains SQL statements and PL/SQL programs and their practical examples in an easy-to-understand manner. You will learn how to manage, query, and manipulate data, use SQLPlus, create SQL functions, and write actual PL/SQL applications. The exercises, summaries, and hands-on practice at the end of each chapter will help you better understand and utilize the powerful features of Oracle Database 10g. The main content of this book includes: creating tables, rows, records, columns, and fields; storing text, numbers, dates, images, and audio files in tables and columns; using SQL commands to define, manipulate, retrieve, and delete data; using SQL functions and procedures to select and filter records, and sort them; writing SQL commands, using anchored type declarations for variables; using SAVEPOINT and ROLLBACK commands to ensure multi-level redo functionality; performing basic and hierarchical data queries; using SQLPlus programs to write and reuse commands in SQL scripts; using PL/SQL views, sequences, procedures, functions, and packages; using triggers to automatically implement auditing, security, and maintenance tasks.