Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)

✍ Scribed by Kevin Owens

• Publisher: Prentice Hall PTR
• Year: 2003
• Tongue: English
• Leaves: 320
• Edition: 3
• Category: Library

✦ Synopsis

Advanced Oracle features such as triggers and stored procedures make itpossible to build databases that incorporate business rules - allowing companiesto reengineer processes more quickly and effectively than ever. This is the"bible" for anyone designing complex Oracle databases that incorporatebusiness rules, and it is fully compliant with Oracle 10g. The book presents asimple methodology which yields a highly-maintainable repository of triggersand stored procedures which are easy to manage and modify as the businesschanges. Topics covered include: declarative constraints; analyzing constraintsthrough the data dictionary; PL/SQL program units; embedded SQL; datatypes and composite structures; error handling and exceptions; andinterprocess communication.A trigger is a condition, which if true, causes a stored procedure to execute.Stored procedures are SQL code embedded in the database that providescritical information to the end user when triggered.

✦ Table of Contents

temp0002.html......Page 1
temp0003.html......Page 4
temp0004.html......Page 5
temp0006.html......Page 6
temp0007.html......Page 7
temp0008.html......Page 8
temp0010.html......Page 9
temp0011.html......Page 10
temp0012.html......Page 12
temp0013.html......Page 17
temp0014.html......Page 19
temp0015.html......Page 21
temp0016.html......Page 27
temp0017.html......Page 30
temp0018.html......Page 31
temp0019.html......Page 33
temp0020.html......Page 34
temp0022.html......Page 37
temp0023.html......Page 38
temp0024.html......Page 46
temp0025.html......Page 48
temp0026.html......Page 51
temp0027.html......Page 55
temp0029.html......Page 57
temp0030.html......Page 58
temp0031.html......Page 59
temp0032.html......Page 60
temp0033.html......Page 62
temp0034.html......Page 64
temp0035.html......Page 87
temp0036.html......Page 91
temp0037.html......Page 109
temp0038.html......Page 115
temp0039.html......Page 116
temp0040.html......Page 117
temp0041.html......Page 118
temp0042.html......Page 119
temp0043.html......Page 122
temp0045.html......Page 123
temp0046.html......Page 124
temp0047.html......Page 128
temp0048.html......Page 134
temp0049.html......Page 135
temp0050.html......Page 136
temp0052.html......Page 138
temp0054.html......Page 139
temp0056.html......Page 147
temp0057.html......Page 148
temp0058.html......Page 150
temp0059.html......Page 153
temp0060.html......Page 155
temp0061.html......Page 156
temp0062.html......Page 163
temp0063.html......Page 164
temp0064.html......Page 165
temp0065.html......Page 166
temp0066.html......Page 168
temp0067.html......Page 170
temp0068.html......Page 173
temp0069.html......Page 174
temp0070.html......Page 178
temp0071.html......Page 182
temp0072.html......Page 183
temp0073.html......Page 188
temp0074.html......Page 190
temp0075.html......Page 195
temp0076.html......Page 197
temp0077.html......Page 200
temp0078.html......Page 201
temp0079.html......Page 203
temp0080.html......Page 205
temp0081.html......Page 207
temp0082.html......Page 208
temp0083.html......Page 214
temp0084.html......Page 216
temp0085.html......Page 217
temp0086.html......Page 219
temp0087.html......Page 229
temp0088.html......Page 231
temp0089.html......Page 234
temp0090.html......Page 235
temp0091.html......Page 237
temp0092.html......Page 238
temp0093.html......Page 242
temp0094.html......Page 244
temp0096.html......Page 245
temp0097.html......Page 247
temp0098.html......Page 261
temp0099.html......Page 267
temp0100.html......Page 270
temp0101.html......Page 278
temp0104.html......Page 287
temp0105.html......Page 288
temp0106.html......Page 294
temp0107.html......Page 303
temp0108.html......Page 308
temp0109.html......Page 315
temp0110.html......Page 319