---

W

W date format element, SQL 2-41

wait event

parameter descriptions, SRF A-9

wait time, SPS 1-4, SPS 1-10, STU 1-3, STU 1-4, STU 27-5

wait, session, SPS 15-17

Waits by Average Wait Time data view, STU 15-12

Waits by Event Frequency data view, STU 15-12

Waits by Total Wait Time data view, STU 15-12

waits for blocking transaction, SCN 27-10

Wallet Manager, SCN 29-5

Wallet Manager, Oracle, GTK 2-73

wallet resource locator, definition, OAS Glossary-8

wallets, SCN 29-5

definition, OAS 9-6, OAS Glossary-7

setting location, OAS 9-24, OAS 9-33

WAN environments

vulnerabilities of, OAS 1-2

warehouse, STU 28-1

advisor, STU 32-2

materialized views, SCN 10-17

refresh, STU 29-7, STU 32-2

refresh, tips, STU 32-9

refreshing table data, SCN 26-37

See also data warehousing

warning

archiving mode for first backup, SBR 3-16

changing data dictionary storage parameters, SAD 20-27

consistency and Export backups, SBR 13-16

creating a rollback segment, SAD 2-12

disabling audit options, SAD 25-12

enabling auditing, SAD 25-10

setting the CONTROL_FILES parameter, SAD 2-10

use mirrored control files, SAD 5-2

warning flags

use in error reporting, PC_ 9-15

warning flags for error reporting, PCO 8-22

warning messages, SUT 1-39

WebDB, GTK 2-2, GTK 2-5

week numbers, NLS 4-9

well-known Oracle Names servers, NET 2-43

WHEN clause, ADG 13 - 13, PLS 3-7, PLS 6-15

cannot contain PL/SQL expressions, ADG 13 - 13

correlation names, ADG 13 - 16

example, SUT 4-19

examples, ADG 13 - 3, ADG 13 - 12, ADG 13 - 32, ADG 13 - 41

EXCEPTION examples, ADG 13 - 18, ADG 13 - 41, ADG 13 - 47, ADG 13 - 48

of CREATE TRIGGER, SQL 7-407

SQL*Loader, SUT 5-40, SUT 5-44

SQL*Loader discards resulting from, SUT 5-29

WHENEVER

DO CALL example, PCO 8-31

WHENEVER directive, PCO 8-28, PCO F-91

careless usage, PCO 8-33

CONTINUE action, PCO 8-29

DO CALL action, PCO 8-29

DO PERFORM action, PCO 8-29

example, PCO 8-30

examples, PC_ F-121, PCO F-93

GOTO action, PCO 8-30

NOT FOUND condition, PCO 8-28

overview, PCO 2-11

purpose, PCO 8-28

scope of, PCO 8-33

SQLERROR condition, PCO 8-28

SQLWARNING condition, PCO 8-28

STOP action, PCO 8-30

syntax, PCO 8-30

using to check SQLCA automatically, PCO 8-28

WHENEVER DO CALL, PCO A-3

WHENEVER NOT SUCCESSFUL clause

of NOAUDIT schema_objects, SQL 7-526

WHENEVER SQL directive, PC_ F-119

WHENEVER statement

automatic checking of SQLCA with, PC_ 9-24

CONTINUE action in, PC_ 9-25

DO action in, PC_ 9-25

DO BREAK action in, PC_ 9-25

DO CONTINUE action in, PC_ 9-25

examples of, PC_ 9-26

GOTO action in, PC_ 9-25

guidelines for, PC_ 9-29

maintaining addressability for, PC_ 9-30

new actions, PC_ A-3

NOT FOUND condition in, PC_ 9-24

overview of, PC_ 2-9

scope of, PC_ 9-28

SQLERROR condition in, PC_ 9-24

SQLWARNING condition in, PC_ 9-24

STOP action in, PC_ 9-25

use in user exits, PC_ 20-9

using to avoid infinite loops, PC_ 9-29

using to handle end-of-data conditions, PC_ 9-29

where to place, PC_ 9-29

WHENEVER SUCCESSFUL clause

of AUDIT schema_objects, SQL 7-206

of AUDIT sql_statements, SQL 7-199

of NOAUDIT schema_objects, SQL 7-526

of NOAUDIT sql_statements, SQL 7-524

WHERE clause, PCO 5-11

and string comparisons, NLS 4-7

DELETE statement, PCO 5-11

host arrays in, PC_ 8-16

if omitted, PC_ 6-11

in DELETE statements, PC_ 6-10

in SELECT statements, PC_ 6-8

in UPDATE statements, PC_ 6-10

of DELETE, SQL 7-441

of DELETE statement, PC_ F-45, PCO F-33

of SELECT, SQL 5-19, SQL 7-548

of UPDATE, SQL 7-588

