Oracle built-in packages
<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-growin...
| Otros Autores: | , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
O'Reilly
[2010]
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626898206719 |
Tabla de Contenidos:
- 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
