Oracle SQL & PL/SQL Fundamentals Tutorial

Author: Lou Jian'an
Publisher:
Publish Date: 2005-09-01
Features: This book is a learning and practical textbook for IT majors in higher vocational and technical education to obtain academic degrees and related certifications from Oracle WDP projects of renowned software vendors. The textbook is compiled based on the curriculum teaching syllabus. The entire book is divided into 26 chapters, introducing Oracle SQL and PL/SQL in a progressive manner. Part 1 (Chapters 1–13) covers Oracle SQL, introducing the basic use of SQLPlus, basic query statements, single-row functions, multi-table queries, group functions and grouping statistics, subqueries, substitution variables, data manipulation, creating and managing tables, constraints, views, sequences, indexes, synonyms, and user access control. Part 2 (Chapters 14–26) covers PL/SQL, introducing PL/SQL fundamentals, variables, SQL in PL/SQL, control structures, composite data types, cursors, exceptions, procedures, functions, packages, triggers, large objects, and utility kits.
..This book covers almost all the content of the OCP (Oracle Certified Professional) exam and emphasizes practical skill training. The book explains examples in a task-driven manner, with all examples carefully designed around Oracle's built-in data tables, demonstrating strong representativeness and having been tested and verified with Oracle 9.0.2. Each chapter also includes targeted experimental tasks and post-lecture exercises to help readers consolidate their knowledge through practice. This book can serve as a textbook for computer software development courses in major vocational colleges, higher vocational and technical colleges, and dual-credential teaching programs. It can also be used as a foundational textbook for computer database management applications and as a reference for technical professionals engaged in Oracle database development and application industries.
..The book introduces simple queries and statements, constrained queries and sorting, single-row functions, multi-table queries, group functions and grouping statistics, and data manipulation in a progressive manner.