Oracle8i Generic Documentation Master Index

F variable in SQLDA

factoring matrix

features, GTK 4-4

options, GTK 4-2

facts, STU 30-1

FAILED_LOGIN_ATTEMPTS parameter

of ALTER PROFILE, SQL 7-65

of CREATE PROFILE, SQL 7-340

FAILOVER, PSC 4-35, PSC 4-41, PSC 4-43

failover, NET C-43, SPS 4-11, SPS 16-2, SPS A-11, STU 11-6, STU 25-17

FAILOVER parameter, NET 2-29, NET 4-12, NET 4-15, NET 5-11, NET 7-11, NET 7-12, NET 7-14, NET C-40, PSC 4-35, PSC 4-41

fail-over sites

implementing, REP 8-14

failover sites

as in advanced replication, REP 1-5, SCN 34-6

FAILOVER_MODE parameter, NET C-43, PSC 4-35, PSC 4-43

failure

access to files, SPS 22-4

ALERT file, SPS 6-2

instance recovery, SPS 22-4

media, SPS 22-1, SPS 22-7, SPS A-22

MPP node, SPS 3-7

node, SPS 1-19, SPS 22-2

failure of fingerprint authentication, OAS 7-16

failures, SCN 32-2

false finger threshold, OAS 7-3

FALSE keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

false pings, SPS 9-17, SPS 15-15

FALSE value, PLS 2-8

fast commit, SCN 8-10

fast full index scans, SCN 23-36

FAST FULL SCAN, STU 11-3

fast full scan, STU 6-8

fast refresh, SCN 10-18, STU 32-5

FAST REFRESH mode

materialized views and downgrading, MIG 12-10

fast refreshes, REP 3-22

and table reorg, REP A-4

FAST_FULL_SCAN_ENABLED parameter, SRF 1-40

FAST_START_IO_TARGET initialization parameter

controlling checkpoints with, STU 20-40

recovery time and the, STU 25-4

FAST_START_IO_TARGET parameter, SCN 32-13

of ALTER SESSION, SQL 7-82, SQL 7-102

FAST_START_PARALLEL_ROLLBACK, SPS A-3

FAST_START_PARALLEL_ROLLBACK initialization parameter, STU 25-16

FAST_START_PARALLEL_ROLLBACK parameter, SRF 1-42

of ALTER SYSTEM, SQL 7-102

recovery parameter, STU 26-25

Fast-Start Checkpointing, SCN 32-13

fast-start checkpoints

controlling checkpoints, STU 20-40

FAST_START_IO_TARGET initialization parameter, STU 25-4

LOG_CHECKPOINT_INTERVAL initialization parameter, STU 25-4

LOG_CHECKPOINT_TIMEOUT initialization parameter, STU 25-3

Fast-Start fault recovery, GTK 2-51

see also transaction recovery

Fast-Start On-Demand Rollback, SCN 32-10

fast-start on-demand rollback, STU 25-15

fast-start parallel recovery

compatibility, MIG 8-42

Fast-Start Parallel Rollback, SCN 32-14

Fast-start Parallel Rollback

parallel rollback, Fast-start, SPS 22-16

fast-start parallel rollback, STU 25-15

Fast-Start Recovery, SCN 32-13

Fast-start Rollback, SPS A-3

fast-start rollback

compatibility, MIG 8-13, MIG 8-42

fatal errors

Export, SUT 1-40

Import, SUT 2-48, SUT 2-49

fault tolerance, SPS 8-8

FDS_CLASS, DDS 6-16

FDS_CLASS_VERSION, DDS 6-16

FDS_INST_NAME, DDS 6-17

feature factoring matrix, GTK 4-4

Features

automated coordination of enqueuing and dequeuing, ADQ 1-13

enhanced propagation scheduling capabilities, ADQ 1-14

non-persistent queues, ADQ 1-7

publish/subscribe support, ADQ 1-7

queue level access control, ADQ 1-6

features

new features, MIG 8-9

features requiring migration, REP B-12

features, LSM, LEG 1-4

types of storage devices supported, LEG 3-2

FEEDBACK

Export parameter, SUT 1-19

Import parameter, SUT 2-22

fetch

piecewise, OCI 5-32, OCI 5-36

FETCH DESCRIPTOR SQL statement, PC_ F-61

