About Oracle Database
1-2 Oracle Database 2 Day Developer's Guide
Chapter 4, "Creating and Managing Schema Objects," introduces data definition
language (DDL) statements, which create, change, and drop schema objects.
Chapter 5, "Developing Stored Subprograms and Packages," introduces stored
subprograms and packages, which can be used as building blocks for many different
database applications.
Chapter 6, "Using Triggers," introduces triggers, which are stored PL/SQL units that
automatically execute ("fire") in response to specified events.
Chapter 7, "Working in a Global Environment," introduces globalization
support—National Language Support (NLS) parameters and Unicode-related features
of SQL and PL/SQL.
Chapter 8, "Building Effective Applications," explains how to build scalable
applications and use recommended programming and security practices.
Chapter 9, "Developing a Simple Oracle Database Application," shows how to develop
a simple Oracle Database application.
Chapter 10, "Deploying an Oracle Database Application," explains how to deploy an
Oracle Database application—that is, how to install it in one or more environments
where other users can run it—using the application developed in Chapter 9 as an
example.
About Oracle Database
Oracle Database groups related information into logical structures called schemas. The
logical structures are called schema objects. When you connect to the database by
providing your user name and password, you specify the schema and indicate that
you are its owner. In Oracle Database, the user name and the name of the schema to
which the user connects are the same.
This section contains:
■ About Schema Objects
■ About Oracle Database Access
About Schema Objects
Every object in an Oracle Database belongs to only one schema, and has a unique
name with that schema.
Some of the objects that schemas can contain are:
■ Ta bles
Tables are the basic units of data storage in Oracle Database. Tables hold all
user-accessible data. Each table contains rows that represent individual data
records. Rows are composed of columns that represent the fields of the records.
For more information, see "Creating and Managing Tables" on page 4-2.
■ Indexes
Indexes are optional objects that can improve the performance of data retrieval
from tables. Indexes are created on one or more columns of a table, and are
automatically maintained in the database. For more information, see "Managing
Indexes" on page 4-12.
■ Views
我的内容管理
展开
