Oracle9i DBA JumpStart

F

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