Fetch Elapsed Time data view, STU 15-11

fetch operation, OCI 4-14

LOB data, OCI 4-15

setting prefetch count, OCI 4-15

FETCH SQL statement, PC_ F-58, PCO F-48

FETCH statement, PC_ 14-26, PCO 5-14, PCO 5-15, PCO F-45, PLS 5-9, PLS 5-23

cursor variable, PCO 6-36

example, PCO 5-14

example of, PC_ 6-14

examples, PC_ F-60, PCO F-47

in dynamic SQL Method 4, PCO 11-37

INTO clause, PCO 5-14

INTO clause in, PC_ 6-14

purpose of, PC_ 6-12, PC_ 6-14

results of, PC_ 6-14

syntax, PLS 11-73

use in dynamic SQL method 3, PC_ 13-20

use in dynamic SQL method 4, PC_ 15-35

used after OPEN command, PC_ F-96

used after OPEN statement, PC_ F-93, PCO F-70, PCO F-72

using in dynamic SQL Method 3, PCO 9-21

fetch, batch, PCO 7-7

FETCH_ROW, DDS 7-3

FETCH_ROW procedure, DDS 7-7

fetching, DDS 7-8

across commits, PLS 5-49

in bulk, PLS 4-35

optimizing round-trips, DDS 7-8

rows from cursors, PC_ F-58, PC_ F-61, PCO F-45, PCO F-48

fetching in batches

batch fetch, PC_ 8-5

fetching rows, DDS 7-8

fetching rows in a query, SCN 16-14

embedded SQL, SCN 16-6

Fibonacci sequence, PLS 7-37

field, PLS 4-37

field conditions

specifying for SQL*Loader, SUT 5-44

field delimiters, SUT 3-19

field length

SQL*Loader specifications, SUT 5-83

field location

SQL*Loader, SUT 5-48

field type, PLS 4-38

fields

character data length and SQL*Loader, SUT 5-73

comparing, SUT 5-15

comparing to literals with SQL*Loader, SUT 5-46

DECIMAL EXTERNAL and trimming whitespace, SUT 5-83

delimited

determining length, SUT 5-74

delimited and SQL*Loader, SUT 5-70

enclosed and SQL*Loader, SUT 5-71

FLOAT EXTERNAL and trimming whitespace, SUT 5-83

INTEGER EXTERNAL and trimming whitespace, SUT 5-83

length, SUT 5-16

loading all blanks, SUT 5-82

numeric and precision versus length, SUT 5-16

numeric EXTERNAL and trimming whitespace, SUT 5-83

precision, SUT 5-16

predetermined size

length, SUT 5-73

predetermined size and SQL*Loader, SUT 5-83

relative positioning and SQL*Loader, SUT 5-84

specification of position, SUT 5-15

specified with a termination delimiter and SQL*Loader, SUT 5-70

specified with enclosure delimiters and SQL*Loader, SUT 5-71

specifying default delimiters for SQL*Loader, SUT 5-41

specifying for SQL*Loader, SUT 5-46

SQL*Loader delimited

specifications, SUT 5-83

terminated and SQL*Loader, SUT 5-70

VARCHAR

never trimmed, SUT 5-83

ZONED EXTERNAL and trimming whitespace, SUT 5-83

FIELDS clause

SQL*Loader, SUT 5-41

terminated by whitespace, SUT 5-86

figurative constants

embedded SQL statements, PCO 2-15

FILE

associating with OS file, OCI 7-5

datatype, OCI 3-20

Export parameter, SUT 1-19

Import parameter, SUT 2-22

keyword

SQL*Loader, SUT 8-29

locator, OCI 7-4

SQL*Loader command-line parameter, SUT 6-6

file, SBR 6-3

FILE columns

Import, SUT 2-60

file extension

for INCLUDE files, PCO 2-22

file identify wait event, SRF A-29

file I/O, PLS 8-17

FILE keyword, SUT 8-29

file length limit, PCO 2-16

file management locks, SCN 27-30

file open wait event, SRF A-29

file set enqueue, SRF B-2

file storage, designing, STU 20-5

FILE_LOCK view, SPS 9-22, SPS 15-11, SPS A-9, SRF 2-162

FILE_PING view, SRF 2-163

filenames

case significance, SRF 1-3

listing for backup, SBR 13-2

