Oracle Pl/Sql Programming(1st Edition)

Book details

Book Price $0 : Oracle Is The Most Popular Database Management System In Use Today, And PL/SQL Plays A Pivotal Role In Current And Projected Oracle Products And Applications. PL/SQL Is A Relatively New Programming Language Providing Procedural Extensions To The SQL Relational Database Language And To An Ever-growing Number Of Oracle Development Tools, Including SQL*Plus, Oracle Forms, Oracle Graphics, Oracle Reports, And Oracle Developer 2000 (formerly The Cooperative Development Environment (CDE)). It Offers A Myriad Of Data Types, And Such Features As Cursors, Loops, Conditional And Sequential Control Statements, Exception Handlers, Records, Tables, And Constructs For Developing Modular Code (functions, Procedures, And Packages). Originally A Rather Limited Tool, PL/SQL Is Now A Mature And Effective Language For Developers.As More And More Oracle Customers Move From The Mainframe To Client- Server Configurations, PL/SQL Is Becoming Ever More Crucial. It Provides The Foundation For The Code Used To Distribute Processing And Transactions Across The Network.PL/SQL Allows The Developer To:Design Powerful And Easy-to-use GUI Interfaces In Products Like Oracle Forms And Oracle GraphicsBuild Complex Reports And Long-running Batch ProcessesImplement Critical Business Rules In Database Triggers And Stored ProceduresAlthough PL/SQL Is Very Important To Oracle Customers, It Has Not Received The Attention -- By Oracle Corporation And Outside Vendors And Authors -- That It Deserves. The Only Book Previously Available On PL/SQL Is The Overly Concise Oracle Reference Manual. Training Courses Tend To Focus On The Flashy Side Of The New GUI Tools And Ignore The More Complicated PL/SQL Programming That Is So Vital To Production Applications.Oracle PL/SQL Programming Fills A Huge Gap In The Oracle Market. The Book Provides Developers With A Single, Comprehensive Guide To Building Applications With PL/SQL -- And Building Them The Right Way. It's Packed With Strategies, Code Architectures, Tips, Techniques, And Fully Realized Code. The Book Comes With A Disk Containing Many Examples Of PL/SQL Programs That Readers Can Use Immediately Or As Starting Points For Further Development.Oracle PL/SQL Programming Is Divided Into Six Parts:Part I Introduces PL/SQL, Its Many Versions, The Environments In Which It Operates, PL/SQL Language Fundamentals, And Effective Coding Style. Part II Describes Basic PL/SQL Statements For Variables, Cursors, Conditional And Sequential Control, Loops, Exception Handling, Records, And Tables. Part III Describes All Of The Built-in (predefined) PL/SQL Functions And Procedures -- String, Date, Number, And Miscellaneous As Well As The Built-in Packages That Come With PL/SQL. Part IV Describes How To Modularize Your PL/SQL Programs Using Blocks, Procedures, Functions, And Packages.Part V Describes How To Debug PL/SQL Programs And Manage Code In The Database. It Also Contains A Summary Of Tips For Using PL/SQL Most Effectively.Part VI Contains Appendices Summarizing The Contents Of The Disk And The Calling Of Stored Procedures From Version 1.1. See more