β Scribed by Bulusu Lakshman (auth.)
No coin nor oath required. For personal study only.
Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy.
Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.
Front Matter....Pages i-xxiii
Front Matter....Pages 1-1
Introduction to PL/SQL....Pages 3-30
Front Matter....Pages 31-31
Cursors....Pages 33-94
PL/SQL Records and Index-by Tables....Pages 95-135
Error Message Handling....Pages 137-173
Stored Subprograms (Procedures, Functions, and Packages)....Pages 175-253
Database Triggers....Pages 255-290
Native Dynamic SQL and Dynamic PL/SQL....Pages 291-313
Autonomous Transactions....Pages 315-331
Native Bulk Binds....Pages 333-357
Front Matter....Pages 359-359
The World of Objects....Pages 361-431
Collections (VARRAYS and Nested Tables)....Pages 433-478
Large Objects....Pages 479-505
Front Matter....Pages 507-507
Floating in Java....Pages 509-554
PL/SQL and the Web....Pages 555-593
Front Matter....Pages 595-595
Performance Considerations....Pages 597-609
PL/SQL Coding Standards....Pages 611-627
Back Matter....Pages 629-665
Software Engineering/Programming and Operating Systems
π SIMILAR VOLUMES
In addition to providing developers with detailed coverage of the PL/SQL 9i language, the author of this text covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications.
Oraclc9i Application Developer's Guide-Large Objects (LOBs) contains information that describes the features and fimctionality of Oracle9i and Oracle9i Enterprise Edition products. Oracle9i and Oracle9i Enterprise Edition have the same basic features. However, several advanced features are available
<p><b>Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c</b></p><h2>About This Book</h2><ul><li>Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination</li><li>Build
The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advan
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12<i>c</i>.<br /><br />Whether you're a developer or database administrato