Home

Help

Oracle Database Master Index: H
10g Release 2 (10.2)

Shortcuts to Letters

Symbols

Numerals

Index Entries

H.A.R.D.

HA event notification (Oracle Call Interface Programmer's Guide)

hacked operating systems or applications (Security Guide)

hackers (HTTP Server Administrator's Guide)

handle attributes (Oracle Call Interface Programmer's Guide)

reading (Oracle Call Interface Programmer's Guide)

setting (Oracle Call Interface Programmer's Guide)

handle functions (Oracle Call Interface Programmer's Guide)

handlers

exception in PL/SQL (PL/SQL User's Guide and Reference)

handles (Oracle Call Interface Programmer's Guide)

[entry #2] (Oracle Call Interface Programmer's Guide)

advantages of (Oracle Call Interface Programmer's Guide)

allocating (Oracle Call Interface Programmer's Guide)

[subentry #2] (Oracle Call Interface Programmer's Guide)

bind handle (Oracle Call Interface Programmer's Guide)

C datatypes (Oracle Call Interface Programmer's Guide)

child freed when parent freed (Oracle Call Interface Programmer's Guide)

define handle (Oracle Call Interface Programmer's Guide)

describe handle (Oracle Call Interface Programmer's Guide)

direct path (Oracle Call Interface Programmer's Guide)

environment handle (Oracle Call Interface Programmer's Guide)

error handle (Oracle Call Interface Programmer's Guide)

freeing (Oracle Call Interface Programmer's Guide)

process attributes (Oracle Call Interface Programmer's Guide)

server handle (Oracle Call Interface Programmer's Guide)

service context handle (Oracle Call Interface Programmer's Guide)

statement handle (Oracle Call Interface Programmer's Guide)

subscription (Oracle Call Interface Programmer's Guide)

[subentry #2] (Oracle Call Interface Programmer's Guide)

transaction handle (Oracle Call Interface Programmer's Guide)

types (Oracle Call Interface Programmer's Guide)

user session handle (Oracle Call Interface Programmer's Guide)

handles for SQL statements (Concepts)

definition (Concepts)

handles, handle mechanism for wrapping instance methods (JPublisher User's Guide)

handling errors

PL/SQL (PL/SQL User's Guide and Reference)

handling errors in programs (OLAP DML Reference)

handling exceptions

Java (interMedia User's Guide)

PL/SQL (PL/SQL User's Guide and Reference)

[subentry #2] (interMedia User's Guide)

raised in as PL/SQL declaration (PL/SQL User's Guide and Reference)

raised in handler (PL/SQL User's Guide and Reference)

using OTHERS handler (PL/SQL User's Guide and Reference)

handling of nulls (PL/SQL User's Guide and Reference)

handshake

SSL (Advanced Security Administrator's Guide)

hanja attribute (Text Reference)

HARD

disk storage for RMAN backups (New Features Guide)

HARD initiative (High Availability Overview)

hard links, rules with BFILEs (Application Developer's Guide - Large Objects)

hard parsing (Performance Tuning Guide)

harden

operating system (Security Guide)

hardware

components (Performance Tuning Guide)

limitations of components (Performance Tuning Guide)

requirements for Data Guard configurations (Data Guard Concepts and Administration)

sizing of components (Performance Tuning Guide)

Hardware Assisted Resilient Data

See HARD

Hardware Assisted Resilient Data (HARD) initiative (High Availability Overview)

hardware configuration

keeping records of (Backup and Recovery Basics)

hardware requirements

Windows database installation (Data Mining Administrator's Guide)

hardware requirements for applications using Spatial (Spatial User's Guide and Reference)

HASATTRIBUTE function (PL/SQL Packages and Types Reference)

hasAttribute() (XML C++ API Reference)

hasAttributeNS() (XML C++ API Reference)

hasAttributes() (XML C++ API Reference)

HASCHILDNODES function (PL/SQL Packages and Types Reference)

hasChildNodes() (XML C++ API Reference)

hasFault() (XML C++ API Reference)

HASFEATURE function (PL/SQL Packages and Types Reference)

hasFeature() (XML C++ API Reference)

hasGrayScale function (Spatial GeoRaster)

hash

distribution value (Performance Tuning Guide)

keyed (Security Guide)

hash algorithms (Security Guide)

hash clusters

[entry #2] (Concepts)

advantages and disadvantages (Administrator's Guide)

altering (Administrator's Guide)

choosing key (Administrator's Guide)

contrasted with index (Concepts)

contrasted with index clusters (Administrator's Guide)

controlling space use of (Administrator's Guide)

creating (Administrator's Guide)

[subentry #2] (SQL Reference)

dropping (Administrator's Guide)

estimating storage (Administrator's Guide)

examples (Administrator's Guide)

hash function (Administrator's Guide)

[subentry #2] (Administrator's Guide)

[subentry #3] (Administrator's Guide)

[subentry #4] (Administrator's Guide)

[subentry #5] (Administrator's Guide)

[subentry #6] (Administrator's Guide)

HASH IS clause (Administrator's Guide)

[subentry #2] (Administrator's Guide)

HASHKEYS clause (Administrator's Guide)

[subentry #2] (Administrator's Guide)

scans of (Performance Tuning Guide)

single-table (Administrator's Guide)

single-table, creating (SQL Reference)

SIZE clause (Administrator's Guide)

sorted (Administrator's Guide)

[subentry #2] (Performance Tuning Guide)

specifying hash function for (SQL Reference)

hash functions

for hash cluster (Administrator's Guide)

HASH hint (SQL Reference)

hash index (Data Cartridge Developer's Guide)

HASH IS clause

of CREATE CLUSTER (SQL Reference)

hash joins (Performance Tuning Guide)

cost-based optimization (Performance Tuning Guide)

index join (Performance Tuning Guide)

hash partitioning

[entry #2] (Data Warehousing Guide)

creating tables using (Administrator's Guide)

index-organized tables (Administrator's Guide)

[subentry #2] (Administrator's Guide)

multicolumn partitioning keys (Administrator's Guide)

hash partitioning clause

of CREATE TABLE (SQL Reference)

[subentry #2] (SQL Reference)

hash partitions (OLAP DML Reference)

[entry #2] (Performance Tuning Guide)

adding (SQL Reference)

coalescing (SQL Reference)

examples of (Performance Tuning Guide)

hash tables

simulating with associative arrays (PL/SQL User's Guide and Reference)

hashing (Performance Tuning Guide)

HASHKEYS clause

of CREATE CLUSTER (SQL Reference)

HASH_AREA_SIZE initialization parameter

[entry #2] (Reference)

and parallel execution (Data Warehousing Guide)

setting with ALTER SYSTEM (SQL Reference)

hash_partitioning (SQL Quick Reference)

hash_partitions_by_quantity (SQL Quick Reference)

HASPATH operator (Text Application Developer's Guide)

[entry #2] (Text Reference)

and special characters (Text Reference)

examples (Text Application Developer's Guide)

HASPATH, definition (XML Developer's Kit Programmer's Guide)

hasPseudoColor function (Spatial GeoRaster)

HAVING condition

of GROUP BY clause (SQL Reference)

HEAD clause, 3.5.1.5 (SQL*Plus User's Guide and Reference)

head method, 1.3 (HTTP Server mod_plsql User's Guide)

HEAD option, 3.5.1.5 (SQL*Plus User's Guide and Reference)

HEADCLOSE function

of HTF package (PL/SQL Packages and Types Reference)

HEADCLOSE procedure

of HTP package (PL/SQL Packages and Types Reference)

Header / Body / Footer Definitions attribute (HTML DB User's Guide)

header files

location of (Oracle Call Interface Programmer's Guide)

[subentry #2] (Oracle Call Interface Programmer's Guide)

[subentry #3] (Oracle Call Interface Programmer's Guide)

header files location (Oracle Call Interface Programmer's Guide)

HEADER function

of HTF package (PL/SQL Packages and Types Reference)

HEADER precompiler option, 10.5.23 (Pro*C/C++ Precompiler Programmer's Guide)

HEADER precompiler option, 5.5 (Pro*C/C++ Precompiler Programmer's Guide)

HEADER procedure

of HTP package (PL/SQL Packages and Types Reference)

headers

of data blocks (Concepts)

of row pieces (Concepts)

heading (OLAP DML Reference)

for a report (OLAP DML Reference)

for output pages (OLAP DML Reference)

including a page number (OLAP DML Reference)

producing standard report heading (OLAP DML Reference)

HEADING clause, 12 (SQL*Plus User's Guide and Reference)

HEADING clause, 6.1.1.2 (SQL*Plus User's Guide and Reference)

HEADING command (OLAP DML Reference)

HEADING variable, 12 (SQL*Plus User's Guide and Reference)

headings

HEADOPEN function

of HTF package (PL/SQL Packages and Types Reference)

HEADOPEN procedure

of HTP package (PL/SQL Packages and Types Reference)

HEADSEP variable, 12 (SQL*Plus User's Guide and Reference)

[entry #2] (SQL*Plus User's Guide and Reference)

health check (Data Guard Broker)

monitoring (Data Guard Broker)

[subentry #2] (Data Guard Broker)

on primary database (Data Guard Broker)

on standby database (Data Guard Broker)

revealed by configuration status (Data Guard Broker)

StatusReport property (Data Guard Broker)

heap

[entry #2] (Pro*COBOL Programmer's Guide)

[entry #3] (Programmer's Guide to the Oracle Precompilers)

heap memory

allocating cursor variables (Pro*COBOL Programmer's Guide)

heap size

Java (Spatial Topology and Network Data Models)

heap tables (Pro*COBOL Programmer's Guide)

heap-organized tables

creating (SQL Reference)

in logical standby databases (Data Guard Concepts and Administration)

HEIGHT, parameter for APPLET tag (JDBC Developer's Guide and Reference)

HELO function and procedure (PL/SQL Packages and Types Reference)

HELP

SQL*Plus command (SQL Quick Reference)

help

about (HTML DB User's Guide)

creating (HTML DB User's Guide)

creating navigation bar icon (HTML DB User's Guide)

defining text (HTML DB User's Guide)

HELP command (Data Guard Broker)

of Listener Control utility (Net Services Reference)

of Oracle Connection Manager Control utility (Net Services Reference)

help command (Java Developer's Guide)

HELP command, ? command, 12 (SQL*Plus User's Guide and Reference)

HELP function (PL/SQL Packages and Types Reference)

help option (customizer harness) (SQLJ Developer's Guide and Reference)

help options (sqlj -help-xxxx) (SQLJ Developer's Guide and Reference)

HELP parameter

Data Pump Export utility

command-line mode (Utilities)

interactive-command mode (Utilities)

Data Pump Import utility

command-line mode (Utilities)

interactive-command mode (Utilities)

Export utility (Utilities)

Import utility (Utilities)

help parameter

Database Character Set Scanner (Globalization Support Guide)

help text

defining (HTML DB User's Guide)

help, online (Managing Oracle Software Using Oracle Universal Installer and OPatch)

heterogeneous distributed systems

accessing (Heterogeneous Connectivity Administrator's Guide)

definition (Administrator's Guide)

heterogeneous information sharing (Streams Replication Administrator's Guide)

non-Oracle to non-Oracle (Streams Replication Administrator's Guide)

non-Oracle to Oracle (Streams Replication Administrator's Guide)

apply process (Streams Replication Administrator's Guide)

capturing changes (Streams Replication Administrator's Guide)

instantiation (Streams Replication Administrator's Guide)

user application (Streams Replication Administrator's Guide)

Oracle to non-Oracle (Streams Replication Administrator's Guide)

apply process (Streams Replication Administrator's Guide)

capture process (Streams Replication Administrator's Guide)

database links (Streams Replication Administrator's Guide)

datatypes applied (Streams Replication Administrator's Guide)

DML changes (Streams Replication Administrator's Guide)

DML handlers (Streams Replication Administrator's Guide)

error handlers (Streams Replication Administrator's Guide)

errors (Streams Replication Administrator's Guide)

instantiation (Streams Replication Administrator's Guide)

message handlers (Streams Replication Administrator's Guide)

staging (Streams Replication Administrator's Guide)

substitute key columns (Streams Replication Administrator's Guide)

transformations (Streams Replication Administrator's Guide)

Heterogeneous Services

agent control utility (agtctl) (Heterogeneous Connectivity Administrator's Guide)

agent registration (Heterogeneous Connectivity Administrator's Guide)

avoiding configuration mismatches (Heterogeneous Connectivity Administrator's Guide)

disabling (Heterogeneous Connectivity Administrator's Guide)

enabling (Heterogeneous Connectivity Administrator's Guide)

self-registration (Heterogeneous Connectivity Administrator's Guide)

agents (Reference)

application development

controlling array fetches between non-Oracle server and agent (Heterogeneous Connectivity Administrator's Guide)

controlling array fetches between Oracle server and agent (Heterogeneous Connectivity Administrator's Guide)

controlling reblocking of array fetches (Heterogeneous Connectivity Administrator's Guide)

DBMS_HS_PASSTHROUGH package (Heterogeneous Connectivity Administrator's Guide)

pass-through SQL (Heterogeneous Connectivity Administrator's Guide)

using bulk fetches (Heterogeneous Connectivity Administrator's Guide)

using OCI for bulk fetches (Heterogeneous Connectivity Administrator's Guide)

configuring connections to (Net Services Administrator's Guide)

creating database links (Heterogeneous Connectivity Administrator's Guide)

data dictionary views (Heterogeneous Connectivity Administrator's Guide)

[subentry #2] (Heterogeneous Connectivity Administrator's Guide)

types (Heterogeneous Connectivity Administrator's Guide)

understanding sources (Heterogeneous Connectivity Administrator's Guide)

using general views (Heterogeneous Connectivity Administrator's Guide)

using SQL service views (Heterogeneous Connectivity Administrator's Guide)

using transaction service views (Heterogeneous Connectivity Administrator's Guide)

defining maximum number of open cursors (Heterogeneous Connectivity Administrator's Guide)

described (Net Services Administrator's Guide)

dynamic performance views (Heterogeneous Connectivity Administrator's Guide)

V$HS_AGENT view (Heterogeneous Connectivity Administrator's Guide)

V$HS_SESSION view (Heterogeneous Connectivity Administrator's Guide)

Generic Connectivity

architecture (Heterogeneous Connectivity Administrator's Guide)

creating initialization file (Heterogeneous Connectivity Administrator's Guide)

definition (Heterogeneous Connectivity Administrator's Guide)

editing initialization file (Heterogeneous Connectivity Administrator's Guide)

non-Oracle data dictionary access (Heterogeneous Connectivity Administrator's Guide)

ODBC connectivity requirements (Heterogeneous Connectivity Administrator's Guide)

OLE DB (FS) connectivity requirements (Heterogeneous Connectivity Administrator's Guide)

OLE DB (SQL) connectivity requirements (Heterogeneous Connectivity Administrator's Guide)

restrictions (Heterogeneous Connectivity Administrator's Guide)

setting parameters for ODBC source (Heterogeneous Connectivity Administrator's Guide)

setting parameters for OLE DB source (Heterogeneous Connectivity Administrator's Guide)

SQL execution (Heterogeneous Connectivity Administrator's Guide)

supported functions (Heterogeneous Connectivity Administrator's Guide)

supported SQL syntax (Heterogeneous Connectivity Administrator's Guide)

supported tables (Heterogeneous Connectivity Administrator's Guide)

types of agents (Heterogeneous Connectivity Administrator's Guide)

initialization parameters (Heterogeneous Connectivity Administrator's Guide)

[subentry #2] (Heterogeneous Connectivity Administrator's Guide)

[subentry #3] (Heterogeneous Connectivity Administrator's Guide)

[subentry #4] (Heterogeneous Connectivity Administrator's Guide)

multithreaded agents (Heterogeneous Connectivity Administrator's Guide)

optimizing data transfer (Heterogeneous Connectivity Administrator's Guide)

overview (Administrator's Guide)

setting global name (Heterogeneous Connectivity Administrator's Guide)

setting up access using Transparent Gateway (Heterogeneous Connectivity Administrator's Guide)

setting up environment (Heterogeneous Connectivity Administrator's Guide)

specifying cache high water mark (Heterogeneous Connectivity Administrator's Guide)

specifying cache size (Heterogeneous Connectivity Administrator's Guide)

specifying commit point strength (Heterogeneous Connectivity Administrator's Guide)

SQL service (Heterogeneous Connectivity Administrator's Guide)

testing connections (Heterogeneous Connectivity Administrator's Guide)

transaction service (Heterogeneous Connectivity Administrator's Guide)

tuning internal data buffering (Heterogeneous Connectivity Administrator's Guide)

tuning LONG data transfer (Heterogeneous Connectivity Administrator's Guide)

hexadecimal string

passing to DBMS_LOB.WRITE() (Application Developer's Guide - Large Objects)

hexadecimal strings

SQL*Loader (Utilities)

hexadecimal value

returning (SQL Quick Reference)

[subentry #2] (SQL Reference)

HEXTORAW function (SQL Quick Reference)

[entry #2] (SQL Reference)

HFEEDBACK procedure (Text Application Developer's Guide)

[entry #2] (Text Reference)

example (Text Reference)

result table (Text Reference)

HFILE OTT parameter (Oracle C++ Call Interface Programmer's Guide)

[entry #2] (Oracle Call Interface Programmer's Guide)

HFILE OTT parameter, 19.5.2.7 (Pro*C/C++ Precompiler Programmer's Guide)

HH datetime format element (SQL Quick Reference)

HIDE (Label Security Administrator's Guide)

[entry #2] (Label Security Administrator's Guide)

[entry #3] (Label Security Administrator's Guide)

HIDE clause, 12 (SQL*Plus User's Guide and Reference)

HIDE command (OLAP DML Reference)

HIDE option

default (Label Security Administrator's Guide)

discussion of (Label Security Administrator's Guide)

example (Label Security Administrator's Guide)

importing hidden column (Label Security Administrator's Guide)

inserting data (Label Security Administrator's Guide)

not exported (Label Security Administrator's Guide)

per-table basis (Label Security Administrator's Guide)

PL/SQL restriction (Label Security Administrator's Guide)

schema level (Label Security Administrator's Guide)

hiding PL/SQL code (PL/SQL User's Guide and Reference)

hierarchical cubes (Data Warehousing Guide)

[entry #2] (Data Warehousing Guide)

in SQL (Data Warehousing Guide)

hierarchical function (SQL Reference)

hierarchical index (repository) (XML DB Developer's Guide)

hierarchical indexing, definition (XML Developer's Kit Programmer's Guide)

hierarchical queries (SQL Reference)

[entry #2] (SQL Reference)

[entry #3] (SQL Reference)

child rows (SQL Reference)

[subentry #2] (SQL Reference)

CONNECT_BY_ISCYCLE pseudocolumn (SQL Reference)

CONNECT_BY_ISLEAF pseudocolumn (SQL Reference)

CONNECT_BY_ROOT operator (SQL Reference)

illustrated (SQL Reference)

leaf rows (SQL Reference)

ordering (SQL Reference)

parent rows (SQL Reference)

[subentry #2] (SQL Reference)

PRIOR operator (SQL Reference)

pseudocolumns in (SQL Reference)

retrieving root and node values (SQL Reference)

hierarchical query clause

of SELECT and subqueries (SQL Reference)

hierarchical query feedback information

generating (Text Reference)

hierarchical relationships

in thesaurus import file (Text Reference)

hierarchical sorting, example of (OLAP Developer's Guide to the OLAP API)

hierarchical_query_clause (SQL Quick Reference)

hierarchies (Concepts)

[entry #2] (Data Warehousing Guide)

adding to a dimension (SQL Reference)

based on a database column (OLAP Developer's Guide to the OLAP API)

creating (OLAP Reference)

creating logical (OLAP Application Developer's Guide)

custom sorting (OLAP Reference)

[subentry #2] (OLAP Reference)

defined (OLAP Reference)

definition (OLAP Developer's Guide to the OLAP API)

dropping from a dimension (SQL Reference)

how used (Data Warehousing Guide)

in OLAP metadata (OLAP Developer's Guide to the OLAP API)

join key (Concepts)

level-based (OLAP Developer's Guide to the OLAP API)

levels (Concepts)

limit of levels in (OLAP Developer's Guide to the OLAP API)

[subentry #2] (OLAP Developer's Guide to the OLAP API)

logical (OLAP Application Developer's Guide)

multiple (Data Warehousing Guide)

of dimensions, defining (SQL Reference)

overview (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

rolling up and drilling down (Data Warehousing Guide)

solved (OLAP Developer's Guide to the OLAP API)

unsolved (OLAP Developer's Guide to the OLAP API)

value-based (OLAP Developer's Guide to the OLAP API)

viewing (OLAP Reference)

[subentry #2] (OLAP Reference)

[subentry #3] (OLAP Reference)

hierarchies of an MdmDimension

example of getting (OLAP Developer's Guide to the OLAP API)

hierarchy

network (Spatial Topology and Network Data Models)

removing (Application Developer's Guide - Workspace Manager)

topology geometry layer (Spatial Topology and Network Data Models)

workspaces (Application Developer's Guide - Workspace Manager)

HIERARCHY clause

of CREATE DIMENSION (SQL Reference)

[subentry #2] (SQL Reference)

hierarchy level

getting for a node (Spatial Topology and Network Data Models)

setting for a node (Spatial Topology and Network Data Models)

hierarchy_clause (SQL Quick Reference)

HIERCHECK program (OLAP DML Reference)

HIERCHK.LOOPFND variable (OLAP DML Reference)

HIERCHK.LOOPVALS variable (OLAP DML Reference)

HIERCHK.XTRADIMS variable (OLAP DML Reference)

HIERHEIGHT command (OLAP DML Reference)

HIERHEIGHT function (OLAP DML Reference)

HIERLIST dimension (OLAP Application Developer's Guide)

HIER_LEVELS valueset (OLAP Application Developer's Guide)

high availability

and fast-start failover (New Features Guide)

benefits (Data Guard Broker)

[subentry #2] (Data Guard Concepts and Administration)

business impact analysis (High Availability Overview)

importance (High Availability Overview)

levels of data protection (Data Guard Broker)

[subentry #2] (Data Guard Broker)

LogXptMode property (Data Guard Broker)

of cluster systems (New Features Guide)

provided by Data Guard (Data Guard Concepts and Administration)

provided by RAC and Data Guard (Data Guard Concepts and Administration)

restoring after fast-start failover (Data Guard Broker)

Streams (Streams Concepts and Administration)

advantages (Streams Concepts and Administration)

apply (Streams Concepts and Administration)

best practices (Streams Concepts and Administration)

capture (Streams Concepts and Administration)

database links (Streams Concepts and Administration)

propagation (Streams Concepts and Administration)

high availability architecture

characteristics (High Availability Overview)

High availability architectures

comparison (High Availability Overview)

high availability framework, 6.1 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

high availability solution

characteristics (High Availability Overview)

high boundary

defined (Data Warehousing Guide)

high water mark

[entry #2] (Performance Tuning Guide)

definition (Concepts)

of clusters (SQL Reference)

of indexes (SQL Reference)

of tables (SQL Reference)

[subentry #2] (SQL Reference)

high-watermark (Streams Replication Administrator's Guide)

HIGHLIGHT procedure (Text Reference)

example (Text Reference)

result table (Text Reference)

highlight table

example (Text Reference)

structure (Text Reference)

highlighting

about (Text Application Developer's Guide)

generating markup (Text Reference)

[subentry #2] (Text Reference)

generating offsets (Text Reference)

[subentry #2] (Text Reference)

overview (Text Application Developer's Guide)

with NEAR operator (Text Reference)

highlighting documents (Text Application Developer's Guide)

highlighting text (Text Application Developer's Guide)

highlighting themes (Text Application Developer's Guide)

hint, optimizer (Pro*COBOL Programmer's Guide)

[entry #2] (Programmer's Guide to the Oracle Precompilers)

hints (Administrator's Guide)

[entry #2] (SQL Reference)

access paths (Performance Tuning Guide)

[subentry #2] (Performance Tuning Guide)

[subentry #3] (Performance Tuning Guide)

ALL_ROWS (SQL Reference)

APPEND (Data Warehousing Guide)

[subentry #2] (SQL Reference)

as used in outlines (Performance Tuning Guide)

CACHE (SQL Reference)

cannot override sample access path (Performance Tuning Guide)

CLUSTER (SQL Reference)

CURSOR_SHARING_EXACT (SQL Reference)

degree of parallelism (Performance Tuning Guide)

DRIVING_SITE (Administrator's Guide)

[subentry #2] (SQL Reference)

DYNAMIC_SAMPLING (SQL Reference)

EXPAND_GSET_TO_UNION (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

FACT (SQL Reference)

FIRST_ROWS(n) (Data Warehousing Guide)

[subentry #2] (SQL Reference)

FULL (Performance Tuning Guide)

[subentry #2] (SQL Reference)

global (Performance Tuning Guide)

global compared to local (Performance Tuning Guide)

HASH (SQL Reference)

how to use (Performance Tuning Guide)

in DELETE statements (Pro*COBOL Programmer's Guide)

[subentry #2] (Programmer's Guide to the Oracle Precompilers)

in SELECT statements (Pro*COBOL Programmer's Guide)

in SELECTstatement (Programmer's Guide to the Oracle Precompilers)

in SQL statements (SQL Reference)

in UPDATE statements (Pro*COBOL Programmer's Guide)

in UPDATEstatement (Programmer's Guide to the Oracle Precompilers)

INDEX (SQL Reference)

indexspec syntax (Performance Tuning Guide)

INDEX_ASC (SQL Reference)

INDEX_COMBINE (SQL Reference)

INDEX_DESC (SQL Reference)

INDEX_FFS (Performance Tuning Guide)

[subentry #2] (SQL Reference)

INDEX_JOIN (Performance Tuning Guide)

[subentry #2] (SQL Reference)

INDEX_SS (SQL Reference)

INDEX_SS_ASC (SQL Reference)

INDEX_SS_DESC (SQL Reference)

join operations (Performance Tuning Guide)

LEADING (SQL Reference)

location syntax (Performance Tuning Guide)

[subentry #2] (SQL Reference)

MERGE (SQL Reference)

MODEL_MIN_ANALYSIS (SQL Reference)

NOAPPEND (Data Warehousing Guide)

[subentry #2] (SQL Reference)

NOCACHE (SQL Reference)

NOPARALLEL (SQL Reference)

NOPARALLEL_INDEX (SQL Reference)

NOREWRITE (SQL Reference)

NOWRITE (Data Warehousing Guide)

NO_EXPAND (SQL Reference)

NO_FACT (SQL Reference)

NO_INDEX (Performance Tuning Guide)

[subentry #2] (SQL Reference)

NO_INDEX_FFS (SQL Reference)

NO_INDEX_SS (SQL Reference)

NO_MERGE (Administrator's Guide)

[subentry #2] (SQL Reference)

NO_PARALLEL (SQL Reference)

NO_PARALLEL_INDEX (SQL Reference)

NO_PUSH_PRED (SQL Reference)

NO_PUSH_SUBQ (SQL Reference)

NO_PX_JOIN_FILTER (SQL Reference)

NO_QUERY_TRANSFORMATION (SQL Reference)

NO_REWRITE (SQL Reference)

NO_STAR_TRANSFORMATION (SQL Reference)

NO_UNNEST (SQL Reference)

NO_USE_HASH (SQL Reference)

NO_USE_MERGE (SQL Reference)

NO_USE_NL (SQL Reference)

NO_XML_QUERY_REWRITE (SQL Reference)

optimization approach and goal (Performance Tuning Guide)

optimizer (Performance Tuning Guide)

ORDERED (SQL Reference)

ORDERED hint (Performance Tuning Guide)

overriding optimizer choice (Performance Tuning Guide)

overriding OPTIMIZER_MODE (Performance Tuning Guide)

PARALLEL (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

[subentry #3] (Data Warehousing Guide)

[subentry #4] (SQL Reference)

parallel query option (Performance Tuning Guide)

PARALLEL_INDEX (Data Warehousing Guide)

[subentry #2] (SQL Reference)

passing to the optimizer (SQL Reference)

PQ_DISTRIBUTE (SQL Reference)

PUSH_PRED (SQL Reference)

PUSH_SUBQ (SQL Reference)

PX_JOIN_FILTER (SQL Reference)

QB_NAME (SQL Reference)

query rewrite (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

REWRITE (Data Warehousing Guide)

[subentry #2] (SQL Reference)

REWRITE_OR_ERROR (Data Warehousing Guide)

RULE (SQL Reference)

specifying a query block (Performance Tuning Guide)

[subentry #2] (SQL Reference)

specifying indexes (Performance Tuning Guide)

STAR_TRANSFORMATION (SQL Reference)

syntax (SQL Reference)

tablespec syntax (Performance Tuning Guide)

UNNEST (SQL Reference)

USE_CONCAT (SQL Reference)

USE_HASH (SQL Reference)

USE_MERGE (SQL Reference)

USE_NL (SQL Reference)

USE_NL_WITH_INDEX (SQL Reference)

using extended syntax (Performance Tuning Guide)

using to tune distributed queries (Administrator's Guide)

hints in code, parameter sizes (SQLJ Developer's Guide and Reference)

histogram table

getting (Spatial GeoRaster)

setting (Spatial GeoRaster)

histograms

creating equiwidth (SQL Reference)

creating with user-defined buckets (Data Warehousing Guide)

frequency (Performance Tuning Guide)

getting (Spatial GeoRaster)

height-balanced (Performance Tuning Guide)

SDO_GEOR_HISTOGRAM object type (Spatial GeoRaster)

viewing (Performance Tuning Guide)

historical tables

moving time window (Administrator's Guide)

History (HTML DB User's Guide)

history columns

upgrading (Application Developer's Guide - Workspace Manager)

history information table (Spatial Topology and Network Data Models)

history management changes for release 10.1 (Application Developer's Guide - Workspace Manager)

history option

EnableVersioning procedure (Application Developer's Guide - Workspace Manager)

History screen, 1.3.6 (SQL*Plus User's Guide and Reference)

history views (xxx_HIST) (Application Developer's Guide - Workspace Manager)

hit count (Text Application Developer's Guide)

hit counting (Text Reference)

HI_SHARED_MEMORY_ADDRESS initialization parameter (Reference)

setting with ALTER SYSTEM (SQL Reference)

HI_SHARED_MEMORY_ADDRESS parameter (Concepts)

HMP parameters, tuning, B.6.1 (Administrator's Reference for UNIX-Based Operating Systems)

hold cursor (Programmer's Guide to the Oracle Precompilers)

HOLD CURSOR option

of Oracle precompilers (Programmer's Guide to the Oracle Precompilers)

holdability (cursor states, WITH clause), unsupported (SQLJ Developer's Guide and Reference)

holders

-outarguments option for holder types (JPublisher User's Guide)

for passing output parameters (JPublisher User's Guide)

using JAX-RPC holders (JPublisher User's Guide)

HOLD_CURSOR

HOLD_CURSOR clause (Performance Tuning Guide)

HOLD_CURSOR option

of ORACLE Precompilers (Pro*COBOL Programmer's Guide)

using to improve performance (Pro*COBOL Programmer's Guide)

what it affects (Pro*COBOL Programmer's Guide)

HOLD_CURSOR precompiler option (Pro*COBOL Programmer's Guide)

HOLD_CURSOR precompiler option, 10.5.23 (Pro*C/C++ Precompiler Programmer's Guide)

Holt-Winters forecasting (OLAP DML Reference)

[entry #2] (OLAP DML Reference)

home air dirtier (Text Application Developer's Guide)

HOME environment variable, 1.2.2 (Administrator's Reference for UNIX-Based Operating Systems)

Home Selector (Managing Oracle Software Using Oracle Universal Installer and OPatch)

[entry #2] (Managing Oracle Software Using Oracle Universal Installer and OPatch)

overview (Managing Oracle Software Using Oracle Universal Installer and OPatch)

working (Managing Oracle Software Using Oracle Universal Installer and OPatch)

homographs

in broader term queries (Text Reference)

in queries (Text Reference)

in thesaurus import file (Text Reference)

horizontal partitioning. See row subsetting

horizontal tab (escape sequence) (OLAP DML Reference)

HOST

SQL*Plus command (SQL Quick Reference)

host array (Programmer's Guide to the Oracle Precompilers)

advantages (Programmer's Guide to the Oracle Precompilers)

declaring (Programmer's Guide to the Oracle Precompilers)

dimensions (Programmer's Guide to the Oracle Precompilers)

maximum size (Programmer's Guide to the Oracle Precompilers)

referencing (Programmer's Guide to the Oracle Precompilers)

restrictions (Programmer's Guide to the Oracle Precompilers)

[subentry #2] (Programmer's Guide to the Oracle Precompilers)

[subentry #3] (Programmer's Guide to the Oracle Precompilers)

using dynamic SQL statement (Programmer's Guide to the Oracle Precompilers)

using in the DELETE statement (Programmer's Guide to the Oracle Precompilers)

using in the FOR clause (Programmer's Guide to the Oracle Precompilers)

using in the INSERT statement (Programmer's Guide to the Oracle Precompilers)

using in the SELECTstatement (Programmer's Guide to the Oracle Precompilers)

using in the UPDATE statement (Programmer's Guide to the Oracle Precompilers)

using in the WHERE clause (Programmer's Guide to the Oracle Precompilers)

using to improve performance (Programmer's Guide to the Oracle Precompilers)

when not allowed (Programmer's Guide to the Oracle Precompilers)

host arrays

bulk binds (PL/SQL User's Guide and Reference)

declaring (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

multidimensional (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

restrictions on (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

[subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

HOST attribute (Security Guide)

host cluster targets

discovering and updating (New Features Guide)

HOST command (Recovery Manager Reference)

HOST command, 12 (SQL*Plus User's Guide and Reference)

HOST command, 4.9 (SQL*Plus User's Guide and Reference)

HOST command, 9.5.1 (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

[entry #2] (Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide)

host credentials (2 Day DBA)

host expressions

basic syntax (SQLJ Developer's Guide and Reference)

bind by identifier (SQLJ Developer's Guide and Reference)

evaluation at runtime (SQLJ Developer's Guide and Reference)

examples (SQLJ Developer's Guide and Reference)

examples of evaluation at runtime (SQLJ Developer's Guide and Reference)

iterators and result sets as host variables (SQLJ Developer's Guide and Reference)

overview (SQLJ Developer's Guide and Reference)

restrictions (SQLJ Developer's Guide and Reference)

selecting a nested table (SQLJ Developer's Guide and Reference)

supported types for JDBC 2.0 (SQLJ Developer's Guide and Reference)

type support for Oracle8i (SQLJ Developer's Guide and Reference)

type support summary (SQLJ Developer's Guide and Reference)

host language

[entry #2] (Pro*COBOL Programmer's Guide)

[entry #3] (Programmer's Guide to the Oracle Precompilers)

host naming

connecting with (Net Services Administrator's Guide)

establishing a connection with (Net Services Administrator's Guide)

listener configuration for (Net Services Administrator's Guide)

requirements (Net Services Administrator's Guide)

HOST networking parameter (Net Services Reference)

[entry #2] (Net Services Reference)

[entry #3] (Net Services Reference)

host option (Programmer's Guide to the Oracle Precompilers)

HOST precompiler option (Pro*COBOL Programmer's Guide)

host program

[entry #2] (Programmer's Guide to the Oracle Precompilers)

host programs (Pro*COBOL Programmer's Guide)

host string, 3.3.3.1 (SQL*Plus User's Guide and Reference)

host structures

host table elements

maximum (Pro*COBOL Programmer's Guide)

host table example (Pro*COBOL Programmer's Guide)

host tables (Pro*COBOL Programmer's Guide)

advantages (Pro*COBOL Programmer's Guide)

declaring (Pro*COBOL Programmer's Guide)

dimensioning (Pro*COBOL Programmer's Guide)

multi-dimensional (Pro*COBOL Programmer's Guide)

operations on (Pro*COBOL Programmer's Guide)

referencing (Pro*COBOL Programmer's Guide)

restrictions (Pro*COBOL Programmer's Guide)

[subentry #2] (Pro*COBOL Programmer's Guide)

[subentry #3] (Pro*COBOL Programmer's Guide)

[subentry #4] (Pro*COBOL Programmer's Guide)

[subentry #5] (Pro*COBOL Programmer's Guide)

restrictions on (Pro*COBOL Programmer's Guide)

support for (Pro*COBOL Programmer's Guide)

using in dynamic SQL statements (Pro*COBOL Programmer's Guide)

using in the DELETE statement (Pro*COBOL Programmer's Guide)

using in the INSERT statement (Pro*COBOL Programmer's Guide)

using in the SELECT statement (Pro*COBOL Programmer's Guide)

using in the UPDATE statement (Pro*COBOL Programmer's Guide)

using in the WHERE clause (Pro*COBOL Programmer's Guide)

using the FOR clause (Pro*COBOL Programmer's Guide)

using to improve performance (Pro*COBOL Programmer's Guide)

variable-length (Pro*COBOL Programmer's Guide)

host varaible

in OPEN command (Programmer's Guide to the Oracle Precompilers)

multi-byte charecter strings (Programmer's Guide to the Oracle Precompilers)

undeclare (Programmer's Guide to the Oracle Precompilers)

using in EXEC TOOLS statement (Programmer's Guide to the Oracle Precompilers)

using in PL/SQL (Programmer's Guide to the Oracle Precompilers)

host variable (Programmer's Guide to the Oracle Precompilers)

assigning a value (Programmer's Guide to the Oracle Precompilers)

declaring (Programmer's Guide to the Oracle Precompilers)

dummy (Programmer's Guide to the Oracle Precompilers)

host variable equivalencing (Programmer's Guide to the Oracle Precompilers)

in EXECUTE command (Programmer's Guide to the Oracle Precompilers)

in OPEN command (Programmer's Guide to the Oracle Precompilers)

output versus input (Programmer's Guide to the Oracle Precompilers)

overview (Programmer's Guide to the Oracle Precompilers)

host variables (Pro*COBOL Programmer's Guide)

[entry #2] (SQLJ Developer's Guide and Reference)

assigning a value (Pro*COBOL Programmer's Guide)

attribute factoring in declaration of (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

compatibility with database objects (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

declaring (Pro*COBOL Programmer's Guide)

[subentry #2] (Pro*COBOL Programmer's Guide)

[subentry #3] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

declaring and naming (Pro*COBOL Programmer's Guide)

definition (Pro*COBOL Programmer's Guide)

definition of (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

host variable equivalencing (Pro*COBOL Programmer's Guide)

in EXECUTE statement (Pro*COBOL Programmer's Guide)

in OPEN statement (Pro*COBOL Programmer's Guide)

initializing (Pro*COBOL Programmer's Guide)

length up to 30 characters (Pro*COBOL Programmer's Guide)

naming (Pro*COBOL Programmer's Guide)

[subentry #2] (Pro*COBOL Programmer's Guide)

[subentry #3] (Pro*COBOL Programmer's Guide)

[subentry #4] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

overview (Pro*COBOL Programmer's Guide)

passed to a subroutine (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

referencing (Pro*COBOL Programmer's Guide)

[subentry #2] (Pro*COBOL Programmer's Guide)

[subentry #3] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

requirements (Pro*COBOL Programmer's Guide)

restrictions (Pro*COBOL Programmer's Guide)

[subentry #2] (Pro*COBOL Programmer's Guide)

restrictions on (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

rules for naming (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

scope of (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

using in PL/SQL (Pro*COBOL Programmer's Guide)

using in user exit (Programmer's Guide to the Oracle Precompilers)

using with PL/SQL (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

where allowed (Pro*COBOL Programmer's Guide)

[subentry #2] (Programmer's Guide to the Oracle Precompilers)

where to declare (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

[subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

with PL/SQL (Pro*COBOL Programmer's Guide)

host variables, 6.1.1 (Pro*C/C++ Precompiler Programmer's Guide)

host-based access control (HTTP Server Administrator's Guide)

domain name (HTTP Server Administrator's Guide)

environment variables (HTTP Server Administrator's Guide)

IP address (HTTP Server Administrator's Guide)

mod_access (HTTP Server Administrator's Guide)

mod_setenvif (HTTP Server Administrator's Guide)

netmask (HTTP Server Administrator's Guide)

network (HTTP Server Administrator's Guide)

host-language datatype (Programmer's Guide to the Oracle Precompilers)

HostName property (Data Guard Broker)

hot backup mode

for online user-managed backups (Backup and Recovery Advanced User's Guide)

hot backups

failed (Backup and Recovery Advanced User's Guide)

ending with ALTER DATABASE END BACKUP (Backup and Recovery Advanced User's Guide)

inconsistent whole database backups (Concepts)

hot mining (New Features Guide)

HOTLOG_SOURCE change sources (Data Warehousing Guide)

HOUR

datatype field (PL/SQL User's Guide and Reference)

hours of service (Performance Tuning Guide)

HP OpenView (Administrator's Guide)

HP-UX dynamic processor reconfiguration, B.7 (Administrator's Reference for UNIX-Based Operating Systems)

[entry #2] (Administrator's Reference for UNIX-Based Operating Systems)

HP-UX tools, 8.2.6 (Administrator's Reference for UNIX-Based Operating Systems)

HR (Security Guide)

HR function

of HTF package (PL/SQL Packages and Types Reference)

HR procedure

of HTP package (PL/SQL Packages and Types Reference)

HR schema

general description (Sample Schemas)

[subentry #2] (Sample Schemas)

installing (Sample Schemas)

HS networking parameter (Net Services Administrator's Guide)

[entry #2] (Net Services Reference)

HS_ADMIN_ROLE role (SQL Reference)

[entry #2] (Security Guide)

HS_ALL_CAPS view (Reference)

HS_ALL_DD view (Reference)

HS_ALL_INITS view (Reference)

HS_AUTOREGISTER initialization parameter

[entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

using to enable agent self-registration (Heterogeneous Connectivity Administrator's Guide)

HS_BASE_CAPS view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_BASE_DD view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_CALL_NAME initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_CLASS_CAPS view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_CLASS_DD view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_CLASS_INIT view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_COMMIT_POINT_STRENGTH initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_DB_NAME initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_DESCRIBE_CACHE_HWM initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_EXTERNAL_OBJECTS view (Reference)

HS_EXTERNAL_OBJECT_PRIVILEGES view (Reference)

HS_EXTERNAL_USER_PRIVILEGES view (Reference)

HS_FDS_CLASS view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_FDS_CONNECT_INFO initialization parameter (Heterogeneous Connectivity Administrator's Guide)

specifying connection information (Heterogeneous Connectivity Administrator's Guide)

HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_FDS_FETCH_ROWS initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_FDS_INST view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_FDS_SHAREABLE_NAME initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_FDS_TRACE_LEVEL initialization parameter (Heterogeneous Connectivity Administrator's Guide)

enabling agent tracing (Heterogeneous Connectivity Administrator's Guide)

HS_INST_CAPS view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_INST_DD view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_INST_INIT view (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

HS_LANGUAGE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_DATE_FORMAT initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_DATE_LANGUAGE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_NCHAR initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_NUMERIC_CHARACTER initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_TIMESTAMP_FORMAT initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_OPEN_CURSORS initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_ROWID_CACHE_SIZE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HS_RPC_FETCH_REBLOCKING initialization parameter (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Heterogeneous Connectivity Administrator's Guide)

HS_RPC_FETCH_SIZE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Heterogeneous Connectivity Administrator's Guide)

[entry #3] (Heterogeneous Connectivity Administrator's Guide)

HS_TIME_ZONE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

HTF package (PL/SQL Packages and Types Reference)

[entry #2] (PL/SQL User's Guide and Reference)

HTML

bypassing filtering (Text Reference)

filtering to (Text Application Developer's Guide)

[subentry #2] (Text Reference)

generated using custom PL/SQL (HTML DB User's Guide)

generating (Text Reference)

generating highlight offsets for (Text Reference)

[subentry #2] (Text Reference)

highlight markup (Text Reference)

[subentry #2] (Text Reference)

highlighting example (Text Reference)

indexing (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

[subentry #3] (Text Reference)

[subentry #4] (Text Reference)

[subentry #5] (Text Reference)

[subentry #6] (Text Reference)

indexing example (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

not handled by Oracle HTML DB (HTML DB User's Guide)

retrieving from PL/SQL (Application Developer's Guide - Fundamentals)

searching META tags (Text Application Developer's Guide)

zone section example (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

[subentry #3] (Text Reference)

HTML DB Account Credentials (HTML DB User's Guide)

[entry #2] (HTML DB User's Guide)

HTML DB engine

determining schema for (HTML DB User's Guide)

HTML DB file repository

downloading files (HTML DB User's Guide)

obtaining primary key (HTML DB User's Guide)

HTML DB Mail Log

deleting entries (HTML DB User's Guide)

HTML DB SCHEMA OWNER substitution string (HTML DB User's Guide)

HTML Form Parameters (XML Developer's Kit Programmer's Guide)

HTML Header attribute (HTML DB User's Guide)

HTML output (interMedia User's Guide)

HTML tags

applet tags