Index - SQL Bible [Electronic resources] نسخه متنی

Index

N

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