Oracle9i Quick Start

Author: Wang Hailiang
Publisher:
Publish Date: 2004-01-01
Features: This book is suitable for the following readers:
● Oracle Beginners: Beginners only need to study in a systematic order according to the chapter sequence to quickly enter the Oracle world.
● Oracle Application Developers: This book not only provides methods for writing simple SQL statements for developers but also provides methods for writing complex SQL statements, including subqueries, join queries, hierarchical queries, and merge queries. Additionally, this book provides developers with numerous new features of Oracle9i application development, including new features for outer joins, using CUBE and ROLLUP to generate grouped data, reverse queries, WITH clauses, CASE expressions, and new date-time functions. Developers can choose appropriate chapters to read the content they need.
● Database Administrators: This book not only provides basic management methods for Oracle databases for DBAs (Database Administrators) but also provides numerous new system management features of Oracle9i, including iSQLPlus, SPFILE, UNDO table spaces, OMF, fine-grained access control, and OS roles. This book provides Oracle beginners with fundamental methods for quickly mastering SQL, Oracle architecture, and backup and recovery. By studying this book, readers can not only master the various basic principles of Oracle but also deepen their understanding of these principles through examples and exercises. Additionally, this book provides Oracle application developers and system administrators with numerous new features of Oracle9i.