Index_B


B

backslash (\), for Windows directories, 10, 433
base tables, 320
BasicExample1.java program, 501 “509
compiling, 507
running, 507 “509
BasicExample2.java program, 512 “514
BasicExample3.java program, 523 “526
BCLOB data type, 554
BEFORE UPDATE OF clause, 361
BEGIN keyword, 349
BETWEEN operator, 41 “42
in non- equijoins , 50
when accessing a range of cells , 238
BFILE column, 433 “434
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
binary_buffer_var, 438
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
binary_test table, 24
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
blob_content table, 430
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
blocks (program), 332
BOOLEAN data type, 555
BREAK ON command, 161
BTITLE command, 160
buckets, with NTILE(), 222
business logic, PL/SQL for, 332



Oracle Database 10g SQL
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
Year: 2004
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net