FALSE values, vs. NULL values, 82
FEEDBACK system variable, 184
fields
blank, 5–6
defined, 4
files. See also trace files
alert log files, 290–293, 291
control files, 161, 162
datafiles, 161, 161
locations for installation, 166–167, 167, 174, 174
redo log files, 161, 162
flashback query
basics of, 273–275
vs. Log Miner, 283
footers, formatting, 185–188
FOREIGN KEY constraints, 149–151, 151
foreign keys, 5–6
free buffers, 164
full outer joins, 107–108, 110–111
function-based indexes, 245
functions
built-in single-row functions, 52–65
conversion functions, 60–62
date functions, 58–60
general functions, 62–65
numeric functions, 55–58
string functions, 52–55
defined, 52
group functions, 85–91
basics of, 85–87
GROUP BY clause, 87–89
HAVING clause, 90–91
NVL and, 89
stored functions, defined, 65, 67
user-defined functions, 65–67