Oracle PL/SQL Programming
- ISBN-10
- 1565921429
- ISBN-13
- 9781565921429
- Series
- Oracle PL/SQL Programming
- Category
- Computers / General
- Pages
- 885
- Language
- English
- Published
- 1995
- Publisher
- O'Reilly & Associates
- Author
- Steven Feuerstein
Description
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 Graphics
- Build complex reports and long-running batch processes
- Implement critical business rules in database triggers and stored procedures
Although 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 Programmingfills 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 Programmingis 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.
Get the book
Other editions
-
- 2014-01-23
- 1392 pages
- Paperback
- "O'Reilly Media, Inc."
-
- 2009-09-17
- 1232 pages
- Paperback
- "O'Reilly Media, Inc."
Similar books
-
Information Communication Technologies: Concepts, Methodologies, Tools and Applications
By Craig Van SlykeCorrelation table between race and accessing the Internet townships yes 10 ACCESS sometimes 26 RACE the Internet urban yes 9 Pearson Correlation no -.143 1 3 .146 Sig . ( 2 - tailed ) sometimes 20 N 105 -105 rural area yes 6 no 1 ...
-
Tutorial, Software Design Strategies: Initially Presented at COMPSAC 81
By Glenn D. Bergland, Ronald D. Gordon... independent system to aid the development of structured programs Software P & E vol 6 pp 485-503 , ( 1976 ) . ... 016 PEARSON DJ , CADES - Computer - Aided Design and Evaluation System Computer Weekly ( July / Aug 1973 ) .
-
The Professional User's Guide to Acquiring Software
By Linda Shafer, John L. ConnellPrentice-Hall, Englewood Cliffs, N.J., 1980. Harris, Catherine L. "Information Power," Business Week, October 14, 1985, pp. 108-114. Heiser, Dick. Real Managers Use Personal Computers, Que Corporation, Indianapolis, 1983.
-
The Highest Stakes: The Economic Foundations of the Next Security System
By John Zysman, Steven Vogel, Wayne Sandholtz55. The following section draws from work that was originally presented in the journal International Security by Stephen Van Evera , Jack Snyder , Scott Sagan , and others . See Steven E. Miller , ed . , Military Strategy and ...
-
Algorithms and Systems for Optical Information Processing IV: 1-2 August, 2000, San Diego, [California] USA
By Society of Photo-optical Instrumentation EngineersAlgorithms and Systems for Optical Information Processing IV: 1-2 August, 2000, San Diego, [California] USA
-
Programming Perl
By Larry Wall, Randal L. SchwartzSoftware -- Operating Systems.
-
大学计算机基础实践教程（第2版）
By 孟雪梅, 王凤琴主编, 董大伟(4)设正 1 首, 2行,并 1 加,类型为,宽为1.5 ,不设右边。(5)设 3 开头的“应用:”体为体,加粗,纹为橙色。(6)使用找替换功正中有“牡丹”为“富贵”。(7)标题“洛阳牡丹”为艺术,艺术样式为五行三个,体36 ,艺术形状为“上”,环绕式为“周型”,居中对齐,当的调整艺术的。
-
大学计算机基础实践教程
By 张敏, 李莉, 姚琳主编[4]李,黄绍.Excel 2010应用大全.北:机械工业, 2010. [5]姚琳等.大学计算机基础实教程.北:人邮电, 2010. [6]科教工作.Office 2010综合应用( 2 ).北:清华大学,2011. [7]赵英,冯,舒宁.多媒体技术应用.北:清华大学.2011. [8]赵子江.多媒体技术应用教程( 6 ).
-
大学计算机基础与计算思维实验指导（第2版）
By 强振平, 鲁莹主编, 李俊萩[ 5 ]翟铭,排版技术[ M ] .北京:印刷工业出版社, 2006 . [ 6 ]庄庆德,科技论文撰写系列讲座(五) /图表的处理[ J ] .国外电子测量技术, 2008,27 ( 6 ) : 1-3 . [ 7 ]赵玲黄恺听编著,中文 PowerPoint 2003 应用实例教程[ M ] .北京:冶金工业出版社, 2006 .
-
大学计算机基础教程
By 刘光洁主编, 蔡学森, 姜艳副主编可见,在这式,在队列中相邻的同学舍也相邻。同上面的例子类,在计算机可用一片连续的存储域来存储线性,也是用一组地址连续的存储单元来次存储线性的各个元,这是线性的顺存储结构。线性(k 1, k 2, ..., ki , ... , kn )的顺存储结构如图6-5 示,这存储式的点 ...