menu 简单麦麦
account_circle

带有包的高级Oracle PL/SQL编程-Advanced Oracle PL/SQL Programming with Packages文件编号:1615

已经帮助了2567人找到了他们想要的文件
上传于 2020年2月27日 23:34
17次下载
1999次围观
评分:4.5/5 ★ ★ ★ ★ ★
标题(title):Advanced Oracle PL/SQL Programming with Packages
带有包的高级Oracle PL/SQL编程
作者(author):Steven Feuerstein
出版社(publisher):Oreily
大小(size):2 MB (2206172 bytes)
格式(extension):pdf
注意:如果文件下载完成后为无法打开的格式,请修改后缀名为格式对应后缀

Steven Feuerstein's first book, Oracle PL/SQL Programming , has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language. Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications.
Table of contents :
Table of Contents......Page 2
BookmarkTitle:......Page 18
A.1.1 Conditional Logic......Page 19
A.1.2 Loops......Page 20
A.1.3 Exception Handling......Page 23
A.1.4 Cursors......Page 25
A.1.5 Builtin Functions......Page 28
A.1.6 Builtin Packages......Page 29
A.1.7 Modules......Page 30
A.1.8 Module Evaluation: Foreign Key Lookup......Page 31
A.2.1 Conditional Logic......Page 34
A.2.2 Loops......Page 35
A.2.3 Exception Handling......Page 37
A.2.4 Cursors......Page 38
A.2.5 Builtin Functions......Page 40
A.2.6 Builtin Packages......Page 42
A.2.7 Modules......Page 43
A.2.8 Module Evaluation: Foreign Key Lookup......Page 45
1.2.1 The Iceberg Approach to Coding......Page 48
BookmarkTitle:......Page 49
1.1 What Is a PL/SQL Package?......Page 51
1.2 What Are the Types and Layers of Packages?......Page 52
1.3.4 Object Persistence......Page 54
1.3.6 Performance Improvement......Page 55
1.4.1 The Package Specification......Page 57
1.4.2 Referencing Package Elements......Page 58
1.4.3 The Memory-Resident Architecture of Packages......Page 59
1.4.4 Access to Package Elements......Page 62
1.5.1 Builtin Packages......Page 65
1.5.3 Build-Your-Own Packages......Page 67
1.6.1 When Should You Build a Package?......Page 68
1.6.2 The Package Body......Page 73
1.6.3 The Initialization Section......Page 74
1.6.4 Working with Large Packages......Page 77
1.6.5 Calling Packaged Functions in SQL......Page 79
2.2.1 Choosing the Order of Elements......Page 83
BookmarkTitle:......Page 84
2. Best Practices for Packages......Page 85
BookmarkTitle:......Page 87
2.2 Using Effective Coding Style for Packages......Page 89
2.3.1 Choosing Appropriate and Accurate Names......Page 91
2.3.2 Avoiding Redundancy......Page 92
2.3.3 Avoiding Superfluous Naming Elements......Page 93
2.4 Organizing Package Source Code......Page 95
2.4.1 Creating Codependent Packages......Page 96
2.5.2 Making Your Programs Case-Insensitive......Page 98
2.5.3 Avoiding Need for User to Know and Pass Literals......Page 99
2.6 Building Flexibility Into Your Packages......Page 102
2.6.1 Toggling Package Behavior......Page 103
2.6.2 Toggles for Code Generation......Page 104
2.6.3 Changing Package Behavior Without Changing the Application......Page 105
2.7 Building Windows Into Your Packages......Page 108
2.7.2 Designing the Window Interface......Page 109
2.7.3 Implementing the Window......Page 111
2.7.4 Summarizing the Window Technique......Page 112
2.8.1 When to Overload......Page 114
2.8.2 Developing an Appreciation of Overloading......Page 119
2.9.2 Lava Lamp Code Consolidation......Page 120
BookmarkTitle:......Page 121
2.9 Modularizing for Maintainable Packages......Page 124
2.10.1 Gaining Control of Your Data......Page 127
2.10.2 Tracing Variable Reads and Writes......Page 129
2.10.3 Simplifying Package Interfaces......Page 130
2.10.4 When to Make Data Public......Page 131
2.10.5 Anchoring to Public Variables......Page 132
3.8.1 When the num_in Argument Is 0......Page 134
3.8.2 When string_in Is NULL......Page 135
BookmarkTitle:......Page 136
3.1 The Basic Problem......Page 139
3.2 Adding Value......Page 141
3.3 Supplying Backward Compatibility......Page 143
3.4 Improving the User Interface......Page 145
3.5 Rough Waters Ahead......Page 147
3.6 Building a Structured Function......Page 149
3.7 Handling Program Assumptions......Page 152
3.8 Broadening the Scope......Page 154
3.9 Considering Implementation Options......Page 156
3.10 Choosing the Best Performer......Page 158
3.11 Don't Forget Backward Compatibility......Page 161
3.12 Obliterating the Literals......Page 162
3.13 Glancing Backward, Looking Upward......Page 165
BookmarkTitle:......Page 166
4.1.1 The Benefits of PL/Vision......Page 167
4.1.2 The Origins of PL/Vision......Page 168
4.2.1 Building Blocks......Page 170
4.2.2 Developer Utilities......Page 171
4.2.3 Plug-and-Play Components......Page 172
4.3.2 Storage Requirements......Page 173
4.3.3 Beginning the Installation......Page 174
4.3.4 Using the PL/Vision Lite Online Reference......Page 175
4.3.5 Creating the PL/Vision Packages......Page 176
4.3.6 Granting Access to PL/Vision......Page 177
4.4.1 Special Handling for PLVdyn......Page 179
4.4.3 Converting Scripts to PL/SQL Programs......Page 180
4.4.5 Uninstalling PL/Vision......Page 181
4.5.1 Zooming in on help text......Page 183
4.6.2 Contents of the test Subdirectory......Page 185
4.6.3 Contents of the use Subdirectory......Page 186
BookmarkTitle:......Page 189
5.1 Common Package Elements......Page 190
5.2.4 The overloadings of the l procedure......Page 192
5.3.4 Setting the NULL substitution value......Page 194
5.3.6 Miscellaneous programs......Page 195
5.4.2 Case-converting programs......Page 197
5.5.2 Identifying references in stored code......Page 199
5.6.2 Character type functions......Page 200
5.6.3 Other functions and procedures......Page 201
5.7.4 Managing the commit counter......Page 202
5.8.3 Dumping the DDL......Page 204
5.9.3 Bundled, low-level operations......Page 206
5.9.5 Data Manipulation Language operations......Page 207
5.9.7 Miscellaneous programs......Page 208
5.10.3 Logging exception-handling activity......Page 209
5.10.6 Exception handlers......Page 210
5.10.8 Managing the list of bailout errors......Page 211
5.11.3 Setting the operating system delimiter......Page 212
5.11.7 Opening a file......Page 213
5.11.9 Reading from a file......Page 214
5.11.12 Displaying the contents of a file......Page 215
5.11.13 Miscellaneous operations......Page 216
5.12.3 Looking up the name......Page 217
5.12.4 Looking up the ID......Page 218
5.13.2 Setting the indentation......Page 219
5.13.4 Toggles affecting generated code......Page 220
5.13.8 Generating functions......Page 221
5.13.10 Miscellaneous code generators......Page 222
5.14.4 Displaying online help......Page 224
5.15.2 Package records......Page 226
5.15.4 Managing the source repository......Page 227
5.15.5 Managing the source WHERE clause......Page 228
5.15.6 Managing the target repository......Page 229
5.15.8 Saving and restoring repository settings......Page 230
5.15.10 Tracing PLVio activity......Page 231
5.16.2 Scanning PL/SQL strings......Page 232
5.17.3 Selecting the log type......Page 234
5.17.5 Reading the log......Page 235
5.17.7 Rolling back in PLVlog......Page 236
5.18.3 Modifying list contents......Page 238
5.18.4 Analyzing list contents......Page 239
5.19.2 Managing and accessing message text......Page 240
5.20.3 Setting the current object......Page 242
5.20.6 Programmatic cursor FOR loop elements......Page 243
5.20.8 Miscellaneous PLVobj programs......Page 244
5.21.2 Wrapping long strings into paragraphs......Page 246
5.21.4 Parsing strings......Page 247
5.22.2 Specifying tokens of interest......Page 249
5.22.3 Parsing PL/SQL source code......Page 250
5.23.4 Managing savepoints......Page 251
5.24.4 Analyzing stack contents......Page 253
5.24.5 Tracing Stack Activity......Page 254
5.25.3 Toggle for showing header......Page 255
5.25.8 Displaying a PLVtab table......Page 256
5.26.3 Determining type of token......Page 258
5.26.4 Retrieving keyword information......Page 259
5.27.5 Retrieving and displaying elapsed time......Page 260
5.27.6 Calibration and timing scripts......Page 261
5.28.4 Displaying current module......Page 262
5.28.7 Displaying an activity trace......Page 263
5.28.8 Accessing the PLVtrc execution call stack (ECS)......Page 264
5.29.4 Displaying compile errors......Page 265
BookmarkTitle:......Page 267
6.1 Null Substitution Value......Page 268
6.2 Setting the PL/Vision Date Mask......Page 270
6.3.1 Using the assert Procedure......Page 272
6.3.2 Asserting NOT NULL......Page 273
6.3.3 Asserting "In Range"......Page 274
6.4.2 Obtaining the Error Message......Page 276
6.4.4 Pausing Your Program......Page 277
6.5 The Predefined Datatypes......Page 278
6.6 The Predefined Constants......Page 280
BookmarkTitle:......Page 282
7. p: A Powerful Substitute for DBMS_OUTPUT......Page 283
7.1 Using the l Procedure......Page 284
7.1.2 Displaying Dates......Page 285
7.2 The Line Separator......Page 287
7.3 The Output Prefix......Page 289
7.4 Controlling Output from p......Page 290
BookmarkTitle:......Page 292
8.1 Using PLVtab-Based PL/SQL Table Types......Page 293
8.2 Displaying PLVtab Tables......Page 295
8.2.2 Displaying Selected Companies......Page 296
8.3 Showing Header Toggle......Page 298
8.4 Showing Row Number Toggle......Page 299
8.5 Setting the Display Prefix......Page 300
8.6 Emptying Tables with PLVtab......Page 301
8.6.1 Improving the Delete Process......Page 302
8.7 Implementing PLVtab.display......Page 304
Bookma
想了解更多信息?可向上传者提问。点击提问
欢迎您上传文件!
费劲心机找到了自己想要的文件?
不如上传简单麦麦!
分享给别人!还能赚取收益
下载须知
1.如有解压密码 提取码都在下面 注意查看
2.如果有问题 可以通过卖家联系方式 联系卖家 如果没有或无法解决可以联系官方客服
3.本文件为公益分享,文件由网上采集而来,如有侵权等问题,请及时联系客服删除

常见问题及官方客服联系方式:点击前往 售后问题处理方式:点击前往
-到底部了哦-
expand_less