Oracle Pl/Sql Programming (A Nutshell handbook) Book + PRICE WATCH * Amazon pricing is not included in price watch

Oracle Pl/Sql Programming (A Nutshell handbook) Book

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.Read More

from£48.58 | RRP: £
* Excludes Voucher Code Discount Also available Used from £4.63
  • Product Description

    Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a relatively new programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools, including SQL*Plus, Oracle Forms, Oracle Graphics, Oracle Reports, and Oracle Developer 2000 (formerly the Cooperative Development Environment (CDE)). It offers a myriad of data types, and such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). Originally a rather limited tool, PL/SQL is now a mature and effective language for developers. Although PL/SQL is very important to Oracle customers, it has not received the attention -- by Oracle Corporation and outside vendors and authors -- that it deserves. Oracle PL/SQL Programming fills a huge gap in the Oracle market. It provides developers with a single, comprehensive guide to building applications with PL/SQL -- and building them the right way. It's packed with strategies, code architectures, tips, techniques, and fully realized code. The book comes with a disk containing many examples of PL/SQL programs that readers can use immediately or as starting points for further development.

  • 1565921429
  • 9781565921429
  • Steven Feuerstein
  • O'Reilly & Associates
  • Paperback (Book)
  • 916
  • 1
As an Amazon Associate we earn from qualifying purchases. If you click through any of the links below and make a purchase we may earn a small commission (at no extra cost to you). Click here to learn more.

Would you like your name to appear with the review?

We will post your book review within a day or so as long as it meets our guidelines and terms and conditions. All reviews submitted become the licensed property of www.find-book.co.uk as written in our terms and conditions. None of your personal details will be passed on to any other third party.

All form fields are required.