Proficient in Oracle 10g SQL and PL/SQL

Author: Wang Hailiang
Publisher:
Publish Date: 2007-01-01
Features: SQL is the basic operation language of relational databases; it serves as an interface for applications to interact with databases. PL/SQL is a programming language specific to Oracle, which not only has the basic features of procedural programming languages (such as loops, conditions, and branching) but also advanced features of object-oriented programming languages (such as overloading and inheritance). This book is a programming guide specifically designed for Oracle application developers. By studying this book, readers can not only master the basic knowledge of SQL and PL/SQL but also learn advanced features of SQL (such as regular expressions, Flashback queries, MERGE statements, SQL:1999 joins) and advanced features of PL/SQL (such as record types, collection types, object types, etc.). This book is suitable for both beginners in SQL and PL/SQL as well as experienced PL/SQL programmers. It can also serve as a textbook or supplementary material for Oracle application development training courses.