name and number, SRF 1-44

quotation marks, SUT 5-19

specifying multiple SQL*Loader, SUT 5-23

SQL*Loader, SUT 5-18

SQL*Loader bad file, SUT 5-25

files

FILESIZE, SUT 1-19

filespec clause, SQL 7-490

of CREATE CONTROLFILE, SQL 7-245

of CREATE DATABASE, SQL 7-250

of CREATE LIBRARY, SQL 7-297

of CREATE TABLESPACE, SQL 7-393

of CREATE TEMPORARY TABLESPACE, SQL 7-398

FILESPERSET parameter

tuning backups, STU 20-53

FILEXT$ view, SRF 2-165

FILLER field

example, SUT 4-39

FILLER support, PCO A-7

filter columns

for simple subquery snapshots, REP 3-13

finding bootstrap, LEG 5-5

fine grain lock, SPS 9-4, SPS 9-6, SPS 9-16, SPS 9-18, SPS 9-19, SPS 9-20, SPS 9-21

creation, SPS 9-3

DBA lock, SPS 9-17

group factor, SPS 15-9

introduction, SPS 7-5

one lock element to one block, SPS 9-17

specifying, SPS 15-9

fine grain locking, SPS 2-8, SPS A-9

fine grained quiesce, REP A-3

fine-grain locks, PSC 1-18

1 block-to-1 block ratio, PSC 1-18

fixed, PSC 1-18

releasable, PSC 1-18

when to use, PSC 1-19

fine-grained access control, ADG 12 - 26, GTK 2-69, SCN 30-22

compatibility, MIG 8-13

DBMS_RLS package, SPR 41 - 1, GTK 2-69

Fine-Grained Access Support, SUT 2-52

finger utility, NET 9-11

fingerprint accuracy, OAS 7-2, OAS 7-4

fingerprint authentication failure, OAS 7-16

Finish page

Replication Manager, REP 2-10

setup wizard, REP 2-10

FIPS compliance, SQL B - 3

FIPS flagger

interactive SQL statements and, ADG 8 - 2

warns of array usage, PC_ 8-4, PCO 7-5

warns of missing Declare Section, PC_ 4-12

warns of use of pointers as host variables, PC_ 5-7

FIPS flagging, SQL 7-82

FIPS precompiler option, PC_ 10-21, PCO 14-21

FIPS standard, SCN 16-6

firewall support, NET 2-49, NET 4-30

Net8 Firewall Proxy, NET 2-49

Oracle Connection Manager, NET 2-49

firewalls, and SSL, OAS 9-11

FIRST collection method, PLS 4-23

FIRST_ROWS, SRF 1-89

FIRST_ROWS hint, SCN 23-33, SQL 2-59, STU 7-39, STU 26-24

fix_corrupt_blocks procedure, SAD 19-5, SAD 19-7

fixed hashed PCM lock, SPS 9-3

fixed mode, lock element, SPS 9-20

fixed record length

example, SUT 4-34

fixed views, SCN 2-7

FIXED_DATE initialization parameter, ADG 4 - 9

FIXED_DATE parameter, SRF 1-42

of ALTER SYSTEM, SQL 7-102

fixed-format records, SUT 3-5

flag, PLSQL_V2_COMPATIBILITY, PLS 5-68

FLAGGER parameter

of ALTER SESSION, SQL 7-82

flagging of nonstandard features, SCN 16-6

flags, PCO 8-22

warning flags, PC_ 9-15

flexibility of parallel database, SPS 1-14

FLOAT

external datatype, OCI 3-11

FLOAT datatype, PC_ 4-6, PCO 4-11, SUT 5-59

EXTERNAL format

FLOAT EXTERNAL data values

SQL*Loader, SUT 5-67

FLOAT keyword

SQL*Loader, SUT 5-67

FLOAT subtype, PLS 2-13

floating-point numbers, SQL 2-15

FLOOR function, SQL 4-15

FLUSH command, NET A-38

FLUSH SHARED POOL clause

of ALTER SYSTEM, SQL 7-99

FLUSH_NAME command, NET A-39

flushing, OCI 13-10

object changes, OCI 10-14

objects, OCI 13-10

flushing the LOB's buffer, ADL 2-15

FM format model modifier, SQL 2-46

FM number format element, SQL 2-36

FOR CATEGORY clause

