R 5ourc« C<xł« Ind** by Outp<m |RE3
Chapt*t I Ile H .lilie_t>es«i|>lit»n
1 |
»</cr<ftxksql |
Oemcnstrjtes ho*v you c*o couse a deaclock in you' p-ogram **ar. wkrng v.ith sutonon-ous transactions |
2 |
trcfunc sf |
Oennnstrates uae ol funciion to tracę SOL actr>f.y. a an ai.tonomcus transactwn r. can ovąn do a ccmmc |
.2 |
autnrscrial.snl |
Dcmanstrates tbc SERIA.IZABLE isolat on opiior for autoncmous traraactions |
.2_ |
»*J!0nln<W*r SB |
Damonstralas tbe u«e cł autononous Irans-adicns in dalabasą Ingge-s |
2 |
at/orlndaar; s |
Seccnd itaration dernonstrjtma ;hę use of -ulooomous trsnsadioni In databai* Piuae*s |
2 |
:l Tnrd tcratior dcmoritraling Ihc usc of autoncmous trarsact ons in databaso tricgers THs wsion sbcws thal a RAJSE in the AUIONOMOUSJRWSACnON prochu* wll causa ar atlcmai*:. rolback of the OML >/**?? serso, r's ih» too-fe**! bloc< in :h» iransacticn | |
2 |
I □ q£: 1 cŁ.a |
Packaac that dcn-onsPatcs loaaina as an auloiDmous liansprljon |
2_ |
Oemonstrates use of the oy3l package | |
2_ |
loofilb lat |
Aoalyięsthę oretoead ofusmo autooornoiistiansąclicn? |
2_ |
Damonstratas nastna ?f aitnromcus ttansactuns | |
2_ |
rrfr^.pli.y |
A p-.nkjye l-ul dtmunslialt^. j *ielty* ul lity L^ri) jjlcnumjus transaŁliur-s |
2 |
fĄlf V tst |
Tost scnot :o demonstrote tho recry po:* w |
rurf3am.sD |
Damonstration of dvnamc PL/SQ_ błock exacu;iDn vnlh n*:r»B dynamie SOL | |
3 |
aiithid.’ |
A s« of fnrs ured to denon-strate the AIJTHO fealure cl OractSi The aulnid.sql fić runs al r.wmands ir or* seouercą You csri r jn the otb.ar aufnd * Ileś. to erącuto ?.oecific -aeticn; |
J_ |
Contams a basie demonst-ation crAUTHD C JRRENT USERfeaturs | |
j_ |
authid3.scl |
Conlains a basie dgnuHisLatrjn i/AUTHD CURRENT USER fealire. |
3 |
Oemnnstraion of Ai.fTHCu1fi>o«er fjnetonahty in włuch l blend shared scces-s to F*-p«'*oi tahls 'Aith indr.irli.aitctI s-harra tablas for stolanjnus This senpt assumas thal you ham -Atrtauj.Ł^nht '.:iuatu. runi ym.«. *iil HQ ł.litmai. afytiB vrr.li Ib.gj latilaa a ud pistmltm. |
3 d'/.l iiJ5 sol Demonatration of cocnbination of DGFINER arid CURRENT_U3ER aceess to blond siiaied
_vwi imlM*i4n^l _