Contact Us Need Help? Call us 1800-987-323
Explore Departments
  Free shipping Australia wide

Oracle PL/SQL for Dummies

  • Paperback
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how to Write efficient, easy-to-maintain code Test and debug PL/SQL routines Integrate SQL and PL/SQL Apply PL/SQL best practices Use new features introduced in Oracle 9i and 10g
Oracle PL/SQL for Dummies
$37.79 + free shipping
Ships from United Kingdom
Expected delivery Oct 04 – Oct 10
Find tips for creating efficient PL/SQL code

If you know a bit about SQL, this book will make PL/SQL programming painless

The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

Discover how to Write efficient, easy-to-maintain code Test and debug PL/SQL routines Integrate SQL and PL/SQL Apply PL/SQL best practices Use new features introduced in Oracle 9i and 10g
Find tips for creating efficient PL/SQL code



If you know a bit about SQL, this book will make PL/SQL programming painless!


The Oracle has spoken — you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.


Discover how to



  • Write efficient, easy-to-maintain code

  • Test and debug PL/SQL routines

  • Integrate SQL and PL/SQL

  • Apply PL/SQL best practices

  • Use new features introduced in Oracle 9i and 10g

Michael Rosenblum is originally from Kremenchuk, Ukraine. In 2000, he moved to the United States, where he lives with his family in Edison, New Jersey. He works as a Development DBA at Dulcian, Inc. Michael is responsible for system tuning and application architecture. He also supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is a frequent presenter at various regional and national Oracle user group conferences. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics, Ukraine. Dr. Paul Dorsey is the founder and President of Dulcian, Inc. , an Oracle consulting firm that specializes in business rules-based Oracle Client-Server and Web custom application development. He is the chief architect of Dulcian's Business Rules Information Manager (BRIM(r)) tool. Paul is the co-author of seven Oracle Press books that have been translated into nine languages: Oracle JDeveloper 10g Handbook, Oracle9i JDeveloper Handbook, Oracle JDeveloper 3 Handbook, Oracle Designer Handbook (2 editions), Oracle Developer Forms and Reports: Advanced Techniques and Development Standards, Oracle8 Design Using UML Object Modeling. In 2003, he was honored by ODTUG as volunteer of the year, in 2001 by IOUG as volunteer of the year and by Oracle as one of the six initial honorary Oracle 9i Certified Masters. Paul is an Oracle Fusion Middleware Regional Director. He is the President of the New York Oracle Users' Group and a Contributing Editor of the International Oracle User Group's SELECT Journal. He is also the founder and chairperson of the ODTUG Business Rules Symposium (now called Best Practices Symposium), currently in its sixth year, and the J2EE SIG.
Introduction.

Part I: Basic PL/SQL Concepts.

Chapter 1: PL/SQL and Your Database.

Chapter 2: The PL/SQL Environment.

Part II: Getting Started with PL/SQL.

Chapter 3: Laying the Groundwork: PL/SQL Fundamentals.

Chapter 4: Controlling Program Flow.

Chapter 5: Handling Exceptions.

Chapter 6: PL/SQL and SQL Working Together.

Part III: Standards and Structures.

Chapter 7: Putting Your Code in the Right Place.

Chapter 8: Creating Naming Standards.

Chapter 9: Creating Coding Standards.

Part IV: PL/SQL Data Manipulations.

Chapter 10: Basic Datatypes.

Chapter 11: Advanced Datatypes.

Part V: Taking PL/SQL to the Next Level.

Chapter 12: Transaction Control.

Chapter 13: Dynamic SQL and PL/SQL.

Chapter 14: PL/SQL Best Practices.

Part VI: The Part of Tens.

Chapter 15: Ten PL/SQL Tips.

Chapter 16: Ten Common Mistakes to Avoid in PL/SQL.

Index.

  • PL/SQL is the procedural language extension of the industry-standard.
  • SQL that's embedded in Oracle databases, which own about 60 percent of the commercial database market worldwide.
  • Targeting programmers with no previous PL/SQL experience, this book walks readers through the fundamentals and provides best practices sidebars throughout as well as complete coverage of naming and coding standards.
  • Topics covered include the relationship of PL/SQL to SQL, program control, exception handling, Oracle constructs and code placement options, and how to manipulate strings, dates, and numbers.
  • All code in the book is available on the author's Web site.
Author
Michael Rosenblum, Paul Dorsey
Pages
414
Publisher
For Dummies
Language
English
ISBN-10
0764599577
ISBN-13
9780764599576
Media
Book
Format
Paperback
DEWEY
005.133
Illustrations
Yes
Year
2006
Publication Date
2006-05-31
Country of Publication
United States
Imprint
John Wiley & Sons Inc
Place of Publication
New York
Tag
2012dummiespromo
Residence
US
Audience
General/Trade
Short Title
ORACLE PL/SQL FOR DUMMIES
Series
For Dummies (Lifestyles Paperback)
Edition
1st
FREE DELIVERY

Delivery is free to any Australian address. No matter where your item is going.

SECURE PAYMENT

We use 100% PCI DSS compliant payment services. That means your payment information is always protected, and never gets seen by anyone.

30 DAY RETURN POLICY

Return any item within 30 days of delivery. It doesn’t matter why you want to return your item, you can free of charge!