Oracle9i Database Search Results: 'DECLARE'
(Release 2 (9.2))

Your search for DECLARE matched 2587 topics across 64 books. In the list below, select a book title to see the matching topics in that book.

Featured Results (A-Z)

Administrator's Guide (11 matching topics)

Application Developer's Guide - Fundamentals (83 matching topics)

Concepts (25 matching topics)

Performance Tuning Guide and Reference (5 matching topics)

PL/SQL User's Guide and Reference (434 matching topics)

%ROWTYPE

%ROWTYPE - Cursors

%ROWTYPE - Constants and Variables

%ROWTYPE Attribute

%TYPE - Cursor Variables

%TYPE

%TYPE - Constants and Variables

%TYPE - Cursors

%TYPE Example - Declaring PL/SQL Collection Variables

Accessing Attributes

Actual Versus Formal Subprogram Parameters

Aggregate Assignment

Applying Methods to Collection Parameters

Assigning a SQL Query Result to a PL/SQL Variable

Assigning Boolean Values

Assigning Character Values

Assigning Null Values to Records

Assigning Records

Assigning Values to a Variable

Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT

Associative Arrays - Defining Collection Types

Attributes

Avoiding Collection Exceptions

Avoiding Errors with Cursor Variables

Avoiding Truncation Problems Using Date and Time Subtypes

Backward Compatibility of the USING Clause

Block Structure

Blocks

Branching to or from an Exception Handler

Calling Autonomous Functions from SQL

Calling Constructors

Calling External Subprograms

Calling Invoker-Rights Instance Methods

Calling Methods

Calling Subprograms and Methods

CASE Expressions

Case Sensitivity - PL/SQL Naming Conventions

CASE Statement

character_constant_name - Expressions

character_variable_name - Expressions

Collections

Collections

collection_declaration - Blocks

collection_declaration - Packages

collection_name - Constants and Variables

collection_name - Assignment Statement

collection_name - Expressions

collection_name - FETCH Statement

collection_name - SELECT INTO Statement

collection_name - %TYPE Attribute

collection_name - Collection Methods

Comparing Character Values

Components of an Object Type

Conditional Control

Constants and Variables

constant_declaration - Packages

constant_declaration - Blocks

Constructor Methods

Continuing after an Exception Is Raised

Counting Rows Affected by FORALL Iterations with the %BULK_ROWCOUNT Attribute

Cursor FOR Loops

Cursor Variable Example: Client-Side PL/SQL Block

Cursor Variable Example: Manipulating Host Variables in SQL*Plus

Cursor Variable Example: Pro*C Program

Cursor Variables

Cursor Variables

Cursor Variables As Parameters

Cursors

cursor_declaration - Blocks

cursor_for_loop_statement - LOOP Statements

cursor_name - Cursor Variables

cursor_name - Cursor Attributes

cursor_name - Constants and Variables

cursor_name - Cursors

cursor_name - CLOSE Statement

cursor_name - %ROWTYPE Attribute

cursor_name - OPEN Statement

cursor_name - LOOP Statements

cursor_name - FETCH Statement

cursor_name - Expressions

cursor_parameter_name - LOOP Statements

cursor_parameter_name - OPEN Statement

cursor_spec - Packages

cursor_variable_declaration - Blocks

cursor_variable_name - Cursor Attributes

cursor_variable_name - %TYPE Attribute

cursor_variable_name - CLOSE Statement

cursor_variable_name - FETCH Statement

cursor_variable_name - Expressions

cursor_variable_name - Constants and Variables

cursor_variable_name - Cursor Variables

cursor_variable_name - OPEN-FOR-USING Statement

cursor_variable_name - OPEN-FOR Statement

cursor_variable_name - Assignment Statement

cursor_variable_name - %ROWTYPE Attribute

Datetime Literals

date_constant_name - Expressions

date_variable_name - Expressions

Declarations

DECLARE - Blocks

Declaring a Cursor

Declaring and Initializing Objects

Declaring Constants

Declaring Cursor Variables

Declaring Objects

Declaring PL/SQL Collection Variables

Declaring PL/SQL Exceptions

Declaring PL/SQL Subprograms

Declaring Records

