Oracle9i Database Master Index: Q
(includes Windows entries)

Shortcuts to Letters

Symbols

Numerals

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

Index Entries

Q datetime format element (SQL Reference)

QMARK (Supplied Java Packages Reference)

     [entry #2] (XML Reference)

QMN. See queue monitor (QMN), 1-24 (AppDev - Advanced Queuing (AQ))

QMN0 process (Data Guard Concepts and Administration)

QMNn background process (Concepts)

QSM (Error Messages)

quadtree indexes (Spatial Guide)

QUAL function (OLAP DML Guide)

qualified data references

ampersand substitution (OLAP DML Guide)

creating (OLAP DML Guide)

defined (OLAP DML Guide)

in programs (OLAP DML Guide)

qualifying a relation (OLAP DML Guide)

replacing dimension of variable (OLAP DML Guide)

replacing dimension of variable, 4-17 (OLAP DML Guide)

using with = command (OLAP DML Guide)

using with = command, 4-20 (OLAP DML Guide)

using with relation (OLAP DML Guide)

with dimensions (OLAP DML Guide)

with relations (OLAP DML Guide)

with variables (OLAP DML Guide)

with variables, 4-17 (OLAP DML Guide)

qualifiers

using subprogram names as (PL/SQL Guide)

when needed (PL/SQL Guide)

     [subentry #2] (PL/SQL Guide)

quality

degradation of R-tree index (Spatial Guide)

R-tree (Spatial Guide)

QUALITY_DEGRADATION function (Spatial Guide)

QUARTER data type (OLAP DML Guide)

queries

     [entry #2] (SQL Reference)

     [entry #3] (SQL Reference)

     [entry #4] (C++ Call Interface Programmer's Guide)

     [entry #5] (SQL*Plus Guide)

ad hoc (Data Warehousing Guide)

association with cursor (Pro*COBOL Guide)

association with cursors (Pro*C/C++ Guide)

avoiding the use of indexes (Performance Guide)

capturing as views (AppDev - Fundamentals)

comments in (SQL Reference)

composite indexes (Concepts)

compound

     [subentry #2] (SQL Reference)

optimization of (Performance Guide)

ORs converted to (Performance Guide)

ORs converted to (Performance Guide)

correlated

left correlation (SQL Reference)

data (Performance Methods)

default locking of (Concepts)

define phase (Concepts)

defined (SQL Reference)

describe phase (Concepts)

dictionary views (Reference)

distributed (Admin Guide)

     [subentry #2] (SQL Reference)

application development issues (Admin Guide)

distributed or remote (Admin Guide)

dynamic (AppDev - Fundamentals)

     [subentry #2] (OLAP API Guide)

enabling parallelism for (Data Warehousing Guide)

ensuring the use of indexes (Performance Guide)

errors in distributed queries (AppDev - Fundamentals)

fetching rows (Concepts)

forwarding (Pro*C/C++ Guide)

grouping returned rows on a value (SQL Reference)

hierarchical, ordering (SQL Reference)

hierarchical. (SQL Reference)

hints (Reference)

hints in (SQL Reference)

how to specify (C++ Call Interface Programmer's Guide)

in COPY command (SQL*Plus Guide)

     [subentry #2] (SQL*Plus Guide)

in COPY command, 1 (iSQL*Plus User’s Guide)

in DML (Concepts)

incorrectly coded (Pro*C/C++ Guide)

inline views (Concepts)

join (SQL Reference)

     [subentry #2] (SQL Reference)

kinds of (Pro*C/C++ Guide)

location transparency and (Admin Guide)

locking rows during (SQL Reference)

merged with view queries (Concepts)

multirow (Pro*COBOL Guide)

optimizing IN subquery (Performance Guide)

ordering returned rows (SQL Reference)

outer joins in (SQL Reference)

parallel processing (Concepts)

pass-through SQL (Heterogeneous Connectivity Admin Guide)

phases of (Concepts)

post-processing (Admin Guide)

processing (Concepts)

read consistency of (Concepts)

reconstructing data at a point in time (AppDev - Fundamentals)

referencing multiple tables (SQL Reference)

remote (Admin Guide)

requirements for (Pro*C/C++ Guide)

returning more than one row (Pro*C/C++ Guide)

SAMPLE clause

cost-based optimization (Performance Guide)

select lists of (SQL Reference)

selecting from a random sample of rows (SQL Reference)

set membership (AppDev - Object-Relational Features)

show number of records retrieved (SQL*Plus Guide)

     [subentry #2] (SQL*Plus Guide)

show number of records retrieved, 1 (iSQL*Plus User’s Guide)

single-row versus multirow (Pro*C/C++ Guide)

     [subentry #2] (Pro*COBOL Guide)

sorting results (SQL Reference)

Source objects that are not (OLAP API Guide)

specifications for (OLAP API Guide)

speeding up with temporary tables (AppDev - Fundamentals)

star queries (Performance Guide)

     [subentry #2] (Data Warehousing Guide)

steps in retrieving results of (OLAP API Guide)

stored as views (Concepts)

syntax (SQL Reference)

temporary segments and (Concepts)

     [subentry #2] (Concepts)

top-level (SQL Reference)

top-N (SQL Reference)

transparency (Admin Guide)

triggers use of (Concepts)

unnesting (AppDev - Object-Relational Features)

varrays (AppDev - Object-Relational Features)

query

     [entry #2] (Pro*COBOL Guide)

     [entry #3] (Spatial Guide)

ABOUT (Text Developer's Guide)

about (Text Developer's Guide)

accumulate (Text Reference)

AND (Text Reference)

blocking operations (Text Developer's Guide)

broader term (Text Reference)

case-sensitive (Text Developer's Guide)

CATSEARCH (Text Developer's Guide)

CONTAINS (Text Developer's Guide)

counting hits (Text Developer's Guide)

equivalence (Text Reference)

example (Text Reference)

explicit describe (OCI Programmer's Guide)

hierarchical feedback (Text Reference)

MATCHES (Text Developer's Guide)

MINUS (Text Reference)

narrower term (Text Reference)

NOT (Text Reference)

optimizing for throughput (Text Developer's Guide)

OR (Text Reference)

overview (Text Developer's Guide)

preferred term (Text Reference)

related term (Text Reference)

results (AppDev - XML)

stored (Text Reference)

synonym (Text Reference)

threshold (Text Reference)

top term (Text Reference)

translation term (Text Reference)

translation term synonym (Text Reference)

weighted (Text Reference)

query

defined (SQL*Plus Getting Started for Windows)

results defined (SQL*Plus Getting Started for Windows)

query application (AppDev - XML)

prerequisites (Text Developer's Guide)

sample (Text Developer's Guide)

query builder (OLAP Services Concepts and Administration Guide)

     [entry #2] (OLAP Services Concepts and Administration Guide for Windows)

QUERY command (Net Services Admin Guide)

     [entry #2] (Net Services Admin Guide)

A.SMD Oracle Names record (Net Services Admin Guide)

     [subentry #2] (Net Services Reference)

     [subentry #3] (Net Services Reference)

CNAME.SMD Oracle Names record (Net Services Reference)

     [subentry #2] (Net Services Reference)

DL.RDBMS.OMD Oracle Names record (Net Services Reference)

     [subentry #2] (Net Services Reference)

DLCR.TDBMS.OMD Oracle Names record (Net Services Admin Guide)

     [subentry #2] (Net Services Reference)

     [subentry #3] (Net Services Reference)

NS.SMD Oracle Names record (Net Services Admin Guide)

     [subentry #2] (Net Services Reference)

     [subentry #3] (Net Services Reference)

of Oracle Names Control utility, reference (Net Services Reference)

V1ADD.NPO.OMD Oracle Names record (Net Services Admin Guide)

     [subentry #2] (Net Services Reference)

     [subentry #3] (Net Services Reference)

query delta joins (Data Warehousing Guide)

query entry return limit (Internet Directory Admin Guide)

query example (Text Developer's Guide)

query execution path

including in report (SQL*Plus Guide)

including in report, 1 (iSQL*Plus User’s Guide)

query explain plan (Text Developer's Guide)

query expressions (Text Developer's Guide)

query features (Text Developer's Guide)

query feedback (Text Developer's Guide)

query optimization (Text Developer's Guide)

QUERY parameter

for Export utility (Utilities)

restrictions (Utilities)

query results (SQL*Plus Guide)

displaying on-screen (SQL*Plus Guide)

sending to a printer (SQL*Plus Guide)

     [subentry #2] (SQL*Plus Guide)

storing in a file (SQL*Plus Guide)

     [subentry #2] (SQL*Plus Guide)

QUERY REWRITE

privilege and session requirements (Spatial Guide)

query rewrite (Concepts)

     [entry #2] (OLAP Services Concepts and Administration Guide)

     [entry #3] (OLAP Services Concepts and Administration Guide for Windows)

     [entry #4] (OLAP Services Concepts and Administration Guide for Windows)

and dimensions (SQL Reference)

and function-based indexes (SQL Reference)

and rule-based optimization (SQL Reference)

controlling (Data Warehousing Guide)

correctness (Data Warehousing Guide)

defined (SQL Reference)

disabling (SQL Reference)

dynamic predicates in security policies (Concepts)

enabling (SQL Reference)

     [subentry #2] (Data Warehousing Guide)

enabling and disabling (SQL Reference)

hints (Data Warehousing Guide)

     [subentry #2] (Data Warehousing Guide)

matching join graphs (Data Warehousing Guide)

methods (Data Warehousing Guide)

parameters (Data Warehousing Guide)

privileges (Data Warehousing Guide)

restrictions (Data Warehousing Guide)

when it occurs (Data Warehousing Guide)

QUERY REWRITE object privilege (SQL Reference)

on a materialized view (SQL Reference)

QUERY REWRITE system privilege (SQL Reference)

     [entry #2] (SQL Reference)

     [entry #3] (OLAP Services Concepts and Administration Guide)

     [entry #4] (OLAP Services Concepts and Administration Guide for Windows)

query rewrite, 4-24 (OLAP Services Concepts and Administration Guide)

query string (Servlet Engine Developer's Guide)

query text (Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack)

query tuning (Text Developer's Guide)

query window (Spatial Guide)

query work areas (PL/SQL Guide)

query, executing (JDBC Guide)

query, XML (AppDev - XML)

query. See SQL query (OCI Programmer's Guide)

querying

audit log (Internet Directory Admin Guide)

critical events (Internet Directory Admin Guide)

recovery catalog (Recovery Manager User's Guide)

XML documents indexed with OracleText (AppDev - XML)

querying geometric segments

functions for (Spatial Guide)

querying rows (interMedia Guide)

QUERY_REWRITE_ENABLED initialization parameter (Performance Guide)

     [entry #2] (Reference)

setting with ALTER SESSION (SQL Reference)

setting with ALTER SYSTEM (SQL Reference)

QUERY_REWRITE_ENABLED parameter (Data Warehousing Guide)

     [entry #2] (Data Warehousing Guide)

QUERY_REWRITE_INTEGRITY initialization parameter (Reference)

setting with ALTER SESSION (SQL Reference)

setting with ALTER SYSTEM (SQL Reference)

queue (AppDev - Advanced Queuing (AQ))

altering (AppDev - Advanced Queuing (AQ))

creating (AppDev - Advanced Queuing (AQ))

creating, example (AppDev - Advanced Queuing (AQ))

DML (Text Developer's Guide)

dropping (AppDev - Advanced Queuing (AQ))

nonpersistent (AppDev - Advanced Queuing (AQ))

     [subentry #2] (AppDev - Advanced Queuing (AQ))

     [subentry #3] (AppDev - Advanced Queuing (AQ))

point-to-point (AppDev - Advanced Queuing (AQ))

selecting all (AppDev - Advanced Queuing (AQ))

selecting in user schema (AppDev - Advanced Queuing (AQ))

selecting, in user schema (AppDev - Advanced Queuing (AQ))

selecting, user has any privilege (AppDev - Advanced Queuing (AQ))

selecting, user has queue privilege (AppDev - Advanced Queuing (AQ))

staring (AppDev - Advanced Queuing (AQ))

starting (AppDev - Advanced Queuing (AQ))

stopping (AppDev - Advanced Queuing (AQ))

subscriber rules (AppDev - Advanced Queuing (AQ))

subscriber, selecting (AppDev - Advanced Queuing (AQ))

subscribers (AppDev - Advanced Queuing (AQ))

subscribers, selecting (AppDev - Advanced Queuing (AQ))

Queue Creation Scripts (Case Studies - XML Applications)

queue monitor (AppDev - Advanced Queuing (AQ))

queue monitor (QMN) (AppDev - Advanced Queuing (AQ))

queue monitor (QMNn) process

definition (Concepts)

queue monitor process (QMNn) (Concepts)

queue privilege

granting (AppDev - Advanced Queuing (AQ))

revoking (AppDev - Advanced Queuing (AQ))

queue propagation

scheduling (AppDev - Advanced Queuing (AQ))

unscheduling (AppDev - Advanced Queuing (AQ))

queue size (Net Services Admin Guide)

     [entry #2] (Net Services Admin Guide)

     [entry #3] (Net Services Admin Guide)

queue subscribers

selecting, rules (AppDev - Advanced Queuing (AQ))

queue table

     [entry #2] (AppDev - Advanced Queuing (AQ))

altering (AppDev - Advanced Queuing (AQ))

creating (AppDev - Advanced Queuing (AQ))

     [subentry #2] (AppDev - Advanced Queuing (AQ))

creating prioritized message (AppDev - Advanced Queuing (AQ))

creating, example (AppDev - Advanced Queuing (AQ))

     [subentry #2] (AppDev - Advanced Queuing (AQ))

     [subentry #3] (AppDev - Advanced Queuing (AQ))

     [subentry #4] (AppDev - Advanced Queuing (AQ))

creating, example, XMLType attributes (AppDev - Advanced Queuing (AQ))

dropping (AppDev - Advanced Queuing (AQ))

messages, selecting (AppDev - Advanced Queuing (AQ))

selecting all (AppDev - Advanced Queuing (AQ))

     [subentry #2] (AppDev - Advanced Queuing (AQ))

selecting messages (AppDev - Advanced Queuing (AQ))

selecting user tables (AppDev - Advanced Queuing (AQ))

queue table data

exporting (AppDev - Advanced Queuing (AQ))

queue tables

creating, example (AppDev - Advanced Queuing (AQ))

selecting all in user schema (AppDev - Advanced Queuing (AQ))

upgrading (Migration)

queue type

verifying (AppDev - Advanced Queuing (AQ))

queue, granted (Real Application Clusters Concepts)

     [entry #2] (Real Application Clusters Concepts)

queue-level access control (AppDev - Advanced Queuing (AQ))

     [entry #2] (AppDev - Advanced Queuing (AQ))

queue/topic

connection factory, registering (AppDev - Advanced Queuing (AQ))

connection factory, registering through LDAP (AppDev - Advanced Queuing (AQ))

connection factory, unregistering in LDAP through the database (AppDev - Advanced Queuing (AQ))

connection factory, unregistering in LDAP through the LDAP (AppDev - Advanced Queuing (AQ))

queues

XMLType (AppDev - XML)

QUEUESIZE parameter (Net Services Admin Guide)

for adjusting listener queue size (Net Services Admin Guide)

     [subentry #2] (Net Services Admin Guide)

     [subentry #3] (Net Services Admin Guide)

QUEUE_PRIVILEGES view (Reference)

queue_type (AppDev - Advanced Queuing (AQ))

queuing

basic (AppDev - Advanced Queuing (AQ))

basic, one producer, one consumer (AppDev - Advanced Queuing (AQ))

DBMS_AQADM package (Supplied PL/SQL Packages and Types Reference)

publish-subscribe support

event publication (Concepts)

queue monitor process (Concepts)

Quick Tour (Internet File System User's Guide)

starting (Oracle Enterprise Manager Getting Started with Oracle Change Management Pack)

quick tour (Data Guard Broker)

QuickSlice (Getting Started for Windows)

QuickTime

sprite and flash track (interMedia Annotator User's Guide)

text sample extraction (interMedia Annotator User's Guide)

video track extraction (interMedia Annotator User's Guide)

Quiesce Database (Concepts)

uses for (Concepts)

quiesce database

in Real Application Clusters (Real Application Clusters Administration)

Quiesce Database feature (Real Application Clusters Concepts)

QUIESCE RESTRICTED clause

of ALTER SYSTEM (SQL Reference)

quiescing (Replication)

     [entry #2] (Replication)

adding master sites with (Replication Management API Reference)

adding master sites without (Replication Management API Reference)

altering replicated objects without (Replication Management API Reference)

configuring conflict resolution methods without (Replication)

     [subentry #2] (Replication Management API Reference)

master groups (Replication Management API Reference)

     [subentry #2] (Supplied PL/SQL Packages and Types Reference)

minimum communication (Replication)

quiescing a database (Admin Guide)

quiescing the database (New Features)

QUIT command (Recovery Manager User's Guide)

     [entry #2] (Data Guard Broker)

     [entry #3] (Real Application Clusters Guard Administration and Reference)

     [entry #4] (Real Application Clusters Guard Administration and Reference)

     [entry #5] (Recovery Manager Reference)

     [entry #6] (SQL*Plus Guide)

of Listener Control utility (Net Services Reference)

of Oracle Connection Manager Control utility (Net Services Reference)

of Oracle Names Control utility (Net Services Reference)

See also (Data Guard Broker)

See also EXIT (SQL*Plus Guide)

quit() function

of UTL_SMTP (Supplied PL/SQL Packages and Types Reference)

quitting RMAN (Recovery Manager User's Guide)

quota agent (Internet File System Setup and Administration Guide)

QUOTA clause

of ALTER USER. (SQL Reference)

of CREATE USER (SQL Reference)

quotas

listing (Admin Guide)

revoking from users (Admin Guide)

revoking tablespace access and (Concepts)

setting to zero (Admin Guide)

     [subentry #2] (Concepts)

SYS user not subject to (Concepts)

tablespace (Admin Guide)

     [subentry #2] (Concepts)

temporary segments ignore (Concepts)

tablespace quotas (Admin Guide)

tablespace, definition (Concepts)

temporary segments and (Admin Guide)

unlimited (Admin Guide)

viewing (Admin Guide)

quotation marks

escape sequences for (OLAP DML Guide)

escaping (Utilities)

filenames (Utilities)

SQL (OLAP DML Guide)

SQL string (Utilities)

table names and (Utilities)

     [subentry #2] (Utilities)

use of in embedded SQL (Pro*PL/I Supplement to the Oracle Precompilers Guide)

use with database object names (SQL Reference)

     [subentry #2] (Utilities)

QUOTA_SIZE option

LOG_ARCHIVE_DEST_n initialization parameters (Data Guard Concepts and Administration)

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

QUOTA_USED option

LOG_ARCHIVE_DEST_n initialization parameters (Data Guard Concepts and Administration)

quoted identifiers (PL/SQL Guide)