Oracle Database 10g SQL (Osborne ORACLE Press Series)

F

FETCH statement ( cursors ), 339

file commands, 145 “148

file name , getting, 452

file pointer, in BFILEs, 432 “433

file on the server, checking for, 451 “452

FILECLOSE() function, 450 “451

FILECLOSEALL() function, 451

file_example() procedure, 461

FILEEXISTS() function, 451 “452

FILEGETNAME() function, 452

FILEISOPEN() function, 453

FILEOPEN() function, 453 “454

files

checking whether open , 453

editing, 146

opening, 453 “454

retrieving, 146

running, 146

saving, 146

filtering rows using the WHERE clause, 37 “43

finally clause, 500 “501

firing a trigger, 358, 361 “362

FIRST keyword, 232 “233, 410

first row, getting using FIRST_VALUE(), 228 “229

first_address() procedure, 410

first_name column (customers table), 14

FIRST_VALUE() function, 228, 229

FLOAT data type, 553

floating point numbers

double precision 64 “bit, 22

single precision 32 “bit, 22

FLOOR() function, 74

FOR EACH ROW clause, 361

FOR loops , 336 “337, 510

accessing cells using, 240 “241

cursors and, 341 “342

foreign key, 16

foreign key constraints

adding, 302 “303

enforcement of, 254 “255

foreign key relationship, 48 “49, 254

formatting columns , 148 “150

forName() method (java.lang.Class), 481

FREETEMPORARY() function, 454

FROM clause (of SELECT statement), 283, 432

calling a function in, 354

subqueries in, 169 “170

with table joins, 45

FROM_TZ() function, 131

FULL OUTER JOIN keywords, 59

full outer joins using SQL/92, 59

fully qualified column references (joins), 532 “533

function-based index, creating, 317 “318

functions

aggregate functions, 88 “92

analytic functions, 214 “235

calling, 353 “354

calling in a package, 357 “358

character functions, 62 “71

combining, 71

conversion functions, 76 “83

creating, 352 “353

distribution functions, 235

dropping, 354

getting information on, 354

hypothetical rank and distribution, 234 “235

inverse percentile functions, 223

linear regression functions, 215, 233 “234

numeric functions, 71 “76

PL/SQL, 352 “354

vs. procedures, 369

public or private, 355

ranking functions, 216 “223

regular expression functions, 83 “88

returning a value from, 252

simple, 61 “100

single row functions, 62 “88

types of in Oracle database, 62

using expressions with, 71

window functions, 223 “229

functions in a package, getting information on, 358