Declaring Variables

Decreasing the Size of a Collection (TRIM Method)

DEFAULT - RESTRICT_REFERENCES Pragma

Defining Aliases for Expression Values in a Cursor FOR Loop

Defining and Declaring Records

Defining Autonomous Transactions

Defining Collection Types

Defining Constructors

Defining REF CURSOR Types

Defining SQL Types Equivalent to PL/SQL Collection Types

Defining Subtypes

Defining Your Own Error Messages: Procedure RAISE_APPLICATION_ERROR

Defining Your Own PL/SQL Exceptions

Deleting Collection Elements (DELETE Method)

Doing Remote Operations

Error Handling

Example - SQLCODE Function

Example - variable_declaration

Example - := | DEFAULT

Example - error_number

Example - USING ...

Example - PRAGMA

Example - while_loop_statement

Example - sql_statement

Example - WHEN

Example of Multilevel Collections and Bulk SQL - Using Multilevel Collections

Example: Assigning a Null Value to a Nested Table - Assigning Collections

Example: Assigning the Result of a Table Function

Example: Checking if a Collection Is Null - Comparing Collections

Example: Combining Collection Declaration and Constructor - Initializing and Referencing Collections

Example: Comparing Two Collections - Comparing Collections

Example: Constructor for a Nested Table - Initializing and Referencing Collections

Example: Constructor for a Varray - Initializing and Referencing Collections

Example: Datatype Compatibility - Assigning Collections

Example: Declaring a Procedure Parameter as a Nested Table - Declaring PL/SQL Collection Variables

Example: Declaring Nested Tables, Varrays, and Associative Arrays - Declaring PL/SQL Collection Variables

Example: Empty Varray Constructor - Initializing and Referencing Collections

Example: Inserting into an Object Table with FORALL

Example: NOT NULL Constraint on Collection Elements - Declaring PL/SQL Collection Variables

Example: Passing a Nested Table Element as a Parameter - Initializing and Referencing Collections

Example: Performing a Bulk Bind with DELETE

Example: Performing a Bulk Bind with INSERT

Example: Performing INSERT, UPDATE, and DELETE Operations on PL/SQL Nested Tables - Using PL/SQL Collections with SQL Statements

Example: Possible Exceptions for Collection Assignments - Assigning Collections

Example: Referencing a Nested Table Element By Subscript - Initializing and Referencing Collections

Example: Retrieving a PL/SQL Nested Table from a Database Table - Using PL/SQL Collections with SQL Statements

Example: Retrieving a Single Element from a Nested Table with SQL - Using PL/SQL Collections with SQL Statements

Example: Retrieving Elements from a Varray with SQL - Using PL/SQL Collections with SQL Statements

Example: Specifying Collection Element Types with %TYPE and %ROWTYPE - Declaring PL/SQL Collection Variables

Example: Updating a Nested Table within a Database Table - Using PL/SQL Collections with SQL Statements

Example: Using FORALL with Part of a Collection

Example: VARRAY of Records - Declaring PL/SQL Collection Variables

Examples - type_name

Examples - PRAGMA

Examples - variable_name

Examples - label_name

Examples - USING ...

Examples - %ROWCOUNT Attribute

Examples - type_name

Examples - WHERE search_condition

Examples - CASE Statement

Examples - SQL

Examples - variable_name

Examples - table_name

Examples of Dynamic Bulk Binds

Examples of Dynamic SQL for Records, Objects, and Collections

Examples of PL/SQL Type Inheritance

exception_declaration - Blocks

exception_declaration - Packages

exception_name - EXCEPTION_INIT Pragma

exception_name - Exceptions

Fetching Across Commits - Overview of Transaction Processing in PL/SQL

Fetching Bulk Data with a Cursor

Fetching from a Cursor Variable

Fetching with a Cursor

Finding the Basis

function_declaration - Procedures

function_declaration - Blocks

function_spec - Packages

GOTO Statement

Guidelines

Handling Exceptions Raised in Declarations

Handling FORALL Exceptions with the %BULK_EXCEPTIONS Attribute

host_array_name - SELECT INTO Statement

host_array_name - FETCH Statement

host_cursor_variable_name - Assignment Statement

