Index

N

naming conventions

stored procedures, 457

tables, 8

natural joins, 190

nchar data type

Oracle, 533

SQL Server, 532

NCLOB data type, 533

negative numbers, 113

nested joins, 174

nested queries, 389

nested transactions, 282

NEW accessor, 375

NO CASCASE BEFORE trigger, 382

non-correlated subqueries, 147, 154

non-equi joins, 175

normalization

defining table relationships, 17

relational databases, 18

NOT EXISTS keywords

ProductCatalog database, 436

NOT FOUND state, 259

NOT keyword

BETWEEN (NOT BETWEEN), 55

bitwise operators, 109

IN (NOT IN), 56

LIKE (NOT LIKE), 57

NULL (NOT NULL), 63

WHERE clause, 54

NOT NULL constraint, 333

InstantUniversity database, 515

NO_DATA_FOUND exception, 256

ntext data type, 532

NULL, 63

concept explained, 14

DB2 example, 451

INSERT/INSERT INTO statements, 333

inserting rows, 69

meaning in COUNT function, 84

NOT NULL constraint, 333

primary keys, 336

showing in group functions, 92

SQL Server example, 446

treatment by AVG function, 88

treatment by SUM function, 88

number data type, 534

number manipulation

see also casting

arithmetic operators, 108

bitwise operators, 109

comparison operators, 108

converting to strings, 40

exponents, 113

functions, 113

hexadecimal numbers, 114

negative numbers, 113

rounding numbers, 114

numeric data types, 14, 531

Access, 537

DB2, 535

MySQL, 536

Oracle, 534

ProductCatalog database, 401

SQL Server, 532

nvarchar data type

Oracle, 533

SQL Server, 532