of CREATE OUTLINE, SQL 7-322

FOR clause, PCO 7-16

FOR EACH ROW clause, ADG 13 - 12

of CREATE TRIGGER, SQL 7-406

FOR loop, PLS 3-10

dynamic range, PLS 3-12

iteration scheme, PLS 3-10

loop counter, PLS 3-10

nested, PLS 3-14

FOR loop, cursor, PLS 5-13

FOR UPDATE clause, PLS 5-8

LOBs, ADL 1-49, ADL 2-2

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-307

of SELECT, SQL 7-544, SQL 7-551

restriction on, PLS 5-19

when to use, PLS 5-47

FOR UPDATE OF clause, PCO 3-28

locking rows with, PC_ 3-24

purpose of, PC_ 3-24

when to use, PC_ 3-24

FORALL statement, PLS 4-32

syntax, PLS 11-77

using with BULK COLLECT clause, PLS 4-35

FORCE ANY TRANSACTION system privilege, SQL 7-502

FORCE CLAUSE

of DROP OPERATOR, SQL 7-463

FORCE clause

of COMMIT, SQL 7-215

of COMMIT statement, PC_ F-26, PCO F-17

of CREATE DIMENSION, SQL 7-260

of CREATE VIEW, SQL 7-432

of DISASSOCIATE STATISTICS, SQL 7-445

of DROP INDEX, SQL 7-455

of DROP INDEXTYPE, SQL 7-456

of DROP TYPE, SQL 7-481

of REVOKE schema_object_privileges, SQL 7-534

of ROLLBACK, SQL 7-538

of ROLLBACK statement, PC_ F-100, PCO F-76

FORCE mode, warning notice, PSC 6-19

FORCE option

object type dependencies, SCN 14-17

FORCE PARALLEL DDL option, SCN 26-24, SCN 26-27

create or rebuild index, SCN 26-25, SCN 26-27

create table as select, SCN 26-26, SCN 26-27

move or split partition, SCN 26-25, SCN 26-28

FORCE PARALLEL DML clause

of ALTER SESSION, SQL 7-79

FORCE PARALLEL DML option

insert, SCN 26-23, SCN 26-24, SCN 26-27

update and delete, SCN 26-22, SCN 26-27

FORCE parameter

and job-to-instance affinity, SPS 4-10

force refreshes, REP 3-23

FORCE TRANSACTION system privilege, SQL 7-502

forcing

COMMIT or ROLLBACK, DDS 3-21, DDS 3-30

forcing a log switch, SAD 6-16

with the ALTER SYSTEM command, SAD 6-16

foreground process

instance shutdown, SPS 18-26

foreign function libraries

exporting, SUT 1-55

importing, SUT 2-60

foreign key, DDS 4-3

representing many-to-one entity relationship with, ADG 16 - 7

FOREIGN KEY clause

of constraint_clause, SQL 7-219, SQL 7-223

FOREIGN KEY constraint

defining, ADG 5 - 30, ADG 5 - 31

enabling, ADG 5 - 22, ADG 5 - 31, SAD 20-19

NOT NULL constraint and, ADG 5 - 9

number of rows referencing parent table, ADG 5 - 9

one-to-many relationship, ADG 5 - 9

one-to-one relationship, ADG 5 - 9

UNIQUE key constraint and, ADG 5 - 9

updating tables, ADG 5 - 10, ADG 5 - 11

FOREIGN KEY constraints

changes in parent key values, SCN 28-16

constraint checking, SCN 28-20

deleting parent table rows and, SCN 28-17

maximum number of columns in, SCN 28-13

nulls and, SCN 28-15

updating parent key tables, SCN 28-16

foreign key constraints, SQL 7-223

foreign keys, SCN 1-58

defined, SCN 1-59

partially null, SCN 28-16

privilege to use parent key, SCN 30-5

Foreign system

global name, DDS A-5

foreign tables

rowids of, SQL 2-23

formal parameter, PLS 5-8

format

function, PLS 7-5

packaged procedure, PLS 7-10

procedure, PLS 7-3

format elements, NLS 4-9, NLS 4-10

C, NLS 4-10

D, NLS 2-19, NLS 4-10

day, NLS 2-14

G, NLS 2-19, NLS 4-10

IW, NLS 4-10

IY, NLS 4-10

