Oracle PL/SQL Language Pocket Reference, Second Edition by Steven Feuerstein, Bill Pribyl, Chip Dawes

By Steven Feuerstein, Bill Pribyl, Chip Dawes

The 'Oracle PL/SQL Language Pocket Reference' is an effective pocket reference for Oracle 11g yet i believe that this subject material is difficult to condense in dimension. i believe that this is not a distinct segment booklet that actually accomplishes a lot. i will nonetheless supply it four stars simply because it really is convenient yet i believe you'd be extra apt to select up one of many larger Oracle PL/SQL books by way of O'Reilly instead.****

Show description

Read or Download Oracle PL/SQL Language Pocket Reference, Second Edition PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

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

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and knowledge sharing throughout your disbursed framework utilizing the specialist info during this Oracle Press consultant. Oracle Streams 11g info Replication explains tips on how to manage and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program exhibit four Recipes presents an example-based method of studying program convey - the ground-breaking, quick program improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes an outstanding instance or to kick begin their pondering and get pointed within the correct path.

Additional info for Oracle PL/SQL Language Pocket Reference, Second Edition

Example text

The initialization section is optional and appears at the end of the package body, beginning with a BEGIN statement and ending with the EXCEPTION section (if present) or the END of the package. The following package initialization section runs a query to transfer the user's minimum balance into a global package variable. 15 Calling PL/SQL Functions in SQL Stored functions can be called from SQL statements in a manner similar to built-in functions like DECODE, NVL, or RTRIM. This is a powerful technique for incorporating business rules into SQL in a simple and elegant way.

9 Cursors in PL/SQL Every SQL statement executed by the RDBMS has a private SQL area that contains information about the SQL statement and the set of data returned. In PL/SQL, a cursor is a name assigned to a specific private SQL area for a specific SQL statement. There can be either static cursors, whose SQL statement is determined at compile time, or dynamic cursors, whose SQL statement is determined at runtime. Static cursors are used only for DML statements (SELECT, INSERT, UPDATE, DELETE, MERGE, or SELECT FOR UPDATE).

2 Implicit Cursors Whenever a SQL statement is directly in the execution or exception section of a PL/SQL block, you are working with implicit cursors. SQL statements handled this way include INSERT, UPDATE, DELETE, MERGE, and SELECT INTO. Unlike explicit cursors, implicit cursors do not need to be declared, OPENed, FETCHed, or CLOSEd. SELECT statements handle the %FOUND and %NOTFOUND attributes differently from the way that explicit cursors do. When an implicit SELECT statement does not return any rows, PL/SQL immediately raises the NO_DATA_FOUND exception and control passes to the exception section.

Download PDF sample

Rated 4.94 of 5 – based on 46 votes