host_cursor_variable_name - CLOSE Statement

host_cursor_variable_name - Expressions

host_cursor_variable_name - FETCH Statement

host_cursor_variable_name - OPEN-FOR-USING Statement

host_cursor_variable_name - OPEN-FOR Statement

host_cursor_variable_name - Cursor Attributes

host_variable_name - Expressions

host_variable_name - Assignment Statement

How FORALL Affects Rollbacks

How Globalization Settings Affect VARCHAR2 Keys for Associative Arrays

How Overloading Works with Inheritance

How Package STANDARD Defines the PL/SQL Environment

How PL/SQL Exceptions Propagate

How PL/SQL Treats Uninitialized Objects

Implicit Conversion

Implicit Datatype Conversions - Reasons for PL/SQL Performance Problems

Improving PL/SQL Performance with Object Types and Collections

Inappropriate Declarations for Numeric Datatypes - Reasons for PL/SQL Performance Problems

Increasing the Size of a Collection (EXTEND Method)

index - Collection Methods

index_name - LOOP Statements

index_name - FORALL Statement

indicator_name - Expressions

indicator_name - Assignment Statement

Initializing Objects

Initializing Records

Inserting a PL/SQL Record Using %ROWTYPE: Example

Inserting Character Values

Inserting Objects

Inserting PL/SQL Records into the Database

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

Into a Collection of Records - Retrieving Query Results into Collections with the BULK COLLECT Clause

Into One or More Collections - Retrieving Query Results into Collections with the BULK COLLECT Clause

item_declaration - Functions

item_declaration - Procedures

Iteration Schemes

Iterative Control

label_name - GOTO Statement

label_name - Blocks

label_name - LOOP Statements

Limiting the Rows for a Bulk FETCH Operation with the LIMIT Clause

List of PL/SQL Reserved Words

Loop Labels

Managing Cursors

Manipulating Records

MEMBER | CONSTRUCTOR | STATIC - Object Types

Methods

Multilevel Associative Array Example - Using Multilevel Collections

Multilevel Nested Table Example - Using Multilevel Collections

Multilevel VARRAY Example - Using Multilevel Collections

Name Resolution - PL/SQL Naming Conventions

Name-Resolution Algorithm

Nested Table Example - Defining Collection Types

Nested Tables - Defining Collection Types

NUMBER

NUMBER Subtypes

Numeric Literals

numeric_constant_name - Expressions

numeric_variable_name - Expressions

Object Type Example: Stack

Object Type Example: Ticket_Booth

object_declaration - Blocks

object_declaration - Packages

object_name - %TYPE Attribute

object_name - Assignment Statement

object_name - Constants and Variables

Opening a Cursor

Opening a Cursor Variable

Opening the Cursor Variable

Optimizing Multiple Calls to Table Functions

Overloading Subprogram Names

Overview of Explicit Cursors

Overview of Implicit Cursors

Overview of PL/SQL Error Handling

Overview of PL/SQL Type Inheritance

Packages

PARALLEL_ENABLE - Functions

Parameter SELF - Components of an Object Type

parameter_name - Functions

parameter_name - Cursors

parameter_name - Procedures

Passing Cursor Parameters

Passing Data with Cursor Variables

Passing Large Data Structures with the NOCOPY Compiler Hint

Passing Nulls

Passing Parameters to a Cursor FOR Loop

Performing DML Operations Inside Table Functions

PL/SQL Block

PL/SQL Block

PL/SQL Block

PL/SQL Block

PL/SQL Block in a C Program

PL/SQL Collections and Records

Positional Versus Named Notation for Subprogram Parameters

Predefined Identifiers

Predefined PL/SQL Exceptions

Private Versus Public Items in Packages

procedure_declaration - Blocks

procedure_declaration - Functions

procedure_spec - Packages

Querying Data into Collections of Records

Raising Exceptions with the RAISE Statement

Records

record_declaration - Packages

record_declaration - Blocks

record_name - Constants and Variables

record_name - Cursor Variables

record_name - Cursors

record_name - Assignment Statement

record_name - %TYPE Attribute

record_name - LOOP Statements

record_name.field_name - %TYPE Attribute