of UPDATE statement, PC_ F-115, PCO F-87

purpose of, PC_ 6-10

search condition, PCO 5-11

search condition in, PC_ 6-10

SELECT statement, PCO 5-8

UPDATE statement, PCO 5-10

using host tables, PCO 7-18

WHERE CURRENT OF clause, PCO 5-16

CURRENT OF clause, PC_ 6-17

WHILE loop, PLS 3-9

WHITESPACE, SUT 5-16

whitespace

included in a field, SUT 5-85

leading, SUT 5-82

terminating a field, SUT 5-85

trailing, SUT 5-82

trimming, SUT 5-82

WHITESPACE keyword

SQL*Loader, SUT 5-70

whole database backups, SBR 13-3 to SBR 13-5, SCN 1-50, SCN 32-23

ARCHIVELOG mode, SBR 13-3

consistent, SBR 3-2

backup control files and, SBR 3-3

using SHUTDOWN ABORT command, SBR 3-3

definition, SBR 3-2

inconsistent, SBR 3-4

NOARCHIVELOG mode, SBR 13-3

preparing to take, SBR 13-4

restoring from, SBR 14-17

using RMAN, SBR 8-3

wildcard, PLS 2-45

using to grand LSM administrator privileges, LEG 2-27

wildcards

in views, SAD 15-4

Windows NT

renaming configuration files, LEG 5-22

SAP R/3 integration with LSM, LEG 1-7

saving disk information, LEG 5-8

Setting up Japanese version of LSM, LEG 2-18

WITH ADMIN OPTION clause

of GRANT system_privileges_and_roles, SQL 7-495

WITH CHECK OPTION clause

of CREATE VIEW, SQL 7-430, SQL 7-434

of DELETE, SQL 7-441

of INSERT, SQL 7-515

of SELECT, SQL 7-542, SQL 7-547

of UPDATE, SQL 7-587

WITH CONTEXT clause, ADG 11 - 28

WITH CONTEXT clause and external procedure, DCI 4-9

WITH GRANT OPTION, ADG 12 - 18

WITH GRANT OPTION clause

of GRANT object_privileges, SQL 7-507

WITH HOLD

clause of DECLARE CURSOR statement, PCO 5-13

WITH HOLD clause, PCO A-5

WITH INDEX CONTEXT clause

of CREATE OPERATOR, SQL 7-319, SQL 7-321

WITH OBJECT IDENTIFIER clause

of CREATE VIEW, SQL 7-433

WITH OBJECT OID clause, SCN 15-3, SCN 15-4

WITH OBJECT OID. See WITH OBJECT IDENTIFIER.

WITH PRIMARY KEY clause

of ALTER MATERIALIZED VIEW, SQL 7-50

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316

of CREATE MATERIALIZED VIEW/SNAPSHOT...REFRESH, SQL 7-304

WITH READ ONLY clause

of CREATE VIEW, SQL 7-430, SQL 7-434

of DELETE, SQL 7-441

of INSERT, SQL 7-515

of SELECT, SQL 7-542, SQL 7-547

of UPDATE, SQL 7-587

WITH ROWID clause

of column ref constraints, SQL 7-225

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316

of CREATE MATERIALIZED VIEW/SNAPSHOT...REFRESH, SQL 7-304

with_context

argument to external procedure functions, OCI 18-3

WMON goes to sleep wait event, SRF A-20

WNDS argument, ADG 10 - 67

WNDS parameter

of PRAGMA RESTRICT_REFERENCES, SQL 7-175

WNPS argument, ADG 10 - 67

WNPS parameter

of PRAGMA RESTRICT_REFERENCES, SQL 7-175

words, reserved, PLS E-1

word-size

changing, MIG 1-4, MIG 7-37

work area, query, PLS 5-16

WORK option

of COMMIT statement, PC_ F-25, PCO F-16

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

workflow, REP 8-30

workload, STU 1-6, STU 18-1

adjusting, STU 27-8

exceeding, STU 27-5

skew, STU 27-32

workload skewing, SCN 26-19

workloads

and scaleup, SPS 1-13

balancing, SPS 1-6

mixed, SPS 1-5

partitioning, SPS 1-21

type of, SPS 1-5, SPS 1-12

WORM devices

and read-only tablespaces, SAD 9-14

wrapper

procedural replication, REP 1-15, SCN 34-16

wrapper to hide PL/SQL code, ADG 10 - 27

Wrapper utility, PLS C-1

writable tablespaces, SAD 9-14

write batch size, STU 20-43

write complete wait event, SRF A-50

write-ahead, SCN 8-9

writers block readers, SCN 27-10

writes stopped by instance recovery or database suspension wait event, SRF A-50

WRL, OAS Glossary-8

WW date format element, SQL 2-41

---