tutorial

Informations

• Publié par: Ornui
• Nombre de lectures: 27
• Langue: Español

Extrait

Gertz,
(2nd
A
T
Simon:
utorial
pages,
1
orne,
Mic
Guide
hael
in
Gertz
v
Database
ey
and
for
Information
yl,
Systems
1997.
Group
esley
Departmen
(2nd
t
V
of
Includes
Computer
b
Science
1997.
Univ
Corey:
ersit
Thorough
y
767
of
F
California,
Ora
Da
Asso
vis
Hugh
[e-mail]
Standard
vis.edu
Melton
http://www.db.
SQL:
cs
The
.u
Systems,
cd
uary
av
t
is.
with
ed
of
u
ok),
This
w-Hill/Osb
Oracle/SQL
hael
tutorial
Mic
pro
cle
vides
Guide
a
tro
detailed
Users]
in
McGra
tro
Stev
duction
Bill
to
y
the
PL/SQL
SQL
O'Reilly
query
1028
language
Date
and
en:
the
the
Oracle
Edition),
Relational
1997.
Database
Alan
Managemen
the
t
Complete
System.
Dec
F
Kaufmann
urther
Managemen
information
1
ab
1.01,
out
Mic
Oracle
2000.
and
er,
SQL
CD
can
electronic
Oracle/SQL
ersion
found
the
on
o
the
1299
w
McGra
eb
orne,
site
Mic
www.db.cs.ucdavis.edu/d
Abb
bs
and
.
hael
Commen
Ora
ts,
yrigh
corrections,
Beginner's
or
[A
additions
In
to
duction
these
First-time
notes
,
are
pages,
w
w-Hill/Osb
elcome.
1997.
Man
en
y
euerstein,
thanks
Prib
to
Debb
Christina
Russell:
Ch
cle
ung
Programming
for
Edition),
commen
&
ts
ciates,
on
pages,
the
C.J.
previous
and
v
Darw
ersion.
A
Recommended
to
Literature
SQL
George
(4th
Ko
Addison-W
c
,
h
Jim
and
and
Kevin
R.
Loney:
Understanding
Ora
New
cle
A
8
Guide
The
Edition,
Complete
2000),
Reference
Morgan
(The
Series
Single
Data
Most
t
Compre-
2000.
hensiv
revised
e
ersion
Sourceb
Jan
o
2000,
o
hael
k
Cop
for
Oracle
Serv
be
8:ts
60
5.2.2
ten
Pro*C
ts
Ab
1.
6.
SQL
63
{
and
Structured
F
Query
49
Language
T
1.1.
and
T
Steps
ables
b
1
tegrit
1.2.
In
Queries
Constrain
(P
ts
art
T
I)
5.2.1
3
riggers
1.3.
Programming
Data
6.1.
Denition
6.2.
in
Database
SQL
an
6
63
1.4.
SQL
Data
5.
Mo
Constrain
dications
riggers
in
y
SQL
Chec
9
46
1.5.
Key
Queries
5.1.3
(P
Column-
art
Constrain
Con
T
jects
erview
11
of
1.6.
5.2.3
Views
53
19
riggers
2.
Arc
SQL*Plus
Managemen
(Minimal
cesses
User
Database
Guide,
Ph
Editor
61
Commands,
Pro
Help
Statemen
System)
Creating
20
Ob
3.
edded
Oracle
and
Data
39
Dictionary
In
23
y
4.
ts
Application
T
Programming
5.1.
4.1.
tegrit
PL/SQL
Constrain
4.1.1
5.1.1
In
k
tro
ts
duction
5.1.2
26
oreign
4.1.2
Constrain
Structure
47
of
More
PL/SQL
out
Blo
and
c
able
ks
ts
27
5.2.
4.1.3
riggers
Declarations
Ov
27
50
4.1.4
Structure
Language
T
Elemen
50
ts
Example
28
riggers
4.1.5
5.2.4
Exception
T
Handling
55
32
System
4.1.6
hitecture
Pro
Storage
cedures
t
and
Pro
F
58
unctions
Logical
34
Structures
4.1.7
6.3.
P
ysical
ac
Structures
k
6.4.
ages
in
36
cessing
4.1.8
SQL
Programming
t
in
6.5.
PL/SQL
Database
38
4.2.
Em
II
)data
n
padded
SQL
n
{
c
Structured
c
Query
and
Language
ed
1.1
data
T
cle
ables
e
In
Only
relational
and
database
um
systems
an
(DBS)
ely
data
formats.
are
n
represen
n
ted
yp
using
length
tables
v
(
n
r
require
elations
Numeric
).
The
A
for
query
to
issued
n
against
in
the
t[eger]
DBS
domains
also
b
results
the
in

a
haracter
table.
maxim
A
ytes
table
a
has
is
the
with
follo
(
wing
c
structure:
n
Column
maxim
1
in
Column
used
2
arc
1
(
Column
e
n
v

d
T
to
uple
p
(or
=38,
Record)
um
'07-JAN-98'
(5,2)
'13-OCT-94',
(5,2)
:
999.99
Examples
t
A
.
table
smallin
is
P
uniquely
alphan
iden
n
tied
and
b
cle
y
wing
its
yp
name
har
and
Fixed-length
consists
(string),
of
long.
r
size
ows
255
that
in
con
Note
tain
of
the
c
stored
a
informa-
righ
tion,
to
eac
n
DD-MMM-YY.
can
is:
consuming).
w
(40)
con
har2
taining
V
exactly
string.
one
size
tuple
2000
(or
cle
r
b
e
a
c
Example:
or
(80)
d
for
).
d
A
t
table
in
can
o
ha
n
v
of
e
n
one
of
or
righ
more
yp
columns.
t.
A
alues:
c
=
olumn
Examples:
is
data
made
Date
up
that,
of
date
a
con
column
larger
name
result-
and
error.
a
es
data
n
t
are
yp
dec[imal]
e,
and
and
.
it
ossible
describ
are
es
umeric
an
(strings),
attribute
um
of
a
the
date
tuples.
Ora
The
oers
structure
follo
of
basic
a
t
table,
es:
also
c
called
(
r
):
elation
c
schema
data
,
n
th
haracters
us
The
is
um
dened
for
b
is
y
b
its
(2000
attributes.
Ora
The
8).
t
that
yp
string
e
t
of
e
information
har
to
alw
date
ys
stored
on
in
t
a
blanks
table
full
is
of
dened
.
b
+
y
b
the
memory
data
Example:
t
har
yp

es
arc
of
(
the
):
attributes
ariable-length
at
haracter
table
The
creation
um
time.
for
SQL
is
uses
(4000
the
Ora
terms
8).
table,
the
r
ytes
ow
for
,
string
and
storage.
c
v
olumn
har2
for

r
um
elation,
format
tuple
o;
,
):
and
data
attribute
yp
,
for
resp
tegers
ectiv
reals.
ely
default
.
erall
In
um
this
time.
tutorial
digits,
w
=
e
um
will
date
use
digits
the
the
terms
storing
in
e
terc
decimal
hangeably
oin
.
Maxim
A
v
table
o
can
d
ha
84
v
+127.
e
n
up
t
to
(8),
254
um
columns
:
whic
Note
h
e.g.,
ma
um
y

ha
cannot
v
tain
e
ything
dieren
than
t
without
or
ing
same
an
data
Data
t
yp
yp
deriv
es
from
and
um
sets
real
of
in
v
,
alues
,
(domains),
t
resp
1
ectiv
ers
:::
:::
:::
:::
:::
hr
o
be
be
r
=o
be
r
be
r
to
ft
h
e
be
r
be
r
be
r
be
rThe
3000
.
long
the
:
JOB
Character
.
data
(10),
up
emplo
to
shell.
a