Absolutely Australia's Lowest Prices

We won't be beaten by anyone. Guaranteed

Oracle (R) 11g
By

Rating
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 -- Oracle (R)11g. ORACLE (R) 11G: PL/SQL PROGRAMMING & ORACLE (R) CD, 2E, International Edition uses Oracle (R) 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 (R) 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 (R) CD make this book is an invaluable resource in preparing for the new Oracle (R) Certification exam or mastering the PL/SQL programming language with Oracle (R).
Product Details

Table of Contents

1. Introduction to PL/SQL. 2. Basic PL/SQL Block Structures. 3. Handling Data in PL/SQL Blocks. 4. Cursors and Exception Handling. 5. Procedures. 6. Functions. 7. PL/SQL Packages. 8. Dependencies, Privileges, and Compilation. 9. Database Triggers. 10. Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code. APPENDIXES. A. Tables for the Brewbean's Database. B. Oracle Installation and Using Oracle SQL Developer. ONLINE APPENDIXES. C. TOAD (Tool for Oracle Application Developers). D. Statement Tuning. E. SQL*Loader Utility. F. An Introduction to Object Technology.

About the Author

Joan E. Casteel combines more than 15 years of hands-on experience in application development in various business environments with strong teaching skills to clarify important application and software concepts for today's readers. An award-winning instructor, Ms. Casteel serves as associate professor of information technology and business at Tidewater Community College, where she has been an integral part of the Database Specialist curriculum. She has joined a newly formed team at the college in charge of building a campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. In addition the team is developing new Oracle APEX applications to improve college-wide financial services support. Ms. Casteel has been recognized by her colleagues for her professional accomplishments, including creating an Oracle virtual machine image for students and handling recruitment efforts for database specialist career studies. Ms. Casteel is the author of two successful books on Oracle from Course Technology, part of Cengage Learning, covering SQL and PL/SQL which serve as the introductory course sequence in the college's database career path.

Reviews

1. Introduction to PL/SQL. 2. Basic PL/SQL Block Structures. 3. Handling Data in PL/SQL Blocks. 4. Cursors and Exception Handling. 5. Procedures. 6. Functions. 7. PL/SQL Packages. 8. Dependencies, Privileges, and Compilation. 9. Database Triggers. 10. Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code. APPENDIXES. A. Tables for the Brewbean's Database. B. Oracle Installation and Using Oracle SQL Developer. ONLINE APPENDIXES. C. TOAD (Tool for Oracle Application Developers). D. Statement Tuning. E. SQL*Loader Utility. F. An Introduction to Object Technology.

Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Oracle (R) 11g: PL/SQL Programming, International Edition (with CD-ROM) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top