Oracle PL/SQL Programming 4Th Edition by Steven Feuerstein

By Steven Feuerstein

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Четвертое издание значительно обновлено и расширено, покрывая теперь описание самой последней версии Oracle Database 10g liberate 2. Она описывает такие новые возможности как PL/SQL optimizing compiler, conditional compilation, compile-time warnings, normal expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the power to backtrace an exception to a line quantity, numerous new integrated applications, and help for IEEE 754 compliant floating-point numbers.

(Извините, но дальше переводить анотацию не имеет смысла. Кто захочет прочитать книгу, тому и не столько придется читать на английском. Хотя можно и не читать конечно, а только примеры смотреть.)

Show description

Read or Download Oracle PL/SQL Programming 4Th Edition PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your allotted framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g info Replication explains the way to organize and administer a unified company information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes offers an example-based method of studying program convey - the ground-breaking, speedy program improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a very good instance or to kick begin their pondering and get pointed within the correct course.

Additional resources for Oracle PL/SQL Programming 4Th Edition

Example text

Top-down design) to limit the complexity of the requirements you must deal with at any given time If you use this approach, you will find that the executable sections of your modules are shorter and easier to understand, which makes your code easier to maintain and enhance over time. Local or nested modules play a key role in following this design principle. These are just a few of the important things to keep in mind before you start writing all that code. Just remember: in the world of software development, haste not only makes waste, it virtually guarantees a generous offering of bugs and lost weekends.

3 END; 4 / Hey look, Ma! PL/SQL procedure successfully completed. SQL> I generally put the SERVEROUTPUT command in my startup file (see the later section, "Loading your own custom environment automatically on startup"), causing it to be enabled until one of the following occurs: • You disconnect, log off, or otherwise end your session. • You explicitly set SERVEROUTPUT to OFF. • Oracle discards session state either at your request or because of a compilation error (see "Healing Invalids" in Chapter 20).

1. SQL*Plus The granddaddy of Oracle front ends, Oracle's SQL*Plus provides a command-line interpreter for both SQL and PL/SQL. That is, it accepts statements from the user, sends them off to the Oracle server, and displays the results. Often maligned for its primitive user interface, SQL*Plus is one of my favorite Oracle tools. I actually like the lack of fancy gizmos and complicated menus. Ironically, when I started using Oracle (circa 1986), this product's predecessor was boldly named UFIUser Friendly Interface.

Download PDF sample

Rated 4.19 of 5 – based on 45 votes