HOLY BIBLE
ace ,
af_2 ,
al ,
albanian ,
am ,
ar ,
asv ,
basic_english ,
ben ,
bg ,
big5 ,
big5_cath ,
bulgarian ,
ceb ,
cebuano ,
chinese_big5 ,
chinese_gb ,
cr ,
cz ,
darby ,
de ,
dk ,
douay ,
drc ,
dutch ,
fa ,
fi ,
fj ,
fr ,
french ,
gaelic_manx ,
gaelic_scots ,
gb ,
gb_cat ,
german ,
gk ,
gk_2 ,
guj ,
haitian_creole ,
he ,
hebrew ,
hu ,
hungarian ,
id_tb ,
in ,
in_tr ,
is ,
it ,
jp ,
kj ,
kjv20 ,
kjvapocrypha ,
kjvlarge ,
kk ,
kn ,
korean ,
kr ,
latvian_nt ,
lug ,
maori ,
mar ,
ml ,
mn ,
moderngreek ,
my ,
ne ,
nl ,
no ,
or ,
pa ,
pl ,
pn ,
po ,
po-BR ,
ro ,
ru ,
rumanian ,
russian_1251 ,
russian_ko18r ,
se ,
si ,
so ,
sp ,
spanish ,
sr ,
sw ,
swahili_nt ,
swedish ,
tagalog ,
thaibible ,
tl ,
tr ,
uk ,
ukrainian ,
uma_nt ,
ur ,
vg ,
vietnamese ,
vietnamesevni ,
vt ,
vulgate ,
web ,
webster ,
weymouth ,
xho_2 ,
youngs ,
zu_2 ,
PROJECT
GUTENBERG
Afrikaans ,
Aleut ,
Arapaho ,
Breton ,
Bulgarian ,
Cal ,
Catalan ,
Cebuano ,
Chinese ,
Czech ,
Danish ,
Dutch ,
Esperanto ,
Finnish ,
French ,
Frisian ,
Friulian ,
Gaelic,
Scottish , Galician ,
Gamilaraay ,
German ,
Giangan ,
Greek ,
Hebrew ,
Hungarian ,
Icelandic ,
Iloko ,
Interlingua ,
Inuktitut ,
Irish ,
Iroquoian ,
Italian ,
Japanese ,
Kashubian ,
Khasi ,
Korean ,
Latin ,
Lithuanian ,
Maori ,
Mayan
Languages , Middle
English , Nahuatl ,
Napoletano-Calabrese ,
North
American Indian , Norwegian ,
Occitan ,
Old
English , Polish ,
Portuguese ,
Romanian ,
Russian ,
Sanskrit ,
Serbian ,
Spanish ,
Swedish ,
Tagalog ,
Welsh ,
Yiddish
Database trigger - Wikipedia, the free encyclopedia Wikipedia (2007) - wikipedia2007.classicistranieri.com
Database trigger
From Wikipedia, the free encyclopedia
A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database . Triggers can restrict access to specific data, perform logging, or audit data modifications.
There are two classes of triggers, they are either "row triggers" or "statement triggers". With row triggers you can define an action for every row of a table, while statement triggers occur only once per INSERT , UPDATE , or DELETE statement. Triggers cannot be used to audit data retrieval.
Each class can be of several types. There are "BEFORE triggers" and "AFTER triggers" which identifies the time of execution of the trigger. There is also an "INSTEAD OF trigger" which is a conditional trigger that will fire instead of the triggering statement. However, "INSTEAD OF trigger" are available only for views .
There are typically three triggering EVENTS that cause trigger to 'fire':
INSERT event (as a new record is being inserted into the database).
UPDATE event (as a record is being changed).
DELETE event (as a record is being deleted).
The SQL:2003 standard mandates that triggers give programmers access to record variables by means of a syntax such as REFERENCING NEW AS n . For example, if a trigger is monitoring for changes to a salary column one could write a trigger like the following:
CREATE TRIGGER salary_trigger
BEFORE UPDATE ON employee_table
REFERENCING NEW ROW AS n, OLD ROW AS o
FOR EACH ROW
IF n.salary <> o.salary THEN
do something here
END IF;
The major features and effects of database triggers are that they:
do not accept parameters or arguments
cannot perform commit or rollback operations because they are part of the triggering SQL statement (only through autonomous transactions)
can cause mutating table errors, if they are poorly written.
[edit ] Triggers in Oracle
In addition to triggers that fire when data is modified, Oracle 9i supports triggers that fire when schema objects (that is, tables) are modified and when user logon or logoff events occur. These trigger types are referred to as "Schema-level triggers".
Schema-level triggers
Before Create
After Create
Before Alter
After Alter
Before Drop
After Drop
Before Logoff
After Logon
[edit ] Triggers in Microsoft SQL Server
Microsoft SQL Server supports triggers either after or instead of an insert, update, or delete operation.
Microsoft SQL Server 2005 introduced support for Data Definition Language (DDL) triggers, which can fire in reaction to a very wide range of events, including:
Drop table
Create table
Alter table
Login events
A full list is available on MSDN.
[edit ] Triggers in PostgreSQL
PostgreSQL introduced support for triggers in 1997. The following functionality in SQL:2003 is not implemented in PostgreSQL:
SQL allows triggers to fire on updates to specific columns; PostgreSQL does not support this feature.
The standard allows the execution of a number of other SQL statements than SELECT, INSERT, UPDATE, such as CREATE TABLE as the triggered action.
[edit ] Triggers in MySQL
MySQL 5.0 introduced support for triggers. Some of the triggers MYSQL supports are
INSERT Trigger
UPDATE Trigger
DELETE Trigger
select * from customartiss;
[edit ] External links
STATIC WIKIPEDIA JUNE
2008 on wikipedia2006.classicistranieri.com
aa
- ab
- af
- ak
- als
- am
- an
- ang
- ar
- arc
- as
- ast
- av
- ay
- az
- ba
- bar
- bat_smg
- bcl
- be
- be_x_old
- bg
- bh
- bi
- bm
- bn
- bo
- bpy
- br
- bs
- bug
- bxr
- ca
- cbk_zam
- cdo
- ce
- ceb
- ch
- cho
- chr
- chy
- co
- cr
- crh
- cs
- csb
- cu
- cv
- cy
- da
- de
- diq
- dsb
- dv
- dz
- ee
- el
- eml
- en
- eo
- es
- et
- eu
- ext
- fa
- ff
- fi
- fiu_vro
- fj
- fo
- fr
- frp
- fur
- fy
- ga
- gan
- gd
- gl
- glk
- gn
- got
- gu
- gv
- ha
- hak
- haw
- he
- hi
- hif
- ho
- hr
- hsb
- ht
- hu
- hy
- hz
- ia
- id
- ie
- ig
- ii
- ik
- ilo
- io
- is
- it
- iu
- ja
- jbo
- jv
- ka
- kaa
- kab
- kg
- ki
- kj
- kk
- kl
- km
- kn
- ko
- kr
- ks
- ksh
- ku
- kv
- kw
- ky
- la
- lad
- lb
- lbe
- lg
- li
- lij
- lmo
- ln
- lo
- lt
- lv
- map_bms
- mdf
- mg
- mh
- mi
- mk
- ml
- mn
- mo
- mr
- mt
- mus
- my
- myv
- mzn
- na
- nah
- nap
- nds
- nds_nl
- ne
- new
- ng
- nl
- nn
- no
- nov
- nrm
- nv
- ny
- oc
- om
- or
- os
- pa
- pag
- pam
- pap
- pdc
- pi
- pih
- pl
- pms
- ps
- pt
- qu
- quality
- rm
- rmy
- rn
- ro
- roa_rup
- roa_tara
- ru
- rw
- sa
- sah
- sc
- scn
- sco
- sd
- se
- sg
- sh
- si
- simple
- sk
- sl
- sm
- sn
- so
- sr
- srn
- ss
- st
- stq
- su
- sv
- sw
- szl
- ta
- te
- tet
- tg
- th
- ti
- tk
- tl
- tlh
- tn
- to
- tpi
- tr
- ts
- tt
- tum
- tw
- ty
- udm
- ug
- uk
- ur
- uz
- ve
- vec
- vi
- vls
- vo
- wa
- war
- wo
- wuu
- xal
- xh
- yi
- yo
- za
- zea
- zh
- zh_classical
- zh_min_nan
- zh_yue
- zu
STATIC WIKIPEDIA MARCH
2008 on wikipedia2006classicistranieri.com
aa ,
ab ,
af ,
ak ,
als ,
am ,
an ,
ang ,
ar ,
arc ,
as ,
ast ,
av ,
ay ,
az ,
ba ,
bar ,
bat_smg ,
be ,
bg ,
bh ,
bi ,
bm ,
bn ,
bo ,
bpy ,
br ,
bs ,
bug ,
bxr ,
ca ,
cbk_zam ,
cdo ,
ce ,
ceb ,
ch ,
cho ,
chr ,
chy ,
closed_zh_tw ,
co ,
cr ,
cs ,
csb ,
cu ,
cv ,
cy ,
da ,
de ,
diq ,
dv ,
dz ,
ee ,
el ,
eml ,
en ,
eo ,
es ,
et ,
eu ,
fa ,
ff ,
fi ,
fiu_vro ,
fj ,
fo ,
fr ,
frp ,
fur ,
fy ,
ga ,
gd ,
gl ,
glk ,
gn ,
got ,
gu ,
gv ,
ha ,
haw ,
he ,
hi ,
ho ,
hr ,
hsb ,
ht ,
hu ,
hy ,
hz ,
ia ,
id ,
ie ,
ig ,
ii ,
ik ,
ilo ,
io ,
is ,
it ,
iu ,
ja ,
jbo ,
jv ,
ka ,
kg ,
ki ,
kj ,
kk ,
kl ,
km ,
kn ,
ko ,
kr ,
ks ,
ksh ,
ku ,
kv ,
kw ,
ky ,
la ,
lad ,
lb ,
lbe ,
lg ,
li ,
lij ,
lmo ,
ln ,
lo ,
lt ,
lv ,
map_bms ,
mg ,
mh ,
mi ,
mk ,
ml ,
mn ,
mo ,
mr ,
ms ,
mt ,
mus ,
my ,
mzn ,
na ,
nah ,
nap ,
nds ,
nds_nl ,
ne ,
new ,
ng ,
nl ,
nn ,
no ,
nov ,
nrm ,
nv ,
ny ,
oc ,
om ,
or ,
os ,
pa ,
pag ,
pam ,
pap ,
pdc ,
pi ,
pih ,
pl ,
pms ,
ps ,
pt ,
qu ,
rm ,
rmy ,
rn ,
ro ,
roa_rup ,
roa_tara ,
ru ,
ru_sib ,
rw ,
sa ,
sc ,
scn ,
sco ,
sd ,
se ,
searchcom ,
sg ,
sh ,
si ,
simple ,
sk ,
sl ,
sm ,
sn ,
so ,
sq ,
sr ,
ss ,
st ,
su ,
sv ,
sw ,
ta ,
te ,
test ,
tet ,
tg ,
th ,
ti ,
tk ,
tl ,
tlh ,
tn ,
to ,
tokipona ,
tpi ,
tr ,
ts ,
tt ,
tum ,
tw ,
ty ,
udm ,
ug ,
uk ,
ur ,
uz ,
ve ,
vec ,
vi ,
vls ,
vo ,
wa ,
war ,
wo ,
wuu ,
xal ,
xh ,
yi ,
yo ,
za ,
zea ,
zh ,
zh_classical ,
zh_min_nan ,
zh_yue ,
zu .
STATIC WIKIPEDIA APRIL
2007 on wikipedia2006classicistranieri.com
aa ,
ab ,
af ,
ak ,
als ,
am ,
an ,
ang ,
ar ,
arc ,
as ,
ast ,
av ,
ay ,
az ,
ba ,
bar ,
bat_smg ,
be ,
bg ,
bh ,
bi ,
bm ,
bn ,
bo ,
bpy ,
br ,
bs ,
bug ,
bxr ,
ca ,
cbk_zam ,
cdo ,
ce ,
ceb ,
ch ,
cho ,
chr ,
chy ,
closed_zh_tw ,
co ,
cr ,
cs ,
csb ,
cu ,
cv ,
cy ,
da ,
de ,
diq ,
dv ,
dz ,
ee ,
el ,
eml ,
en ,
eo ,
es ,
et ,
eu ,
fa ,
ff ,
fi ,
fiu_vro ,
fj ,
fo ,
fr ,
frp ,
fur ,
fy ,
ga ,
gd ,
gl ,
glk ,
gn ,
got ,
gu ,
gv ,
ha ,
haw ,
he ,
hi ,
ho ,
hr ,
hsb ,
ht ,
hu ,
hy ,
hz ,
ia ,
id ,
ie ,
ig ,
ii ,
ik ,
ilo ,
io ,
is ,
it ,
iu ,
ja ,
jbo ,
jv ,
ka ,
kg ,
ki ,
kj ,
kk ,
kl ,
km ,
kn ,
ko ,
kr ,
ks ,
ksh ,
ku ,
kv ,
kw ,
ky ,
la ,
lad ,
lb ,
lbe ,
lg ,
li ,
lij ,
lmo ,
ln ,
lo ,
lt ,
lv ,
map_bms ,
mg ,
mh ,
mi ,
mk ,
ml ,
mn ,
mo ,
mr ,
ms ,
mt ,
mus ,
my ,
mzn ,
na ,
nah ,
nap ,
nds ,
nds_nl ,
ne ,
new ,
ng ,
nl ,
nn ,
no ,
nov ,
nrm ,
nv ,
ny ,
oc ,
om ,
or ,
os ,
pa ,
pag ,
pam ,
pap ,
pdc ,
pi ,
pih ,
pl ,
pms ,
ps ,
pt ,
qu ,
rm ,
rmy ,
rn ,
ro ,
roa_rup ,
roa_tara ,
ru ,
ru_sib ,
rw ,
sa ,
sc ,
scn ,
sco ,
sd ,
se ,
searchcom ,
sg ,
sh ,
si ,
simple ,
sk ,
sl ,
sm ,
sn ,
so ,
sq ,
sr ,
ss ,
st ,
su ,
sv ,
sw ,
ta ,
te ,
test ,
tet ,
tg ,
th ,
ti ,
tk ,
tl ,
tlh ,
tn ,
to ,
tokipona ,
tpi ,
tr ,
ts ,
tt ,
tum ,
tw ,
ty ,
udm ,
ug ,
uk ,
ur ,
uz ,
ve ,
vec ,
vi ,
vls ,
vo ,
wa ,
war ,
wo ,
wuu ,
xal ,
xh ,
yi ,
yo ,
za ,
zea ,
zh ,
zh_classical ,
zh_min_nan ,
zh_yue ,
zu .
STATIC WIKIPEDIA DECEMBER 2006 on wikipedia2006classicistranieri.com
aa ,
ab ,
af ,
ak ,
als ,
am ,
an ,
ang ,
ar ,
arc ,
as ,
ast ,
av ,
ay ,
az ,
ba ,
bar ,
bat_smg ,
be ,
bg ,
bh ,
bi ,
bm ,
bn ,
bo ,
bpy ,
br ,
bs ,
bug ,
bxr ,
ca ,
cbk_zam ,
cdo ,
ce ,
ceb ,
ch ,
cho ,
chr ,
chy ,
closed_zh_tw ,
co ,
cr ,
cs ,
csb ,
cu ,
cv ,
cy ,
da ,
de ,
diq ,
dv ,
dz ,
ee ,
el ,
eml ,
en ,
eo ,
es ,
et ,
eu ,
fa ,
ff ,
fi ,
fiu_vro ,
fj ,
fo ,
fr ,
frp ,
fur ,
fy ,
ga ,
gd ,
gl ,
glk ,
gn ,
got ,
gu ,
gv ,
ha ,
haw ,
he ,
hi ,
ho ,
hr ,
hsb ,
ht ,
hu ,
hy ,
hz ,
ia ,
id ,
ie ,
ig ,
ii ,
ik ,
ilo ,
io ,
is ,
it ,
iu ,
ja ,
jbo ,
jv ,
ka ,
kg ,
ki ,
kj ,
kk ,
kl ,
km ,
kn ,
ko ,
kr ,
ks ,
ksh ,
ku ,
kv ,
kw ,
ky ,
la ,
lad ,
lb ,
lbe ,
lg ,
li ,
lij ,
lmo ,
ln ,
lo ,
lt ,
lv ,
map_bms ,
mg ,
mh ,
mi ,
mk ,
ml ,
mn ,
mo ,
mr ,
ms ,
mt ,
mus ,
my ,
mzn ,
na ,
nah ,
nap ,
nds ,
nds_nl ,
ne ,
new ,
ng ,
nl ,
nn ,
no ,
nov ,
nrm ,
nv ,
ny ,
oc ,
om ,
or ,
os ,
pa ,
pag ,
pam ,
pap ,
pdc ,
pi ,
pih ,
pl ,
pms ,
ps ,
pt ,
qu ,
rm ,
rmy ,
rn ,
ro ,
roa_rup ,
roa_tara ,
ru ,
ru_sib ,
rw ,
sa ,
sc ,
scn ,
sco ,
sd ,
se ,
searchcom ,
sg ,
sh ,
si ,
simple ,
sk ,
sl ,
sm ,
sn ,
so ,
sq ,
sr ,
ss ,
st ,
su ,
sv ,
sw ,
ta ,
te ,
test ,
tet ,
tg ,
th ,
ti ,
tk ,
tl ,
tlh ,
tn ,
to ,
tokipona ,
tpi ,
tr ,
ts ,
tt ,
tum ,
tw ,
ty ,
udm ,
ug ,
uk ,
ur ,
uz ,
ve ,
vec ,
vi ,
vls ,
vo ,
wa ,
war ,
wo ,
wuu ,
xal ,
xh ,
yi ,
yo ,
za ,
zea ,
zh ,
zh_classical ,
zh_min_nan ,
zh_yue ,
zu .
STATIC WIKIPEDIA NOVEMBER
2006 on wikipedia 2007classicistranieri.com
aa ,
ab ,
af ,
ak ,
als ,
am ,
an ,
ang ,
ar ,
arc ,
as ,
ast ,
av ,
ay ,
az ,
ba ,
bar ,
bat_smg ,
be ,
bg ,
bh ,
bi ,
bm ,
bn ,
bo ,
bpy ,
br ,
bs ,
bug ,
bxr ,
ca ,
cbk_zam ,
cdo ,
ce ,
ceb ,
ch ,
cho ,
chr ,
chy ,
closed_zh_tw ,
co ,
cr ,
cs ,
csb ,
cu ,
cv ,
cy ,
da ,
de ,
diq ,
dv ,
dz ,
ee ,
el ,
eml ,
en ,
eo ,
es ,
et ,
eu ,
fa ,
ff ,
fi ,
fiu_vro ,
fj ,
fo ,
fr ,
frp ,
fur ,
fy ,
ga ,
gd ,
gl ,
glk ,
gn ,
got ,
gu ,
gv ,
ha ,
haw ,
he ,
hi ,
ho ,
hr ,
hsb ,
ht ,
hu ,
hy ,
hz ,
ia ,
id ,
ie ,
ig ,
ii ,
ik ,
ilo ,
io ,
is ,
it ,
iu ,
ja ,
jbo ,
jv ,
ka ,
kg ,
ki ,
kj ,
kk ,
kl ,
km ,
kn ,
ko ,
kr ,
ks ,
ksh ,
ku ,
kv ,
kw ,
ky ,
la ,
lad ,
lb ,
lbe ,
lg ,
li ,
lij ,
lmo ,
ln ,
lo ,
lt ,
lv ,
map_bms ,
mg ,
mh ,
mi ,
mk ,
ml ,
mn ,
mo ,
mr ,
ms ,
mt ,
mus ,
my ,
mzn ,
na ,
nah ,
nap ,
nds ,
nds_nl ,
ne ,
new ,
ng ,
nl ,
nn ,
no ,
nov ,
nrm ,
nv ,
ny ,
oc ,
om ,
or ,
os ,
pa ,
pag ,
pam ,
pap ,
pdc ,
pi ,
pih ,
pl ,
pms ,
ps ,
pt ,
qu ,
rm ,
rmy ,
rn ,
ro ,
roa_rup ,
roa_tara ,
ru ,
ru_sib ,
rw ,
sa ,
sc ,
scn ,
sco ,
sd ,
se ,
searchcom ,
sg ,
sh ,
si ,
simple ,
sk ,
sl ,
sm ,
sn ,
so ,
sq ,
sr ,
ss ,
st ,
su ,
sv ,
sw ,
ta ,
te ,
test ,
tet ,
tg ,
th ,
ti ,
tk ,
tl ,
tlh ,
tn ,
to ,
tokipona ,
tpi ,
tr ,
ts ,
tt ,
tum ,
tw ,
ty ,
udm ,
ug ,
uk ,
ur ,
uz ,
ve ,
vec ,
vi ,
vls ,
vo ,
wa ,
war ,
wo ,
wuu ,
xal ,
xh ,
yi ,
yo ,
za ,
zea ,
zh ,
zh_classical ,
zh_min_nan ,
zh_yue ,
zu .