Oracle built-in packages / Steven Feuerstein, Charles Dye, John Beresniewicz ; editor, Debby Russell.

Format:

Book

Author/Creator:

Feuerstein, Steven, author.

Dye, Charles, author.

Beresniewicz, John, author.

Contributor:

Russell, Debby, editor.

Language:

English

Subjects (All):

Oracle (Computer file).

PL/SQL (Computer program language).

Relational databases.

Physical Description:

1 online resource (2016 p.)

Edition:

1st edition

Place of Publication:

[Place of publication not identified] : O'Reilly, [2010]

Language Note:

English

System Details:

text file

Summary:

<div> 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 programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object

Contents:

Package-defined exceptionStandard system exception; Package-specific exception; Same exception, different causes; Encapsulating Access to the Built-in Packages; Examples of encapsulation packages; Calling Built-in Packaged Code from Oracle Developer/2000 Release 1; Referencing packaged constants and variables; Handling exceptions in Oracle Developer/2000 Release 1; Accessing Built-in Packaged Technology from Within SQL; Calling a packaged function in SQL; Using a packaged procedure from within SQL; Examining Built-in Package Source Code; The STANDARD Package; The DBMS_STANDARD Package

II. Application Development Packages2. Executing Dynamic SQL and PL/SQL; Examples of Dynamic SQL; Getting Started with DBMS_SQL; Creating the DBMS_SQL Package; Security and Privilege Issues; DBMS_SQL Programs; Types of Dynamic SQL; DBMS_SQL Exceptions; DBMS_SQL Nonprogram Elements; The DBMS_SQL Interface; Processing Flow of Dynamic SQL; Opening the Cursor; The DBMS_SQL. OPEN_CURSOR function; The DBMS_SQL.IS_OPEN function; Parsing the SQL Statement; The DBMS_SQL.PARSE procedure; Parsing very long SQL statements; Binding Values into Dynamic SQL; The DBMS_SQL.BIND_VARIABLE procedure; Examples

The DBMS_SQL. BIND_ARRAY procedureRules for array binding; Defining Cursor Columns; The DBMS_SQL.DEFINE_COLUMN procedure; The DBMS_SQL.DEFINE_ARRAY procedure; Executing the Cursor; The DBMS_SQL.EXECUTE function; Fetching Rows; The DBMS_SQL.FETCH_ROWS function; The DBMS_SQL.EXECUTE_AND_FETCH function; Retrieving Values; The DBMS_SQL.COLUMN_VALUE procedure; The DBMS_SQL.COLUMN_VALUE_LONG procedure; The DBMS_SQL.VARIABLE_VALUE procedure; Closing the Cursor; The DBMS_SQL. CLOSE_CURSOR procedure; Checking Cursor Status; The DBMS_SQL.LAST_ERROR_POSITION function

The DBMS_SQL.LAST_ROW_COUNT functionThe DBMS_SQL.LAST_ROW_ID function; The DBMS_SQL.LAST_SQL_FUNCTION_CODE function; Describing Cursor Columns; The DBMS_SQL. DESCRIBE_COLUMNS procedure; Tips on Using Dynamic SQL; Some Restrictions; Privileges and Execution Authority with DBMS_SQL; The tale of Jan; The tale of Scott; Combining Operations; Minimizing Memory for Cursors; Improving the Performance of Dynamic SQL; Problem-Solving Dynamic SQL Errors; Executing DDL in PL/SQL; Executing Dynamic PL/SQL; DBMS_SQL Examples; A Generic Drop_Object Procedure; A Generic Foreign Key Lookup Function

A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS

Notes:

Description based upon print version of record.

Description based on print version record.

ISBN:

9781449397722

1449397727

9780596152253

0596152256