L, NLS 2-20, NLS 4-10

month, NLS 2-14

RM, NLS 2-12, NLS 4-9

RN, NLS 4-10

format mask, PCO 4-45

when needed, PLS 2-28

format masks

TO_DATE function, ADG 4 - 8

format models, SQL 2-33

changing the return format, SQL 2-34

date, SQL 2-40

date, changing, SQL 2-40

date, default, SQL 2-40

date, format elements, SQL 2-40

date, maximum length, SQL 2-40

modifiers, SQL 2-46

number, SQL 2-35

number, elements of, SQL 2-36

specifying, SQL 2-35

format parameter (RMAN)

backup command, SBR 4-31

FORMAT precompiler option, PCO 14-23

purpose, PCO 2-12

FORMAT statement in DB2

not allowed by SQL*Loader, SUT B-4

FORMAT statement in Oracle Trace, STU 15-19, STU 15-20

format, lock name, SPS 7-8

formats

and SQL*Loader input records, SUT 5-52

for dates and numbers. See format models.

of return values from the database, SQL 2-33

of values stored in the database, SQL 2-33

formats of COBOL statements

ANSI, PCO 2-12

TERMINAL, PCO 2-12

formatter tables in Oracle Trace, STU 15-5

formatting

EXPLAIN PLAN output, STU 13-24

formatting errors

SQL*Loader, SUT 5-25

Forms

upgrading Oracle Forms applications, MIG 9-6

forward declaration, PLS 7-9

when needed, PLS 7-9, PLS 7-40

forward reference, PCO 5-13, PLS 2-35

forward references

why not allowed, PC_ 6-12

forward type definition, PLS 9-29

%FOUND cursor attribute, PLS 5-34, PLS 5-38

fractured block detection, SBR 4-55

fragmentation

parallel DDL, SCN 26-33

reducing database fragmentation via full export/import, SUT 2-46

fragmentation, external, STU 27-13

free buffer inspected statistic, SRF C-9

free buffer requested statistic, SRF C-10

free buffer waits wait event, SRF A-30

free global transaction table entry wait event, SRF A-30

free list, SPS 11-15

free list group

assigned to instance, SPS 11-13, SPS 11-14

assigning to session, SPS 17-10

definition, SPS 11-5

enhanced for release 7.3, SPS A-9

high performance feature, SPS 4-8

setting blocks, SPS 15-8

unused space, SPS 17-16

used space, SPS 17-16

free lists, SCN 4-9

adding, STU 21-22

contention, STU 21-21

reducing contention, STU 21-22

free process state object wait event, SRF A-30

free space

coalescing, SAD 9-8

coalescing extents, SCN 4-13

SMON process, SCN 1-19, SCN 8-11

coalescing within data blocks, SCN 4-9

free lists, SCN 4-9

listing free extents, SAD 20-33

parameters for data blocks, SCN 4-5

section of data blocks, SCN 4-5

tablespaces and, SAD 9-32

free space list

locating space, SRF 1-52

FREE SQL statement, PC_ 17-6, PC_ F-63

FREE statement, PCO F-50

free() function, PC_ 15-37

example of using, PC_ 15-37

FREE_LIST_INST parameter (Oracle Version 6), SPS A-20, SPS A-21

FREE_LIST_PROC parameter (Oracle Version 6), SPS A-20, SPS A-21

FREED_EXTENTS, SPS A-10

freeing

objects, OCI 10-32, OCI 13-9

thread context, PC_ 11-10, PC_ F-29, PCO F-20

FREELIST GROUPS parameter

of STORAGE clause, SQL 7-578

FREELIST GROUPS storage option, SPS 17-6, SPS 17-14, SPS 18-14, SRF 1-52

clustered tables, SPS A-20

instance number, SPS 11-15

FREELISTS

parameter, SPS 11-5

storage option, SPS 17-6

freelists

specifying for a table, partition, cluster, or index, SQL 7-578

FREELISTS parameter, STU 26-75

of STORAGE clause, SQL 7-578

FREELISTS storage option

clustered tables, SPS A-20

indexes, SPS 17-8

maximum value, SPS 17-6, SRF 1-28

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY parameter, SPS 22-4, SPS A-6, SRF 1-43

FROM clause

of queries, SQL 5-22

of REVOKE system_privileges_and_roles, SQL 7-530

