Index_F

F

false. See Boolean expressions

FEAL, 445

fields, database. See columns

filegroup

DB2 UDB 8.1, 131–132

described, 130–131

MS SQL Server 2000, 132–133

Oracle 9i, 131

specifying, 99–100

files

adding to tablespace, Oracle 9i, 166

large external, managing (DATALINK), 74

physical location, specifying

altering and destroying, 166–167

changing, when table created in wrong, 147

creating, 131–133

described, 130–131

dropping, 167

information, listing, DB2 UDB 8.1, 467

specifying, 98, 110

finding

equal expressions (COALESCE and NULLIF), 362

NULL values (COALESCE), 363–364

NULL values (NVL, NL2, and ISNULL), 363–364

and replacing characters within string (TRANSLATE), 326–327

tables without constraints, 474–475

First Normal Form, 632–633

FirstBase v9.3.2, 768

fixed server roles

MS SQL Server 2000, 433

Transact-SQL privileges, 415

fixed-length character strings, 44–45

flat-file database, 11–12, 630–631

floating-point numbers

ANSI/ISO code, 549

storing, 58–59

foreign key

changes, automatic (CASCADE), 90, 92–93

described, 18

information, viewing

DB2 UDB 8.1, 466

MS SQL Server 2000, 472

listing, 457

tables

constraints, 88, 89–90

dropping, 158

relationships, ACME database, 615

format

constraints for security, 438

date and time

altering, 209–210

ANSI, 67

specifying, 333

strings, DB2 UDB 8.1, 354–355

products output combining price and description, 321–322

format template, 347, 349

FORTRAN, 532

forward slash (/)

format templates, 349

PL/SQL function, 517

four-digit years, 351

FoxPro/FoxBase, 768

free databases, 11

FROM clause, SELECT statement, 250–252

full outer join, 301–302

fully qualified names, 121

functions

calculating set of values (aggregate)

average (AVG), 343

column values, adding (SUM), 339–240

described, 338

exclusion of NULL values, 342

listed by database, 339

minimum and maximum (MIN AND MAX), 344

records in table/view (COUNT), 340–342

caution about renaming tables, 151

COALESCE and NULLIF, 362

converting data types

described, 344–345

different character sets, 355–357

pitfalls, 365

specific types, by database, 357–358

between types (CAST AND CONVERT), 345–355

date and time

adding dates (ADD_MONTHS and DATEADD), 333–335

listed by database, 329

months between two dates (MONTHS_BETWEEN and DATEDIFF), 337–338

name of date/time part, returning (DAYNAME, MONTHNAME, and DATENAME), 336–337

part of date/time, extracting (EXTRACT and DATEPART), 335

settings (GETDATE, SYSDATE, and CURRENT DATE), 330

time zone, 330–333

DB2 UDB 8.1

column, listed, 715

procedures, listed, 716

table, listed, 716

DECODE and CASE, 359–361

described, 307–310

listed by database, 359

MS SQL Server 2000

aggregate, 719–720

configuration, 722

cursor, 720

date and time, 719

information, viewing, 472

mathematical, 718

metadata, 721

rowset, 726

security, 722–723

statistical, 725

string, 716–717

system, 723–725

text and image, 720

numeric, 310–315

NVL, NVL2, and ISNULL, 363–364

OCI, 575

Oracle 9i

aggregate, listed, 704–705

analytic, listed, 706–708

character, listed, 697–698

conversion, listed, 700–701

datetime, listed, 698–699

number, listed, 696

object reference, listed, 708

scalar, listed, 709–715

single-row, listed, 702–703

string

blank spaces, removing (TRIM, LTRIM, and RTRIM), 327–328

character position, determining (CHARINDEX, INSTR, LOCATE, and POSSTR), 318–320

concatenating (CONCAT), 317–318

data type, converting to character data type (TO_CHAR, CHAR, and STR), 324

described, 315–317

finding and replacing characters within (TRANSLATE), 326–327

lowercase or uppercase, converting string expressions to (LOWER and UPPER), 323–324

number of characters (LENGTH), 322–323

replacing expressions (REPLACE), 325

replicating characters (REPLICATE and REPEAT), 325–326

starting position and required character length (SUBSTR and SUBSTRING), 320–322

user-defined, 365–366

fuzzy logic, LIKE operator, 377–381