Index

see also authorization; permissions; role-based security; statement-level permissions.

DB2, 321

MySQL, 326

Oracle, 317

REVOKE command, 306

SQL Server, 311

foreign keys, 23

ProductCatalog database, 392

DELETE statement, 80

UPDATE statement, 78

= operator, 36, 50, 51

!= operator, 51

& operator, 45

*=, =*, *=* operators, 186

^= operator, 51

|| operator, 41, 43

ALL, 156

ANY, 157

arithmetic operators, 108

assignment operator, 219

bitwise operators, 109

comparison operators, 108

CROSS JOIN operator, 169

DIFFERENCE operator, 158

EXCEPT, 164

EXISTS, 155

INTERSECT, 164

MINUS, 164

modulus operator, 108

precedence, 109

set operators, 158

using in expressions, 108

WHERE clause, 51

bitwise operators, 109

WHERE clause, 54

XOR (exclusive OR), 109

accuracy of rounding, 96

ASC keyword, 46

DESC keyword, 46

ordering rows before sampling

ProductCatalog database, 406, 407, 422, 423

sorting data, 46

use with OVER keyword, 104

using aliases with, 96

DB2, 224

Oracle, 222

role-based security, 479, 485

alternative syntax, 186

full outer joins, 184

inner joins compared, 428

left outer joins, 181

Oracle syntax, 186

ProductCatalog database, 427

right outer joins, 183

analytic functions, 103

RANK function, 102