background image
<< Introducing Schema Objects | Introducing SQL Developer >>
<< Introducing Schema Objects | Introducing SQL Developer >>

Application Development with Oracle Database

Overview of Application Development with Oracle Database
Overview of Oracle Database and Development 1-3
created on one or more columns of a table, and are automatically maintained in Oracle
Database. See
"Creating and Using Tables"
on page 3-2.
Depending on your business needs, you can create a view that combines information
from several different tables into a single presentation. Such views can rely on
information from other views as well as tables. See
"Using Views"
on page 3-21.
In an application where all records of the table must be distinct, a sequence can
generate a serial list of unique integer numbers for a numeric column that represents
the ID of each record. See
"Using Sequences"
on page 3-25.
A synonym is an alias for any table, view, sequence, procedure, and so on. Synonyms
are often used for security and convenience, such as masking the ownership of an
object or simplifying SQL statements. See
"Using Synonyms"
on page 3-28.
Schema-level procedures and functions, and also packages, are collectively known as
stored procedures
. Stored procedures are blocks of code that are actually stored in the
database. They are callable from client applications that access a relational database
system. See
"Developing and Using Stored Procedures"
on page 4-1.
Triggers
are procedural code that is automatically executed by the database when
specified events occur in a particular table or view. Triggers can restrict access to
specific data, perform logging, or audit data. See
"Using Triggers"
on page 5-1.
Introducing the HR Schema
The
hr
schema is one of the sample schemas that can be installed as part of Oracle
Database. The
hr
sample schema contains information about employees, their
departments and locations, their work histories, and other related information. Like all
schemas, the
hr
schema has tables, views, indexes, procedures, functions, and all other
possible attributes of an Oracle Database schema.
You will be using and extending the
hr
schema to learn how to develop applications
with Oracle Database.
Overview of Application Development with Oracle Database
In this section, you will learn about two programming languages for direct data access
(SQL and PL/SQL), two development tools (SQL Developer and SQL*Plus), a sample
data set (
hr
schema), and how to connect to an instance of Oracle Database.
Introducing SQL and PL/SQL Development Languages
There are two broad families of computer languages: declarative languages that
describe what should be done, and imperative languages that describe how things
should be done. You are probably already familiar with the Structured Query
See Also:
Oracle Database Concepts for a comprehensive introduction to all
schema objects
See Also:
Oracle Database Sample Schemas for an in-depth description of the
hr
sample schema
See Also:
Oracle Database Advanced Application Developer's Guide