of SELECT, SQL 7-546

FROM COLUMNS clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM FUNCTIONS clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM INDEXES clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM INDEXTYPES clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM PACKAGES clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM PUBLIC clause

of REVOKE schema_object_privileges, SQL 7-534

FROM role clause

of REVOKE schema_object_privileges, SQL 7-534

FROM TYPES clause

of DISASSOCIATE STATISTICS, SQL 7-445

FROM user clause

of REVOKE schema_object_privileges, SQL 7-534

FROMUSER

Import parameter, SUT 2-23

front-ends, SCN 6-2

FTP

Export files, SUT 1-52

ftp sample in Net8 OPEN, NET 9-11

FULL

Export parameter, SUT 1-20

full backups, SBR 4-37

full database mode

Import, SUT 2-23

full field names, SUT 3-22

FULL hint, SQL 2-59, STU 6-7, STU 7-42

full index scans, SCN 23-35

full partition-wise joins, STU 13-21, STU 26-52

full scan, PCO D-6

description of, PC_ C-6

full table scan, STU 4-8

full table scans, SCN 23-34, SCN 23-48

LRU algorithm and, SCN 7-4

multiblock reads, SCN 23-51

parallel execution, SCN 26-5, SCN 26-6

rule-based optimizer, SCN 23-54

selectivity and, SCN 23-51

function, PLS 7-1, PLS 7-5

RETURN clause, PLS 7-6

specification, PLS 7-6

syntax, PLS 11-79

function expressions

built-in, SQL 5-5

function names

coding guidelines, OCI 2-36

function prototype

definition of, PC_ 10-13

function specification

of CREATE TYPE, SQL 7-416

function-based indexes, GTK 2-24, SAD 16-9, SCN 10-24, SQL 7-277, STU 6-12

and query rewrite, SQL 7-87

compatibility, MIG 8-10

creating, SQL 7-280

dependencies, SCN 10-26, SCN 21-7

DISABLED, SCN 21-8

disabling, SQL 7-39, SQL 7-106

enabling, SQL 7-36, SQL 7-38, SQL 7-106

privileges, SCN 10-26, SCN 21-8

returning values of type methods, ADG 18 - 32

UNUSABLE, SCN 21-8

functions

3GL, calling, SQL 7-297

access to tables and packages, SQL 7-416

associating statistics with, SQL 7-196

attributes, OCI 6-8

avoiding run-time compilation, SQL 7-27

calling, SQL 7-210

cannot serve as host variables, PC_ 4-16

changing the declaration of, SQL 7-27

codes, OCI 15-230

datatype of return value, SQL 7-270

declaring

as a Java method, SQL 7-271

as C functions, SQL 7-271

defining an index on, SQL 7-280

disassociating statistics types from, SQL 7-452

examples, SQL 7-271

executing, SQL 7-210

from parallel query process, SQL 7-270

external, SQL 7-267, SQL 7-333

function-based indexes, SCN 10-24

hash functions, SCN 10-54

invalidating local objects dependent on, SQL 7-452

issuing COMMIT or ROLLBACK statements, SQL 7-79

Java

parallel execution, SCN 26-46

naming rules, SQL 2-69

new and updated calls, OCI 1-12

PL/SQL, SCN 18-2, SCN 18-6

contrasted with procedures, SCN 1-56, SCN 18-2

DETERMINISTIC, SCN 21-8, SCN 23-9

deterministic, SCN 23-9

parallel execution, SCN 26-46

privileges for, SCN 30-7

roles, SCN 30-20

See also procedures

privileges executed with, SQL 7-415

recompiling, SAD 20-25

recompiling invalid, SQL 7-27

re-creating, SQL 7-268, SQL 7-293

removing from the database, SQL 7-452

schema executed in, SQL 7-415

specifying schema and user privileges for, SQL 7-270

SQL, SCN 16-2

COUNT, SCN 10-35

default column values, SCN 10-8

in CHECK constraints, SCN 28-18

in views, SCN 10-14

new in Oracle8i, MIG E-3

NVL, SCN 10-8

optimizing view queries, SCN 23-23

stored, SQL 7-267

storing return value of, SQL 7-211

synonyms for, SQL 7-355

user-defined, SQL 4-56

extensible optimization, SCN 22-16

using a saved copy of, SQL 7-270