Oracle Database 10g PL/SQL Tutorial

Author: (USA) Allen, C (Allen, C) Author, Xing Zhiming Translator
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 fundamentals of databases, then explains SQL statements and PL/SQL programs with 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 practices at the end of each chapter will help you gain a deeper understanding and utilize the powerful features of Oracle Database 10g.
Main Content:
- 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, filter, and sort records
- Writing SQL commands with anchored type variable declarations
- Using SAVEPOINT and ROLLBACK commands to ensure multi-level redo functionality
- Performing basic and hierarchical data queries
- Using SQLPlus to write and reuse commands in SQL scripts
- Using PL/SQL views, sequence procedures, functions, and packages
- Using triggers to automate review, security, and maintenance tasks