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 and serves as the interface for application interaction 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, branching, etc.) but also advanced features of object-oriented programming languages (such as overloading, inheritance, etc.). 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.