Programming, Guide, Through, Animal, Release, Covers, Database, Oracle, PL/SQL, Versions

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)

• ISBN13: 9780596514464
• Condition: New
• Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

This indispensable reference for both novices and experienced Oracle programmers will help you:

• Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
• Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
• Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
• Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
• Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
• Build modular PL/SQL applications using procedures, functions, triggers, and packages

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.







Rating: (out of 94 reviews)







List Price: $ 69.99



Price: $ 39.99

Other posts like this, by keyword:

Programming:

Oracle PL/SQL Programming, Third Edition ...
Oracle Shell Scripting: Linux and UNIX Programming for Oracle (Oracle In-Focus series) ...
Palm Programming for the Absolute Beginner w/CD ...
What is something productive to do in programming? ...
Programming of Computer Numerically Controlled Machines ...
Drag `n’ Drop CGI: Enhance Your Web Site Without Programming ...
Programming Logic for Business ...
Principles of Object-Oriented Programming in Java 1.1 ...
Cocoa Programming for Mac OS X ...
Internet Programming With VB ...
Guide:

BBC Style Guide ...
A+ Certification Training Guide, Second Edition (OTHER NEW RIDERS) ...
Shooting & Selling Your Photos: The Complete Guide to Making Money with Your Photography ...
Naturally Curious: A Photographic Field Guide and Month-by-Month Journey Through the Fields, Woods, and Marshes of New England Reviews ...
Guide to Score Study for the Wind Band Conductor (Meredith Music Resource) ...
From Technical Professional to Entrepreneur: A Guide to Alternative Careers ...
Musclemag International’s Anabolic Primer: An Information Packed Reference Guide to Ergogenic Aids for Hardcore Bodybuilders ...
10 Insider Secrets Career Transition Workshop: Your Complete Guide to Discovering the Ideal Job ...
Guide Investing Mutual Funds (Money Smarts/David Logan Scott) ...
The Unofficial LEGO MINDSTORMS NXT 2.0 Inventor’s Guide ...
Through:

What is a good way to watch MLB baseball games live through the network in good quality ? ...
Naturally Curious: A Photographic Field Guide and Month-by-Month Journey Through the Fields, Woods, and Marshes of New England Reviews ...
Fitness is Much More Than Physical; Discover & Nourish Your Personal Truths Through Fitness of Body, Mind, & Spirit ...
ARROWS THROUGH TIME: A Time Travel Tale of Adventure, Courage, and Faith ...
Where Healing Waters Meet: Touching the Mind and Emotions Through the Body ...
NICK AT NITE’S CLASSIC TV COMPANION: The All Night, Every Night Guide to Better Living Through Television ...
Blue Jean Baby: One Girl’s Trip Through The 1960s L.A. Music Scene ...
How Occult Virtues Are Infused Into Things By Ideas Through The Help Of The Soul – Pamphlet ...
Cooking Light Cooking Through the Seasons: An Everyday Guide to Enjoying the Freshest Food ...
Women Composers of Classical Music: 369 Biographies Through the Mid-20th Century ...
Animal:

Small Animal Emergency and Critical Care Medicine (Colour Handbook) ...
The Octopus and the Orangutan: More True Tales of Animal Intrigue, Intelligence, and Ingenuity ...
Saunders Solutions in Veterinary Practice: Small Animal Dentistry ...
Animal Spaces, Beastly Places (Critical Geographies) ...
Readings in Animal Cognition (Bradford Books) ...
Buyout of Animal Health International Prompts Shareholder Claims Investigation by Goldfarb Branham Law Firm LLP ...
Ferrets (Animal Planet Pet Care Library) Reviews ...
The Careless Animal: Nine Ecological Detective Stories Reviews ...
Field Trips: Bug Hunting, Animal Tracking, Bird-watching, Shore Walking ...
The Chimpanzee Family Book (Animal Family Series) ...
Release:

Press release: County announces National Counties Month ...
Jackie Chan’s 100th movie ‘1911′ gets Sept. 26 release ...
ITIL V3 Release, Control and Validation (RCV) Full Certification Online Learning and Study Book Course – The ITIL V3 Intermediate RCV ...
Download Firefox 4.0 Final Now, Official Release Coming Tomorrow ...
UNIX(r) System V Release 4 User’s Reference Manual/System Administrator’s Reference Manual(Commands M-Z) For Intel Processors Re ...
Masterpieces of Modern Urdu Poetry Reviews ...
How do the water supply into water heater and the release valve work? ...
Beyond Catch & Release: Exploring the Future of Fly Fishing ...
Rapunzel’s Release (Erotic Enchantments) Reviews ...
Computer Accounting With Peachtree Complete 2010, Release 17.0 Reviews ...
Covers:

Ultimate Origins #2 / BOTH Covers: Regular and Variant / 2 COMICS! ...
Masterpieces of Modern Urdu Poetry Reviews ...
Quilt-making covers past and present ...
Database:

Beginning MySQL Database Design and Optimization: From Novice to Professional Reviews ...
Database Design and Development: A Visual Approach ...
Database Design Using Entity-Relationship Diagrams (Foundations of Database Design) ...
Visual Basic.NET Database Programming ...
Masterpieces of Modern Urdu Poetry Reviews ...
Oracle:

Oracle PL/SQL Programming, Third Edition ...
Oracle Shell Scripting: Linux and UNIX Programming for Oracle (Oracle In-Focus series) ...
Oracle Data Dictionary Pocket Reference ...
Modern Sports Law: A Textbook ...
Masterpieces of Modern Urdu Poetry Reviews ...
PL/SQL:

Oracle PL/SQL Programming, Third Edition ...
Masterpieces of Modern Urdu Poetry Reviews ...
Versions:

Masterpieces of Modern Urdu Poetry Reviews ...