|
|
name
alias
checking for customers, 364
creating, 121–125
destroying, 164–165
FROM clause, 251–252
physical object, lack of, 246–248
attributes, pairing with system data types, 68
conventions, ACME sample database, 614–615
current database, MS SQL Server 2000, 481
length restrictions, database objects, 8
parameters, passing by, 495–496
part of date (DAYNAME, MONTHNAME, AND DATENAME), 336–337
synonym
altering, 164–165
creating, 121–125
destroying, 164–165
Oracle 9i, 123, 124, 460, 462
reasons to use, 121–122
SQL99, 122–123
system-generated, altering, Oracle 9i, 159
table
changing, 151
and creation date belonging to current user, 463
defined, 15
NAND (inverse AND), 786–787
national character strings, 45–51, 345
National Security Agency. See NSA
natural join, SQL99 Equijoin table join, 283
NCSC (U.S. National Computer Security Center)
C2-level security certification, 453
standardizing security procedures, 451
nesting
queries, 302
subqueries, 249, 262–263
tables, Oracle 9i, 70–71
transactions, 220
Netscape Communications, 445
networking
connections, sharing, 140
databases, 14–15
transactions over distributed databases, 224
NIST (U.S. Government Department of Commerce's National Institute of Standards and Technology), 24, 444
nondeterministic functions, 307
nonequijoin, 284–286
nonprofit organization database, 10–11
Non-Stop SQL, 769
NOR (inverse OR), 777
normalization, relational database
defined, 16, 631
First Normal Form, 632–633
Second Normal Form, 633–634
Third Normal Form, 634–635
NOT bitwise operator (~), 383, 390
not equal to operators (<>, !=, !<, !>), 387
NOT logical operator
complement or inverter, 775
described, 381–382
precedence, 383
SELECT statement, IN operator, 257–258
NOT NULL columns, 178
NSA (National Security Agency), 454
NULL values
allowing, MS SQL Server 2000, 212, 213–214
arithmetic operators, 372
column constraints, 85, 86, 148
data types, 75
excluding, calculating set of values, 342
host variables, embedded SQL, 532–533
multiple columns, populating, 183–184
setting all values to, 194
sorting precedence, 269
specifying, MS SQL Server 2000, 259
number of joins, multi-table, 291–293
numbers
approximate, 58–59
columns, scale, changing, MS SQL Server 2000, 155
connection, 772–773
converting, 773–774
encrypting, 443
exact, 54–57
format templates, 352–353
Oracle 9i functions, listed, 696
programming languages, corresponding, 532
SQL functions, 310–315
NVL, NVL2, and ISNULL functions, 363–364
|
|