Oracle Database 10g SQL (Osborne ORACLE Press Series)

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

WHILE loops , 336

wildcard characters , 40

window functions, 214, 223 “229

Windows

backslash character (\) for directories, 10, 433

CLASSPATH for, 479

environment variables for Java, 477

WITH ADMIN OPTION, 285

WITH CHECK OPTION, 323

WITH GRANT OPTION, 278

Word documents, stored as LOBs, 428

wrapper classes, 496

Wrapper object, 495

WRITE() function, 439 “441

WRITEAPPEND() function, 469

write_example() procedure, 440