Question

Database Administration

In a sequence what is the difference between NEXTVAL and CURRVAL? How is CURRVAL used, and what is its purpose?

What exceptions should be trapped for an Update procedure?

Oracle also supports a MERGE command. What does this do, and how is it different from this week's Insert/Update procedure?

What is the purpose of an INSTEAD OF trigger?

Answer 1

ー一且一sea uende is a schema object seuential valu geaecales unique for pinnay e unique keys 1Ale-car access this-value-et-Sea uen uence e can detihe tsinitial value. When we tiist time-us -Lt-returns s als initial value After each subsequent zefsrences e ethat net generaledl value is Hence functian of NEXTVAL is incscmen ユ sequence value increament iven inciemeat e generatinag new values

PAGE No insert-into customer values Store ustames details into customea table Whenever-te e-veter _coRAWAL_9 current value isthe value zetunned last ⓗ scherna.sequence..co RRV A 1 Examele The abo e eka m ple will elect cu n value of custo roer seg uence

Fos updadte you can tap exceptian ike Cade duplicate Vals fax then sich has uni ndex e can also ta YaLVE ERRsE ERGE Command simp le le aperations wa tn combine ofinsert update e clelet ply avoid state meats Mera e data sourcewith heeded cla tabase Lable ar database -table e -1 statement allows-부ou-da-e01n t is intaduced in aracle able Scans are reduced due to merge pe le

DATE PAGE Ne Merge stalemeat pefus fallowi thin upda database table by usins canditisns equired table one or mare caluans inseded into neo oos tables (andale-t delete et -table based a-tdY on cliffernces oita sourre data agers ase defined an datahase tables or datahase tahle ieu Theu ase useful in ex af updae view instead ot biggec is used t exfarm valuear enor check ables before insexting the clata records e mare columas of davahase al action Examplewe insect rawin dlababase associated with table instead of t pass this event accuxs beore 一through an checks of errata、nts instead of gger