Index

F

false, boolean value, 108

FAST_FORWARD cursor type, 236

FETCH FIRST clause, 98

ProductCatalog database, 410, 422

FETCH keyword, 237

FIRST FETCH, 98

FETCH_STATUS variable, 239

filtering rows

aggregated (see HAVING clause).

individually (see WHERE clause).

unique retrieval (see DISTINCT keyword).

FIRST FETCH keyword, 98

flexibility

bitmasked access mode, 455

permissions, 456

float data type

MySQL, 536

Oracle, 534

SQL Server, 532

FLOAT function, 136

FLOOR function, 114

Access, 118

DB2, 115

Oracle, 116, 130

SQL Server, 115

FLUSH PRIVILEGES command, 325

FOR loop, 239

FOR triggers

see AFTER triggers.

foreign key constraint, 23, 358

creating tables, 331

dropping tables, 331

InstantUniversity database, 518

many-to-many relationship, 25

one-to-many relationship, 23

primary key relationship illustrated, 22

ProductCatalog database, 392, 398, 399, 401

referential integrity, 359

FORWARD_ONLY cursor option, 236

FROM keyword, 4

front end alternatives, 2

full outer joins, 184

functions

see also keywords.

ABS, 112

absolute value of a value, 112

analytic functions, 103

AVG, 88

CAST, 115, 136

CEIL/CEILING, 114

CHAR, 44

CHARINDEX, 120, 121

CONCAT, 43

CONVERT, 136

COS, 112

COUNT, 84

creating functions, 137

DB2, 141

MySQL, 142

Oracle, 140

SQL Server, 139

data type conversions, 133

DATE, 133

DATEDIFF, 128

datetime functions, 126

DAYS, 131

DEC/DECIMAL, 136

DOUBLE, 136

FLOAT, 136

FLOOR, 114

generic casting functions, 136

GETDATE, 16, 129

HEX, 114

INSTR, 120

INT/INTEGER, 136

LEFT, 120

LEN/LENGTH, 120

logarithmic functions, 112

LOWER, 120

mathematical functions, 112

MAX, 89

MID, 120

MIN, 89

number functions, 113

parameters, 111

POSSTR, 120

power, raising value to a, 112

random number generation, 112

RANK, 99

REPLACE option, 140

RIGHT, 120

ROUND, 114

square root, 112

stored procedures returning values, 482

STR, 40

string manipulation functions, 119

SUBSTR/SUBSTRING, 120

SUM, 87

TO_CHAR, 114

TO_DAYS, 131

TO_NCHAR, 134

TO_NUMBER, 135

trigonometric functions, 112

UPPER/UCASE, 120

using, 111