Oracle PL/SQL Programming


Author: Steven Feuerstein,Bill Pribyl

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596553142

Category: Computers

Page: 1200

View: 5771

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Oracle PL/SQL Programming: A Developer's Workbook

Oracle Development Languages


Author: Steven Feuerstein,Andrew Odewahn

Publisher: "O'Reilly Media, Inc."

ISBN: 1449324088

Category: Computers

Page: 594

View: 6420

However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer's Workbook is a different kind of animal! It's designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you've learned about PL/SQL--and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you'll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.The Oracle PL/SQL Developer's Workbook is a companion to Steven Feuerstein's bestselling Oracle PL/SQL Programming and his other PL/SQL books from O'Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).You'll find chapters on: Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records. Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology. Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQL Program construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL. Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages. Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.

Oracle PL/SQL Programming


Author: N.A

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565923355

Category: Computers

Page: 987

View: 4129

The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language. Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery. NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk. Oracle PL/SQL Programming is divided into seven parts: Foreword Preface Part I: Programming in PL/SQL 1. Introduction to PL/SQL 2. PL/SQL Language Fundamentals 3. Effective Coding Style Part II: PL/SQL Language Elements 4. Variables and Program Data 5. Conditional and Sequential Control 6. Database Interaction and Cursors 7. Loops 8. Exception Handlers 9. Records in PL/SQL 10.PL/SQL Tables Part III: Built-in Functions and Packages 11. Character Functions 12. Date Functions 13. Numeric, LOB, and Miscellaneous Functions 14. Conversion Functions Part IV: Modular Code 15. Procedures and Functions 16. Packages 17. Calling Stored PL/SQL Functions from SQL Part V: PL/SQL Oracle8 Features 18. Object Types 19. Nested Tables and VARRAYs 20. Object Views 21. External Procedures Part VI: Making PL/SQL Programs Work 22. Code Design Tips 23. Managing Code in the Database 24. Debugging PL/SQL 25. Tracing PL/SQL 26. Tuning PL/SQL Part VII: Appendixes A. What's on the Companion Disk? B. Calling Stored Procedures from PL/SQL Version 1.1 C. Built-in Packages

Learning Oracle PL/SQL


Author: Bill Pribyl,Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 0596001800

Category: Computers

Page: 401

View: 6815

"Learning Oracle PL/SQL" introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters.

Oracle Pl/Sql Programming In Simple Steps


Author: Kogent Solutions Inc.

Publisher: Dreamtech Press

ISBN: 9788177228557


Page: 272

View: 5727

This book effectively explains the concept of PL/SQL programming. It gives short yet complete description of the PL/SQL programming concepts and explains them step by step. This book provides core information that every PL/SQL developer should know to write PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle exceptions. Loaded with lots of examples and illustrations to explain concepts, this book would help you learn PL/SQL programming with minimal effort.

Oracle PL/SQL Best Practices

Write the Best PL/SQL Code of Your Life


Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596551520

Category: Computers

Page: 294

View: 9127

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including: What is the best way to write the SQL logic in my application code? How should I write my packages so they can be leveraged by my entire team of developers? How can I make sure that all my team's programs handle and record errors consistently? Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications. "This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals." --Dwayne King, President, KRIDAN Consulting

Oracle 11g: PL/SQL Programming


Author: Joan Casteel

Publisher: Cengage Learning

ISBN: 1133947360

Category: Computers

Page: 528

View: 8917

Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle11g. ORACLE 11G: PL/SQL PROGRAMMING & ORACLE CD, 2E uses Oracle 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle CD make this book is an invaluable resource in preparing for the new Oracle Certification exam or mastering the PL/SQL programming language with Oracle. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Oracle PL/SQL for DBAs


Author: Arup Nanda,Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 0596005873

Category: Computers

Page: 429

View: 7686

Focused squarely on the language topics of special concern to DBAs, this text contains a quick tour of the PL/SQL language, extensive coverage of security topics, and methods for DBAs to improve query and database performance with cursors and table functions.

Exam Prep for: Oracle Pl/Sql Programming


Author: David Mason

Publisher: Rico Publications


Category: Education

Page: 800

View: 496

Computer science is the theory, experimentation, and engineering that form the basis for the design and use of computers. This book provides over 2,000 Exam Prep questions and answers to accompany the text Oracle Pl/Sql Programming Items include highly probable exam items: SIMM, DDR SDRAM, database, Coprocessor, Von Neumann architecture, Control register, Pentium III, Station, Itanium, definition, comparison, MAC address, concept, description, IBM, Point-to-point protocol, email, Direct memory access, and more.

Oracle PL/SQL Programming


Author: Scott Urman

Publisher: Oracle Press

ISBN: 9780078821769

Category: Computers

Page: 564

View: 5708

This authoritative and official guide provides everything programmers need to take full advantage of the Oracle7 server. Written by two Oracle insiders, the book will teach programmers how to develop, test, debug, and tune Oracle applications using such popular tools as Visual Basic, SQL, and Oracle Developer 2000.