B
backslash (\), for Windows directories, 10, 433
BasicExample1.java program, 501 “509
compiling, 507
running, 507 “509
BasicExample2.java program, 512 “514
BasicExample3.java program, 523 “526
BEFORE UPDATE OF clause, 361
BETWEEN operator, 41 “42
in non- equijoins , 50
when accessing a range of cells , 238
BFILE data
loading into an internal BLOB, 464
loading into an internal CLOB, 464 “466
loading into an internal LOB, 460 “464
bfile_content table, 430 “431
BFILENAME() function, 433
BFILEs (binary files), 429, 554
closing, 450 “451
closing all, 451
containing a pointer to an external file, 432
using, 432 “434
BIN subdirectories, adding to PATH, 478
binaryContent.doc example file, 428 “429
BINARY_DOUBLE type, 12, 22 “24, 552
BINARY_DOUBLE_INFINITY type, 24
BINARY_DOUBLE_NAN type, 24
BINARY_FLOAT type, 12, 22 “24, 552
BINARY_FLOAT_INFINITY type, 24
BINARY_FLOAT_NAN type, 24
BINARY_INTEGER data type, 555
bind variables , 511, 538 “541
colon when referencing, 539
listing and printing, 540
for PL/SQL returned values, 540
to store rows from a REFCURSOR, 541
binding data sources, 484
binding variables to statements, 511
BLOB and CLOB, vs. LONG and LONG RAW types, 429
BLOBs (binary LOBs), 429
adding content to, 431 “432
freeing temporary, 454
initializing, 431
loading BFILE data into, 464
temporary, 447 “448
using, 431 “432
block structure (PL/SQL), 332 “334
buckets, with NTILE(), 222
business logic, PL/SQL for, 332