Summer Reading Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lisa Howorth: IMG So Many Books, So Many Writers



I'm not a bookseller, but I'm married to one, and Square Books is a family. And we all know about families and how hard it is to disassociate... Continue »

spacer
Qualifying orders ship free.
$29.95
List price: $31.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
3 Remote Warehouse Software Engineering- General

More copies of this ISBN

Oracle PL/SQL for Dummies (For Dummies)

by

Oracle PL/SQL for Dummies (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

What the book covers: Oracle PL/SQL For Dummies shows novice Oracle programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book.  This book introduces PL/SQL and its relationship to SQL and includes coverage of the following: getting started with PL/SQL (e.g., language fundamentals, program control, exception handling, and packages); Oracle-specific programming topics (e.g., Oracle constructs of interest to PL/SQL developers and code-placement options); advanced PL/SQL (e.g., manipulating strings, manipulating dates, and manipulating numbers). The book also includes a database primer chapter, coverage of best practices (based on actual system-building experience) in sidebars throughout and in a full chapter, and coding and naming standards that can be adopted by organizations. All of the code in the book is provided on the author’ s company Web site (www.dulcian.com).         Series features: Oracle PL/SQL For Dummies is written in the friendly, humorous, and easy-to-understand style that is the hallmark of the For Dummies brand.

Synopsis:

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

Synopsis:

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

About the Author

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. (www.dulcian.com), 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®) 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.

Table of Contents

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.

Product Details

ISBN:
9780764599576
Author:
Rosenblum, Michael
Publisher:
For Dummies
Author:
Dorsey, Paul
Author:
Dorsey, Dr. Paul
Subject:
Programming - Software Development
Subject:
Relational databases
Subject:
Database Management - SQL Server
Subject:
Database Management - Oracle
Subject:
PL/SQL (Computer program language)
Subject:
Software Development & Engineering - General
Subject:
Software Engineering-General
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
For Dummies
Publication Date:
20110223
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
432
Dimensions:
9.22x7.74x.90 in. 1.45 lbs.

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » General
Computers and Internet » Software Engineering » Software Management

Oracle PL/SQL for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$29.95 In Stock
Product details 432 pages For Dummies - English 9780764599576 Reviews:
"Synopsis" by , 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

"Synopsis" by , 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

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.