Domain Name Com's Oracle Pl/Sql Programming

Oracle Pl/Sql Programming

Domain Name Com's - : Oracle Pl/Sql Programming

by: Steven Feuerstein, Bill Pribyl, Debby Russell

See Larger Image

List Price: $49.95

Price: $46.09

You Save: $3.86 ( 8%)
Prices subject to change.

Used Price: $8.56
Third Party New Price: $46.09

Availability: Usually ships in 1-2 business days

Binding: Paperback
Format: Bargain Price
Number Of Items: 1
Number Of Pages: 987
Publication Date: January 15, 1997
Sales Rank: 568969

Related Items:

Editorial Review:

Product Description:
Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter--designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL.

The book contains information about the latest Oracle9i PL/SQL features, including:

Record-based DML: You can now use records in INSERT and DELETE statements.
Table functions: These are functions that return a result set (in the form of a PL/SQL collection). Such functions existed in Oracle8i but they are now much expanded.
New and improved datatypes: Oracle now offers dramatically improved support for timestamps, time zone management, and interval calculations. In addition, the XMLType datatype has now been implemented.
Inheritance for object types: You can now define a hierarchy of object types (which were first introduced in Oracle8).
Enhancements to PL/SQL collections. PL/SQL now supports multiple-level collections (nesting collections within collections), as well as associative arrays (previously called index-by tables), which allow you to index by PLS_INTEGER and VARCHAR2.
Native compilation of PL/SQL code: PL/SQL source code can now optionally be compiled into native object code that is linked into Oracle.

The book is divided into six parts:

Part I, Programming in PL/SQL
Part II, PL/SQL Program Structure
Part III, PL/SQL Program Data
Part IV, SQL in PL/SQL
Part V, PL/SQL Application Construction
Part VI, Advanced PL/SQL Topics

Even if you've been a PL/SQL developer for years, you'll find an enormous amount of new and revised information in this third edition and on its companion web site. If you're new to PL/SQL, you'll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.

Amazon.com Review:
If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.

Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall

Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

Customer Reviews

Average Rating: out of 5 stars

Rating:

- #1 PL/SQL Book For A Reason
This is The Ultimate PL/SQL reference. Although the book isn't written as a reference, it serves as a more useful reference than the Oracle documentation. This book will show you 99% of PL/SQL functionality, and 110% of what you need to know. Steven Feuerstein always manages to write at a level which is not dry like 99% of all tech books out there. What a refreshing perspective he has for PL/SQL.

This book can be used for learning or refreshing on certain PL/SQL topics, but it isn't ... Read More

Rating:

- Impossibly long yet incomplete
This book is so incredibly long and verbose that it is impossible to use to actually learn PL/SQL in a self-directed manner. Each of its numerous long chapters is so focused on a small, isolated sub-topic of PL/SQL that it spends over 500 pages just to cover the basics of PL/SQL. At that point, 500 pages into the book it says, "by now you have mastered the basics of PL/SQL" and begins a series of long chapters on small, isolated advanced sub-topics.

Incredibly, the book does not ... Read More

Rating:

- MASSIVELY informative... yet surprisingly easy to read for beginners & intermediates
I've worked with Oracle and PL/SQL on and off for ages. I never really took a dive into the details of anything until recently. I knew the basics of PL/SQL blocks, writing procedures/functions and some of the "advanced" column/data types and interactions with them(XML with XPath, for example).

Being a professional software engineer for some time now and working with Oracle regularly has lead me down a path of basic knowledge. This book took that knowledge and pushed the boundaries further ... Read More

Rating:

- The PL/SQL Standard
As with the three previous editions, all of which I own, this book sets the standard for PL/SQL texts. Crammed with information, it provides a thorough and insightful reference and always has a place on my desk.

Rating:

- If you program in PL/SQL, then you need this book.
It is clear, concise, and as far as I can tell, correct. The writing is friendly, and the examples useful. I learned far more about PL/SQL from this book than from the Oracle documentation. I recently heard the author speak at a conference, and his good personality is reflected in the book.

Browse for similar items by category:

Computers & Internet - Bargain Books - Custom Stores - Specialty Stores - Books - General
Computers & Internet - Bargain Books - Custom Stores - Specialty Stores - Books - Programming
Computers & Internet - Bargain Books - Custom Stores - Specialty Stores - Books - General AAS
Databases - Computers & Internet - Subjects - Books - Database Management Systems
Oracle - Databases - Computers & Internet - Subjects - Books - PL & SQL

Domain Name Registration


	Register Domain Name
	Private Domain Registration
	Domain Name Auction
	Bulk Register Domains
	Transfer Domain Name
	Bulk Transfer Domains
	Manage Domain Names
	Email Accounts

Website Creator


	Website Creator Build Your Own Website
	Website Templates
	Mobile Website Templates

Website Hosting Plans


	Hosting Plans
	Dedicated Server
	Virtual Dedicated Server
	My Server - Account Login

Secure Server Certificates


	Introduction
	Technical Documents
	Purchase Secure Server SSL Certificate

Software


	MS Office Student
	QuickBooksPro 2008
	Digital Photo Editing How To Create a Foto Album
	HTML WebPage Editors
	Top Firewalls
	Networking Software
	Internet Security
	Local Area Networks
	Security & Firewalls
	Software Downloads
	Internet Utilities
	Children's Software
	Programming

Electronics


	MP3 Players
	Camera & Photo
	Office Electronics
	Computers & Ad-On's
	Handhelds & PDA
	GPS & Navigation
	Home Automations & Security
	Compare Prices on Electronics
	Ink & Toner Finder
	Monitors & Projectors
	Internet Webcams
	Blu Ray Disc Drive

Contact Information


	Office Locations
	Customer Feedback

Domain Names Electronics Software
Manage \| Register \| Email Login

Home \| Domain Name Registration \| Software \| Electronics \| Web Certificates \| About Us \| Contact Us \| Help