record_name.field_name - Constants and Variables

Recursion Example: Traversing Tree-Structured Data

Redeclaring Predefined Exceptions

Reducing Loop Overhead for Collections with Bulk Binds

Referencing Collection Elements

Referencing Package Contents

Referencing Records

Release 9.0.1 - Oracle9i New Features in PL/SQL

Reraising a PL/SQL Exception

Reserved Words

Restrictions - sql_statement

Restrictions

Restrictions on BULK COLLECT

Restrictions on Cursor Variables

Restrictions on Declarations

Restrictions on NOCOPY

Restrictions on Overloading

Retrieving DML Results into a Collection with the RETURNING INTO Clause

Retrieving Query Results into Collections with the BULK COLLECT Clause

Retrieving the Error Code and Error Message: SQLCODE and SQLERRM

Retrying a Transaction

RETURN - Cursor Variables

RETURN - Cursors

ROWID - Overview of SQL Support in PL/SQL

ROWNUM - Overview of SQL Support in PL/SQL

Sample 3. Scoping

Sample 6. Calling a Stored Procedure

savepoint_name - ROLLBACK Statement

savepoint_name - SAVEPOINT Statement

Scope and Visibility of PL/SQL Identifiers

Scope Rules

Scope Rules for PL/SQL Exceptions

Scoping - PL/SQL Naming Conventions

Searched CASE Expression

Selecting Character Values

select_statement - LOOP Statements

select_statement - Cursors

Separating Cursor Specs and Bodies with Packages

Sequential Control

Setting Transaction Properties with SET TRANSACTION

Sharing Objects through the REF Modifier

Short-Circuit Evaluation - PL/SQL Expressions and Comparisons

Some Examples of Cursor Attributes

Some Examples of Dynamic SQL

Some Examples of Package Features

Some Varray Examples

Specifying Parameter Modes

Stored Procedure

Structure of an Object Type

subprogram_spec - Object Types

Synonyms - PL/SQL Naming Conventions

The Need for Template Objects in Invoker-Rights Subprograms

The Role of Abstraction

Tight Integration with SQL

TIMESTAMP

TIMESTAMP WITH LOCAL TIME ZONE

TIMESTAMP WITH TIME ZONE

Tuning PL/SQL Performance with Bulk Binds

Tuning PL/SQL Performance with Native Dynamic SQL

Tuning PL/SQL Performance with the NOCOPY Compiler Hint

Type Compatibility

Understanding Associative Arrays (Index-By Tables)

Understanding PL/SQL Functions

Understanding PL/SQL Procedures

Understanding Subprogram Parameter Aliasing

Understanding the Main Features of PL/SQL

Understanding The Package Body

Understanding The Package Spec

Undoing Changes with ROLLBACK

Undoing Partial Changes with SAVEPOINT

Updating a Row Using a Record Containing a Collection: Example

Updating a Row Using a Record Containing an Object: Example

Updating a Row Using a Record: Example

Usage Notes - variable_name

Usage Notes - type_name

Usage Notes - table_name

Usage Notes - WNPS

Usage Notes - := | DEFAULT

Usage Notes - variable_declaration

Usage Notes - select_statement

Usage Notes - cursor_parameter_name

Usage Notes - type_name

Usage Notes - variable_name

Usage Notes - variable_name

Usage Notes - WHEN

Usage Notes - %TYPE

Usage Notes - type_name

Usage Notes - variable_name

Using %ROWTYPE

Using %TYPE

Using a Cursor Variable as a Host Variable

Using Aliases

Using Autonomous Triggers

Using Cursor FOR Loops

Using Cursor Variables

Using Default Values for Subprogram Parameters

Using Duplicate Placeholders

Using FOR UPDATE - Overview of Transaction Processing in PL/SQL

Using Function DEREF

Using Function REF

Using Function VALUE

Using Host Arrays with Bulk Binds

Using Locator Variables to Identify Exception Locations

Using Mutual Recursion

Using Subqueries in Cursors

Using Subqueries Instead of Explicit Cursors

Using Subtypes

Using the OUT Mode

Using the RETURNING Clause with a Record: Example

VARCHAR2

Variable Assignment

