Index_A

A

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




SQL Bible
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net