Oracle PL/SQL programming

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-growin...

Full description

Saved in:
Bibliographic Details
Main Author: Feuerstein, Steven (Author)
Format: Book
Published: Sebastopol, CA O'Reilly & Associates 1995
©1995
Series:A nutshell handbook
Subjects:
Online Access:Click Here to View Status and Holdings.
Tags: Add Tag
No Tags, Be the first to tag this record!

MARC

LEADER 00000n a2200000 a 4501
001 wils-153487
005 20230311122
020 # # |a 1565921429  |q paperback 
040 # # |a UiTM  |b eng  |c UiTM  |e rda 
090 0 0 |a QA76.73.S67  |b F49 1995 
100 1 # |a Feuerstein, Steven  |e author 
245 1 1 |a Oracle PL/SQL  |b programming  |c Steven Feuerstein 
264 # 1 |a Sebastopol, CA  |b O'Reilly & Associates  |c 1995 
264 # 1 |c ©1995 
300 # # |a xxvii, 885 pages  |b illustrations  |c 24 cm.  |e 1 computer disk (3 1/2 in.) 
336 # # |a text  |2 rdacontent 
337 # # |a unmediated  |2 rdamedia 
338 # # |a volume  |2 rdacarrier 
490 1 # |a A nutshell handbook 
500 # # |a "Database management systems" -- Cover#  |a Includes index 
504 # # |a Includes bibliographical references and index 
520 # # |a 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 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. 
640 # # |a Oracle (Computer file) 
650 # 0 |a Relational databases 
650 # 0 |a SQL (Computer program language) 
856 4 0 |z Click Here to View Status and Holdings.  |u https://opac.uitm.edu.my/opac/detailsPage/detailsHome.jsp?tid=153487 
964 # # |c BOK  |d 01