Variables and Constants

variable_declaration - Packages

variable_declaration - Blocks

variable_name - FETCH Statement

variable_name - %TYPE Attribute

variable_name - Assignment Statement

variable_name - SELECT INTO Statement

Varrays - Defining Collection Types

What Is a PL/SQL Package?

What Is a Record?

What Is a Recursive Subprogram?

What Is Dynamic SQL?

What Is Name Resolution?

Why Use Cursor Variables?

Writing a Pipelined Table Function

Reference (4 matching topics)

SQL Reference (59 matching topics)

Other Results (A-Z)

Advanced Replication (4 matching topics)

Application Developer's Guide - Advanced Queuing (36 matching topics)

Application Developer's Guide - Large Objects (LOBs) (56 matching topics)

Application Developer's Guide - Object-Relational Features (61 matching topics)

Application Developer's Guide - Workspace Manager (2 matching topics)

Data Cartridge Developer's Guide (34 matching topics)

Data Guard Concepts and Administration (1 matching topics)

Data Warehousing Guide (25 matching topics)

Dynamic Services User's and Administrator's Guide (4 matching topics)

Error Messages (279 matching topics)

Getting Started for Windows (2 matching topics)

Globalization Support Guide (4 matching topics)

Heterogeneous Connectivity Administrator's Guide (8 matching topics)

interMedia User's Guide and Reference (133 matching topics)

Internet Directory Administrator's Guide (1 matching topics)

Internet Directory Application Developer's Guide (8 matching topics)

Java Developer's Guide (8 matching topics)

Java Stored Procedures Developer's Guide (20 matching topics)

JDBC Developer's Guide and Reference (17 matching topics)

JPublisher User's Guide (21 matching topics)

Label Security Administrator's Guide (3 matching topics)

Migration (2 matching topics)

Migration Workbench Frequently Asked Questions (FAQ) (3 matching topics)

Migration Workbench Reference Guide for IBM DB2/AS400 V4R5 Migrations (1 matching topics)

Migration Workbench Reference Guide for Informix Dynamic Server 7.3 Migrations (14 matching topics)

Migration Workbench Reference Guide for Microsoft Access 2.0, 95, 97, 2000 Migrations (3 matching topics)

Migration Workbench Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations (19 matching topics)

Migration Workbench Reference Guide for MySQL 3.22, 3.23 Migrations (2 matching topics)

OLAP Developer's Guide to the OLAP DML (16 matching topics)

OLAP User's Guide (1 matching topics)

Oracle C++ Call Interface Programmer's Guide (15 matching topics)

Oracle Call Interface Programmer's Guide (38 matching topics)

Oracle Objects for OLE (54 matching topics)

Performance Planning (1 matching topics)

Pro*C/C++ Precompiler Getting Started for Windows (2 matching topics)

Pro*C/C++ Precompiler Programmer's Guide (310 matching topics)

Pro*COBOL Precompiler Getting Started for Windows (1 matching topics)

Pro*COBOL Precompiler Programmer's Guide (267 matching topics)

Pro*PL/1 Supplement to the Oracle Precompilers Guide (57 matching topics)

Real Application Clusters Administration (1 matching topics)

Real Application Clusters Real Application Clusters Guard I - Concepts and Administration (1 matching topics)

Recovery Manager User's Guide (1 matching topics)

Replication Management API Reference (20 matching topics)

Sample Schemas (5 matching topics)

SNMP Support Reference Guide (1 matching topics)

SQL*Module for Ada Programmer's Guide (14 matching topics)

SQL*Plus User's Guide and Reference (10 matching topics)

SQLJ Developer's Guide and Reference (129 matching topics)

Streams (43 matching topics)

Supplied Java Packages Reference (23 matching topics)

Supplied PL/SQL Packages and Types Reference (70 matching topics)

Support for JavaServer Pages Reference (20 matching topics)

Text Application Developer's Guide (8 matching topics)

Text Reference (28 matching topics)

Utilities (14 matching topics)

XML API Reference - XDK and Oracle XML DB (24 matching topics)

XML Developer's Kits Guide - XDK (21 matching topics)

Copyright © 2013, Oracle. All rights reserved.