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...
Saved in:
Main 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 |