tutorial

Publicado por

Gertz,(2ndATSimon:utorialpages,1orne,MicGuidehaelinGertzvDatabaseeyandforInformationyl,Systems1997.GroupesleyDepartmen(2ndtVofIncludesComputerbScience1997.UnivCorey:ersitThoroughy767ofFCalifornia,OraDaAssovisHughgertz@cs.ucdaStandardvis.eduMeltonhttp://www.db.SQL:csThe.uSystems,cduaryavtis.withedofuok),Thisw-Hill/OsbOracle/SQLhaeltutorialMicproclevidesGuideatrodetailedUsers]inMcGratroStevductionBilltoythePL/SQLSQLO'Reillyquery1028languageDateanden:thetheOracleEdition),Relational1997.DatabaseAlanManagementhetCompleteSystem.DecFKaufmannurtherManagemeninformation1ab1.01,outMicOracle2000.ander,SQLCDcanelectronicOracle/SQLersionfoundtheonothe1299wMcGraeborne,siteMicwww.db.cs.ucdavis.edu/dAbbbsand.haelCommenOrats,yrighcorrections,Beginner'sor[AadditionsIntoductiontheseFirst-timenotes,arepages,ww-Hill/Osbelcome.1997.Manenyeuerstein,thanksPribtoDebbChristinaRussell:ChcleungProgrammingforEdition),commen&tsciates,onpages,theC.J.previousandvDarwersion.ARecommendedtoLiteratureSQLGeorge(4thKoAddison-Wc,hJimandandKevinR.Loney:UnderstandingOraNewcleA8GuideTheEdition,Complete2000),ReferenceMorgan(TheSeriesSingleDataMosttCompre-2000.hensivrevisedeersionSourcebJano2000,ohaelkCopforOracleServbe8:ts605.2.2tenPro*CtsAb1.6 ...
Publicado el : sábado, 24 de septiembre de 2011
Lectura(s) : 25
Número de páginas: 66
Ver más Ver menos

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
gertz@cs.ucda
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
20-FEB-81
length
.
of
.
2GB.
:
Only
of
one
b
long
2
column
issuing
is
information
allo
7902
w
1250
ed
.
p
.
e
.
r
01-MAY-81
table.
wing
Note:
v
In
HIREDATE
Ora
the
cle
an
-SQL
a
there
of
is
the
no
dropp
data
drop
t
is
yp
y
e
DEPTNO
b
7499
o
WARD
olean
.
.
.
It
.
can,
.
ho
.
w
.
ev
.
er,
.
b
FORD
e
the
sim
es
ulated
t
b
JOB
y
um
using
SAL
either
:
c
ro
har
terpreted
(1)
has
or
a
n
urthermore,
um
n

date
stored.
shell
(1).
demobld
As
can
long
b
as
command
no
the
constrain
table
t
to
restricts
out
the
EMPNO
p
HIREDATE
ossible
SMITH
v
800
alues
SALESMAN
of
30
an
7698
attribute,
.
it
.
ma
.
y
.
ha
.
v
.
e
.
the
.
sp
.
ecial
.
v
.
alue
.
nul
.
l
.
(for
.
unkno
BLAKE
wn).
30
This
7566
v
F
alue
the
is
t
dieren
dened:
t
um
from
ENAME
the
har2
n
c
um
:
are
the
orking
date
0,
n
and
(7,2),
it
um
is
Eac
also
(tuple)
dieren
is
t
follo
from
y
the
n
empt
a
y
title
string
.
''
eac
.
ee
F
and
urther
manager,
prop
w
erties
UNIX
of
using
tables
command
are:
.

is
the
he/she
order
ed
in
y
whic
the
h
demo
tuples
under
app
UNIX
ear
The
in
EMP
a
used
table
store
is
ab
not
emplo
relev
ees:
an
ENAME
t
MGR
(unless
SAL
a
7369
query
CLERK
requires
17-DEC-80
an
20
explicit
ALLEN
sorting).
7698

1600
a
7521
table
SALESMAN
has
22-FEB-81
no
30
duplicate
.
tuples
.
(dep
.
ending
.
on
.
the
.
query
.
,
.
ho
.
w
.
ev
.
er,
.
duplicate
.
tuples
.
can
.
app
.
ear
.
in
.
the
.
query
.
result).
.
A
.
datab
.
ase
.
schema
.
is
.
a
.
set
.
of
.
relation
7698
sc
MANAGER
hemas.
3850
The
7902
extension
ANALYST
of
03-DEC-81
a
10
datab
or
ase
attributes,
schema
follo
at
data
database
yp
run-time
are
is
EMPNO
called
n
a
where
datab
(4),
ase
:
instanc
arc
e
(30),
or
:
datab
har
ase
MGR
,
n
for
departmen
short.
(4),
1.1.1
:
Example
,
Database
:
In
um
the
um
follo
DEPTNO
wing
n
discussions
n
and
(2)
examples
h
w
w
e
from
use
table
an
in
example
as
database
ws:
to
emplo
manage
ee
information
a
ab
um
out
er,
emplo
name,
y
job
ees,
and
departmen
salary
ts
F
and
for
salary
h
scales.
y
The
the
corresp
um
onding
hired,
tables
his/her
can
the
w
he/she
created
as
under
the
tables
be
r
be
r
be
be
be
r
be
r
be
r
be
r
be
r
be
r

¡Sé el primero en escribir un comentario!

13/1000 caracteres como máximo.

Difunda esta publicación

También le puede gustar