W
wasNull() method (Java), 495
week, datetime formatting parameters for, 106
WHEN clause (EXCEPTION block), 345
WHEN MATCHED THEN clause (MERGE statement), 258
WHEN NOT MATCHED clause (MERGE statement), 258
WHERE clause (SELECT statement), 147, 200 “201, 328
comparison operators in, 37 “39
equality operator (=) in, 37, 167
filtering rows using, 37 “43
vs. HAVING, 534 “535
subqueries in, 166 “168
using with AVG(), 93
using to filter rows, 97, 530 “531
using with GROUP BY, 98
using with GROUP BY and HAVING, 98 “99
using with table joins, 45 “46
window functions, 214, 223 “229
Windows
backslash character (\) for directories, 10, 433
CLASSPATH for, 479
environment variables for Java, 477
Word documents, stored as LOBs, 428
WRITE() function, 439 “441
WRITEAPPEND() function, 469
write_example() procedure, 440