Structure of This Book
This book is divided into four parts:
This part of the book contains fundamental information about the Oracle database, which applies no matter what language or tools you are using.
Chapter 1, provides an overview of the architecture and underlying components of the Oracle database and briefly describes the various Oracle editions.
Chapter 2, describes the initialization parameters (INIT.ORA and/or SPFILE parameters) that allow you to configure your Oracle database.
Chapter 3, describes Oracle’s multiversion read consistency (MVRC) scheme and provides a brief discussion of transactions, locks, and other concurrency concepts.
Chapter 4, briefly describes authentication, profiles, privileges, roles, and auditing and specifies the syntax for controlling security in an Oracle database.
Chapter 5, briefly describes Oracle networking concepts and summarizes the syntax of the configuration files you must define in order to use a network with Oracle; these files include TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, LDAP.ORA, NAMES.ORA, and CMAN.ORA.
Chapter 6, summarizes the Oracle data dictionary views that maintain information about the objects and users in an Oracle database; it covers both the static views and the dynamic performance views.
This part of the book focuses on the syntax used to construct SQL statements and functions, PL/SQL programs, and Java interfaces to Oracle.
Chapter 7, summarizes the syntax of Oracle’s version of SQL (Structured Query ...