|
|
abstract data type. See ADT
Access. See MS Access
attempts, monitoring, 398
DB2 UDB 8.1
CLP, 680–683
sequences, 137–138
MS SQL Server 2000 utilities, 683–688
Oracle 9i
sequences, 136–137
utilities, 675–680
access control. See authorization
ACID test, 217
ACME sample database
column constraints and defaults, 617
described, 9
general information and business rules, 613–614
indexes, 617
installing
on DB2 UDB 8.1, 691–693
on MS SQL Server 2000, 693–694
on Oracle 9i, 689–691
naming conventions, 614–615
scripts, 617–627
tables, relationships between, 615
ActiveX (Microsoft), 578
activity, monitoring
DB2 UDB 8.1, 448–449
described, 397, 398
MS SQL Server 2000, 449–451
Oracle 9i, 447–448
ADABAS database, 14, 767
adding data
populating tables (INSERT)
for all columns, 182–183
clauses, described, 178–179
DB2 UDB 8.1, 189–190
described, 177–178
integrity constraints, 186
MS SQL Server 2000, 190–192
NULL and default values, 183–184
Oracle 9i, 188–189
from other tables, 184–185
SQL99 specifics, 187–188
value for specified column, 179–181
rows
multiple, 189
and updating (MERGE), 202–204
secure handling, 440–441
views, restricting, 438
with SELECT statement, 248–249
adding (mathematical operation)
column values (SUM), 37, 339–240
date and time functions (ADD_MONTHS and DATEADD), 333–335
multiple query results, 270–278
objects, 413
rows to table, 541
addition operator (+)
described, 367
precedence, 383
addresses
listing by customer ID, 254
structure, creating, 72
administrative tasks. See DBA (database administrator)
Adobe Acrobat Reader, 611
ADO.NET, 583–588
ADT (abstract data type), 68
aggregate functions
GROUP BY clause, 264
MS SQL Server 2000, 719–720
Oracle 9i, 704–705
summary tables, 105
views, joining, 119–120
alias
checking for customers, 364
creating, 121–125
destroying, 164–165
FROM clause, 251–252
physical object, lack of, 246–248
all columns, selecting, 242–243
ALL logical operator, 373
alphabetical order, customers, sorting, 267–268
altering. See also changes
columns
adding, 147–148, 152, 154
modifying, 148, 154–155
removing, 149, 155–156
triggering, 524
constraints
creating, 149–150, 152–153, 156
deferring, 93–94
disabling and enabling, 150–151
modifying, 149
read-only, 115–116
removing, 150, 153, 156
customer credit status, 361
database objects, cross-reference, 169–170
existing data (UPDATE)
column in all rows, 194
DB2 UDB 8.1, 151–153, 198
described, 33–34, 192–193
integrity constraints, 197
MS SQL Server 2000, 154–156, 198
multiple columns, 194
Oracle 9i, 146–151, 198
SET clause, 193
single column of single row, 194
single-row subquery, 195–197
SQL99, 146
WHERE clause, 193
flexibility, 5
identity column options, modifying, 152
physical attributes, changing, 147
privilege, assigning, 38
renaming, 151
with SELECT statement, 248–249
sequences
DB2 UDB 8.1, 168
Oracle 9i, 168
single-row subquery with correlated, 196–197
summary table options, altering, 153
views
DB2 UDB 8.1, 163
MS SQL Server 2000, 163
Oracle 9i, 162
restricting, 438
analytic functions, Oracle 9i, listed, 706–708
AND bitwise operator (&), 390
AND logical operator, 381, 775
ANSI (American National Standards Institute)
data type codes, 549
defaults, MS SQL Server 2000, 212
dynamic SQL and SQL99 standards, 543
history of standards, 5, 21, 29
time formats, 67
ANY | SOME logical operator, 373
API (Application Programming Interface)
CLI
DB2 UDB 8.1, 571–573
MS SQL Server 2000, 683–686
SQL99 standard, 557–562
DOM, 592
JDBC, 566–571
Microsoft Data Access Interfaces, 581–589
OCI, 573–578
ODBC, 562–565
OO40, 578–580
apostrophe ('), 349
applications
caution about renaming tables, 151
CD-ROM, back of the book, 611–612
name of, MS SQL Server 2000, 482–483
applications, installing
ACME database
on DB2 UDB 8.1, 691–693
on MS SQL Server 2000, 693–694
on Oracle 9i, 689–691
DB2 UDB 8.1, 658–666
MS SQL Server 2000, 666–673
Oracle 9i
general information, 637–638
on Linux, 653–658
on SUN Solaris, 648–653
on Windows NT/2000/XP, 638–648
uninstalling
DB2 UDB 8.1, 666
MS SQL Server 2000, 672–673
Oracle 9i, 646–647, 653
approximate numbers
DB2 UDB 8.1, 58
MS SQL Server 2000, 59
Oracle 9i, 58
SQL99, 58
archiving
business rules, complex, 185
values from other tables, 184–185
arguments. See parameters
arithmetic operators, 367–372
arrays, 605
AS/400, 357
ascending order. See sequences
ASCII
blank space in string, indicating, 319
commands, typing, 40
data, encrypting, 445–446
defined, 46
NULL sorting precedence, 269
string function, 316
Ashton-Tate database, 476
assignment operator (:=), PL/SQL, 490
assignment operators, SQL, 385–386
assignment value, deriving, 195–196
asterisk (*)
columns, selecting all, 242–243
outer joins, MS SQL Server 2000, 295–296, 299, 300–301
at sign (@), 494
ATM withdrawal operation, 217–218
atomicity rule, 217
attributes
identifying in relational database design, 630–631
managing, 560
pairing names with system data types, 68
tables, defining, 629–630
audio files, holding. See binary strings
auditing
DB2 UDB 8.1, 448–449
described, 397, 398
MS SQL Server 2000, 449–451
Oracle 9i, 447–448
Ault, Michael (Oracle Administration and Management), 209
authentication
DB2 UDB 8.1, 401
defined, 397, 398
author-created materials, 610–611
authorities, database, 466
authorization, 397, 398
authorization ID, session, 208
automatic changes (CASCADE)
foreign key, 92–93
privileges, revoking, 425, 429
rows, deleting, 201
table constraints, 90
tables, dropping, 157
average (AVG)
NULL, ignoring, 342
set of values, 37, 343
|
|