Oracle Database Master Index: Q
10g Release 1 (10.1)

Shortcuts to Letters

Symbols

Numerals

Index Entries

QB_NAME hint (Performance Tuning Guide)

QDR

with = command (OLAP DML Reference)

with assignment statement (OLAP DML Reference)

QMN0 process (Data Guard Concepts and Administration)

QS (Security Guide)

QS schema

installing (Sample Schemas)

scripts (Sample Schemas)

QS_ADM (Security Guide)

QS_CB (Security Guide)

QS_CBADM (Security Guide)

QS_CS (Security Guide)

QS_ES (Security Guide)

QS_OS (Security Guide)

QS_WS (Security Guide)

quadtree indexes

deprecated feature of Spatial (Spatial User's Guide and Reference)

QUAL function (OLAP DML Reference)

[entry #2] (OLAP DML Reference)

qualified data references (OLAP DML Reference)

ampersand substitution (OLAP DML Reference)

creating (OLAP DML Reference)

defined (OLAP DML Reference)

qualifying a relation (OLAP DML Reference)

replacing dimension of variable (OLAP DML Reference)

[subentry #2] (OLAP DML Reference)

[subentry #3] (OLAP DML Reference)

using with relation (OLAP DML Reference)

with = command (OLAP DML Reference)

with assignment statement (OLAP DML Reference)

with dimensions (OLAP DML Reference)

with relations (OLAP DML Reference)

with variables (OLAP DML Reference)

[subentry #2] (OLAP DML Reference)

[subentry #3] (OLAP DML Reference)

[subentry #4] (OLAP DML Reference)

[subentry #5] (OLAP DML Reference)

qualified data references (QDRs) (OLAP Application Developer's Guide)

qualified object name

defined (OLAP DML Reference)

qualifiers

using subprogram names as (PL/SQL User's Guide and Reference)

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

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

quality

degradation of R-tree index (Spatial User's Guide and Reference)

R-tree (Spatial User's Guide and Reference)

QUALITY_DEGRADATION function (Spatial User's Guide and Reference)

quantile numerical binning (PL/SQL Packages and Types Reference)

quantize operator (interMedia Reference)

[entry #2] (interMedia Reference)

queries

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

[entry #3] (SQL Reference)

[entry #4] (SQL Reference)

ad hoc (Data Warehousing Guide)

association with cursor (Pro*COBOL Precompiler Programmer's Guide)

association with cursors (Pro*C/C++ Precompiler Programmer's Guide)

avoiding the use of indexes (Performance Tuning Guide)

case-insensitive (PL/SQL User's Guide and Reference)

comments in (SQL Reference)

composite indexes (Concepts)

compound (SQL Reference)

correlated

left correlation (SQL Reference)

creating using Source methods (OLAP Developer's Guide to the OLAP API)

data (Performance Tuning Guide)

default locking of (Concepts)

define phase (Concepts)

defined (SQL Reference)

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

describe phase (Concepts)

dictionary views (Reference)

distributed (Administrator's Guide)

[subentry #2] (SQL Reference)

distributed application development issues (Administrator's Guide)

dynamic (Application Developer's Guide - Fundamentals)

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

enabling parallelism for (Data Warehousing Guide)

ensuring the use of indexes (Performance Tuning Guide)

errors in distributed queries (Application Developer's Guide - Fundamentals)

fetching rows (Concepts)

forwarding (Pro*C/C++ Precompiler Programmer's Guide)

grouping returned rows on a value (SQL Reference)

hierarchical, ordering (SQL Reference)

hierarchical. See hierarchical queries

hints (Reference)

hints in (SQL Reference)

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

improved performance (Data Guard Concepts and Administration)

in COPY command (SQL*Plus User's Guide and Reference)

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

in DML (Concepts)

incorrectly coded (Pro*C/C++ Precompiler Programmer's Guide)

inline views (Concepts)

join (SQL Reference)

[subentry #2] (SQL Reference)

kinds of (Pro*C/C++ Precompiler Programmer's Guide)

location transparency and (Administrator's Guide)

locking rows during (SQL Reference)

merged with view queries (Concepts)

multiple versions of rows (SQL Reference)

of past data (SQL Reference)

offloading on the standby database (Data Guard Concepts and Administration)

ordering returned rows (SQL Reference)

outer joins in (SQL Reference)

parallel processing (Concepts)

[subentry #2] (Concepts)

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

phases of (Concepts)

processing (Concepts)

read consistency of (Concepts)

referencing multiple tables (SQL Reference)

remote (Administrator's Guide)

requirements for (Pro*C/C++ Precompiler Programmer's Guide)

returning more than one row (Pro*C/C++ Precompiler Programmer's Guide)

select lists of (SQL Reference)

selecting from a random sample of rows (SQL Reference)

set membership (Application Developer's Guide - Object-Relational Features)

show number of records retrieved (SQL*Plus User's Guide and Reference)

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

[subentry #3] (SQL*Plus User's Guide and Reference)

single-row versus multirow (Pro*C/C++ Precompiler Programmer's Guide)

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

sorting results (SQL Reference)

Source objects that are not (OLAP Developer's Guide to the OLAP API)

specifying with Source objects (OLAP Developer's Guide to the OLAP API)

star queries (Data Warehousing Guide)

steps in retrieving results of (OLAP Developer's Guide to the OLAP API)

stored as views (Concepts)

syntax (SQL Reference)

temporary segments and (Concepts)

[subentry #2] (Concepts)

top-level (SQL Reference)

top-N (SQL Reference)

tracing (SQL*Plus User's Guide and Reference)

triggers use of (Concepts)

unnesting (Application Developer's Guide - Object-Relational Features)

varrays (Application Developer's Guide - Object-Relational Features)

queries, imbedded in code (Enterprise Manager Concepts)

queries, publishing (JPublisher User's Guide)

query

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

[entry #3] (Spatial User's Guide and Reference)

ABOUT (Text Application Developer's Guide)

accent-insensitive (New Features Guide)

accumulate (Text Reference)

analysis (Text Application Developer's Guide)

[subentry #2] (Text Reference)

AND (Text Reference)

blocking operations (Text Application Developer's Guide)

broader term (Text Reference)

case-insensitive (New Features Guide)

case-sensitive (Text Application Developer's Guide)

CATSEARCH (Text Application Developer's Guide)

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

CONTAINS (Text Application Developer's Guide)

counting hits (Text Application Developer's Guide)

CTXRULE (Text Application Developer's Guide)

equivalence (Text Reference)

example (Text Reference)

explicit describe (Oracle Call Interface Programmer's Guide)

getting report on (Text Application Developer's Guide)

hierarchical feedback (Text Reference)

log (Text Application Developer's Guide)

log analysis (New Features Guide)

MATCHES (Text Application Developer's Guide)

MINUS (Text Reference)

mixed (Text Application Developer's Guide)

narrower term (Text Reference)

NOT (Text Reference)

on unsynched index (Text Reference)

optimizing for throughput (Text Application Developer's Guide)

OR (Text Reference)

overview (Text Application Developer's Guide)

parallel (Text Application Developer's Guide)

preferred term (Text Reference)

related term (Text Reference)

report of logged (Text Reference)

speeding up with MDATA (Text Application Developer's Guide)

stored (Text Reference)

synonym (Text Reference)

threshold (Text Reference)

top term (Text Reference)

transactional (Text Reference)

[subentry #2] (Text Reference)

translation term (Text Reference)

translation term synonym (Text Reference)

viewing information on (Text Application Developer's Guide)

viewing log of (Text Application Developer's Guide)

weighted (Text Reference)

query access

using RESOURCE_VIEW and PATH_VIEW (XML DB Developer's Guide)

query analysis (Text Application Developer's Guide)

query API (Ultra Search User's Guide)

[entry #2] (Ultra Search User's Guide)

[entry #3] (Ultra Search User's Guide)

query application

example (Text Application Developer's Guide)

sample (Text Application Developer's Guide)

query builder (OLAP Application Developer's Guide)

Query by Example (HTML DB User's Guide)

query delta joins (Data Warehousing Guide)

query execution path

including in report (SQL*Plus User's Guide and Reference)

query explain plan (Text Application Developer's Guide)

query expressions (Text Application Developer's Guide)

query features (Text Application Developer's Guide)

query feedback (Text Application Developer's Guide)

query generation (PL/SQL Packages and Types Reference)

query language (Text Application Developer's Guide)

query log (Text Application Developer's Guide)

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

query model for Spatial (Spatial User's Guide and Reference)

query optimization (Data Warehousing Guide)

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

FAQs (Text Application Developer's Guide)

parallel execution (Data Warehousing Guide)

response time (Text Application Developer's Guide)

query optimizer (Performance Tuning Guide)

QUERY parameter

Data Pump Export utility (Utilities)

Data Pump Import utility (Utilities)

Export utility (Utilities)

restrictions (Utilities)

quotation marks

escape characters and (Utilities)

filenames and (Utilities)

SQL strings and (Utilities)

table names and (Utilities)

usage in Data Pump Export (Utilities)

usage in Data Pump Import (Utilities)

use with database object names (Utilities)

query performance

FAQs (Text Application Developer's Guide)

query relaxation (Text Application Developer's Guide)

query relaxation template (Text Reference)

query results

displaying on-screen (SQL*Plus User's Guide and Reference)

sending to a printer (SQL*Plus User's Guide and Reference)

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

storing in a file (SQL*Plus User's Guide and Reference)

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

QUERY REWRITE

privilege and session requirements (Spatial User's Guide and Reference)

query rewrite

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

[entry #3] (XML DB Developer's Guide)

advanced (Data Warehousing Guide)

and dimensions (SQL Reference)

checks made by (Data Warehousing Guide)

controlling (Data Warehousing Guide)

correctness (Data Warehousing Guide)

date folding (Data Warehousing Guide)

defined (SQL Reference)

dynamic predicates in security policies (Concepts)

[subentry #2] (Security Guide)

enabling (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

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)

using equivalences (Data Warehousing Guide)

using GROUP BY extensions (Data Warehousing Guide)

using nested materialezed views (Data Warehousing Guide)

using PCT (Data Warehousing Guide)

VPD (Data Warehousing Guide)

when it occurs (Data Warehousing Guide)

with bind variables (Data Warehousing Guide)

with DBMS_MVIEW package (Data Warehousing Guide)

with expression matching (Data Warehousing Guide)

with inline views (Data Warehousing Guide)

with partially stale materialized views (Data Warehousing Guide)

with selfjoins (Data Warehousing Guide)

with set operator materialized views (Data Warehousing Guide)

with view constraints (Data Warehousing Guide)

QUERY REWRITE object privilege (SQL Reference)

on a materialized view (SQL Reference)

QUERY REWRITE system privilege (OLAP Application Developer's Guide)

[entry #2] (SQL Reference)

query rewrite template (Text Reference)

query statistics (Ultra Search User's Guide)

query syntax expansion (Ultra Search User's Guide)

[entry #2] (Ultra Search User's Guide)

query tag library (Ultra Search User's Guide)

query template (Text Application Developer's Guide)

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

[entry #3] (Text Reference)

[entry #4] (Text Reference)

query window (Spatial User's Guide and Reference)

query work areas (PL/SQL User's Guide and Reference)

query, executing (JDBC Developer's Guide and Reference)

Query, XML (XML Developer's Kit Programmer's Guide)

query-based access

using SQL (XML DB Developer's Guide)

query. See SQL query (Oracle Call Interface Programmer's Guide)

querying

recovery catalog (Backup and Recovery Basics)

XML data (XML DB Developer's Guide)

XMLType (XML DB Developer's Guide)

transient data (XML DB Developer's Guide)

querying geometric segments

subprograms for (Spatial User's Guide and Reference)

QUERY_LOG_SUMMARY (Text Application Developer's Guide)

QUERY_LOG_SUMMARY procedure (Text Reference)

QUERY_PROCEDURE user_lexer attribute (Text Reference)

QUERY_REWRITE_ENABLED initialization parameter (Data Warehousing Guide)

[entry #2] (Data Warehousing Guide)

[entry #3] (Reference)

setting with ALTER SYSTEM (SQL Reference)

QUERY_REWRITE_INTEGRITY initialization parameter (Data Warehousing Guide)

[entry #2] (Reference)

setting with ALTER SYSTEM (SQL Reference)

queue

altering (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

creating (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

creating, example (Streams Advanced Queuing User's Guide and Reference)

DML (Text Application Developer's Guide)

dropping (Streams Advanced Queuing User's Guide and Reference)

nonpersistent (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

[subentry #3] (Streams Advanced Queuing User's Guide and Reference)

point-to-point (Streams Advanced Queuing User's Guide and Reference)

point-to-point, creating (Streams Advanced Queuing User's Guide and Reference)

selecting all (Streams Advanced Queuing User's Guide and Reference)

selecting in user schema (Streams Advanced Queuing User's Guide and Reference)

selecting, in user schema (Streams Advanced Queuing User's Guide and Reference)

selecting, user has any privilege (Streams Advanced Queuing User's Guide and Reference)

selecting, user has queue privilege (Streams Advanced Queuing User's Guide and Reference)

staring (Streams Advanced Queuing User's Guide and Reference)

starting (Streams Advanced Queuing User's Guide and Reference)

stopping (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

subscriber rules (Streams Advanced Queuing User's Guide and Reference)

subscriber, selecting (Streams Advanced Queuing User's Guide and Reference)

subscribers (Streams Advanced Queuing User's Guide and Reference)

subscribers, selecting (Streams Advanced Queuing User's Guide and Reference)

queue forwarding (Streams Concepts and Administration)

queue monito (Concepts)

queue monitor (Streams Advanced Queuing User's Guide and Reference)

queue privilege

granting (Streams Advanced Queuing User's Guide and Reference)

granting, point-to-point (Streams Advanced Queuing User's Guide and Reference)

revoking (Streams Advanced Queuing User's Guide and Reference)

revoking, point-to-point (Streams Advanced Queuing User's Guide and Reference)

queue propagation

scheduling (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

unscheduling (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

queue size (Net Services Administrator's Guide)

[entry #2] (Net Services Administrator's Guide)

[entry #3] (Net Services Administrator's Guide)

queue subscribers

selecting, rules (Streams Advanced Queuing User's Guide and Reference)

queue table

altering (Streams Advanced Queuing User's Guide and Reference)

creating (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

creating prioritized message (Streams Advanced Queuing User's Guide and Reference)

creating, example (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

[subentry #3] (Streams Advanced Queuing User's Guide and Reference)

[subentry #4] (Streams Advanced Queuing User's Guide and Reference)

[subentry #5] (Streams Advanced Queuing User's Guide and Reference)

creating, example, XMLType attributes (Streams Advanced Queuing User's Guide and Reference)

dropping (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

getting (Streams Advanced Queuing User's Guide and Reference)

messages, selecting (Streams Advanced Queuing User's Guide and Reference)

selecting all (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

[subentry #3] (Streams Advanced Queuing User's Guide and Reference)

selecting messages (Streams Advanced Queuing User's Guide and Reference)

selecting user tables (Streams Advanced Queuing User's Guide and Reference)

queue table data

exporting (Streams Advanced Queuing User's Guide and Reference)

queue tables

creating, example (Streams Advanced Queuing User's Guide and Reference)

selecting all in user schema (Streams Advanced Queuing User's Guide and Reference)

upgrading (Upgrade Guide)

queue type

verifying (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

queue-level access control (Streams Advanced Queuing User's Guide and Reference)

[entry #2] (Streams Advanced Queuing User's Guide and Reference)

queue/topic

connection factory in LDAP (Streams Advanced Queuing User's Guide and Reference)

connection factory, unregistering in LDAP through the database (Streams Advanced Queuing User's Guide and Reference)

connection factory, unregistering in LDAP through the LDAP (Streams Advanced Queuing User's Guide and Reference)

LDAP (Streams Advanced Queuing User's Guide and Reference)

queues

AnyData

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

[subentry #3] (Streams Advanced Queuing User's Guide and Reference)

[subentry #4] (Streams Concepts and Administration)

[subentry #5] (Streams Concepts and Administration)

creating (PL/SQL Packages and Types Reference)

creating (Streams Concepts and Administration)

dequeuing (Streams Advanced Queuing User's Guide and Reference)

dequeuing (Streams Concepts and Administration)

enqueuing (Streams Advanced Queuing User's Guide and Reference)

removing (PL/SQL Packages and Types Reference)

removing (Streams Concepts and Administration)

user-defined types (Streams Advanced Queuing User's Guide and Reference)

buffered queues (Streams Replication Administrator's Guide)

nontransactional (Streams Concepts and Administration)

propagation (Streams Advanced Queuing User's Guide and Reference)

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

secure (Streams Concepts and Administration)

disabling user access (Streams Concepts and Administration)

enabling user access (Streams Concepts and Administration)

users (Streams Concepts and Administration)

transactional (Streams Concepts and Administration)

typed (Streams Concepts and Administration)

QUEUESIZE networking parameter (Net Services Reference Guide)

QUEUESIZE parameter (Net Services Administrator's Guide)

for adjusting listener queue size (Net Services Administrator's Guide)

[subentry #2] (Net Services Administrator's Guide)

[subentry #3] (Net Services Administrator's Guide)

[subentry #4] (Net Services Reference Guide)

QUEUE_PRIVILEGES view (Reference)

queue_type (Streams Advanced Queuing User's Guide and Reference)

queuing

publish-subscribe support

event publication (Concepts)

queue monitor process (Concepts)

queuing documents (Ultra Search User's Guide)

QuickSlice (Platform Guide for Windows)

quiesce database (Concepts)

in Real Application Clusters (Real Application Clusters Administrator's Guide)

uses for (Concepts)

QUIESCE RESTRICTED clause

of ALTER SYSTEM (SQL Reference)

quiescing (Advanced Replication)

[entry #2] (Advanced Replication)

adding master sites with (Advanced Replication Management API Reference)

adding master sites without (Advanced Replication Management API Reference)

altering replicated objects without (Advanced Replication Management API Reference)

configuring conflict resolution methods without (Advanced Replication Management API Reference)

master groups (Advanced Replication Management API Reference)

single master

reduced (Advanced Replication)

quiescing a database (Administrator's Guide)

QUIT

SQL*Plus command (SQL Quick Reference)

QUIT command (Backup and Recovery Basics)

[entry #2] (Data Guard Broker)

[entry #3] (Recovery Manager Reference)

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

of Listener Control utility (Net Services Reference Guide)

[subentry #2] (Net Services Reference Guide)

of Oracle Connection Manager Control utility (Net Services Reference Guide)

quitting RMAN (Backup and Recovery Basics)

QUOTA clause

of ALTER USER. See CREATE USER

of CREATE USER (SQL Reference)

quotas

listing (Security Guide)

revoking from users (Security Guide)

setting to zero (Security Guide)

tablespace (Administrator's Guide)

[subentry #2] (Security Guide)

tablespace, definition (Concepts)

temporary segments and (Security Guide)

unlimited (Security Guide)

viewing (Security Guide)

quotation marks

in OLAP DML (OLAP Reference)

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

quotation marks (escape sequence) (OLAP DML Reference)

QUOTA_SIZE attribute

LOG_ARCHIVE_DEST_n initialization parameter (Data Guard Concepts and Administration)

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

QUOTA_USED attribute

LOG_ARCHIVE_DEST_n initialization parameter (Data Guard Concepts and Administration)

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

quoted strings

environment variables (Recovery Manager Reference)

QUOTED_PRINTABLE_DECODE function (PL/SQL Packages and Types Reference)

QUOTED_PRINTABLE_ENCODE function (PL/SQL Packages and Types Reference)

quoting character

user-specified (New Features Guide)

Oracle Database Master Index: Q 10g Release 1 (10.1)

Shortcuts to Letters

Index Entries

Oracle Database Master Index: Q
10g Release 1 (10.1)