Index_L

L

LAG() function, 214, 232

LAST keyword, 232 “233, 410 “411

last row, getting using LAST_VALUE(), 228 “229

last_address() procedure, 410

LAST_DAY() function, 117

last_name column (customers table), 14

LAST_VALUE() function, 228 “229

LD_LIBRARY_PATH environment variable, 480

LEAD() function, 214, 232

leaf node, 195

LEFT OUTER JOIN keywords, 58

left outer joins, 51 “52, 58

LENGTH() function, 66 “67

LEVEL pseudo-column, 196 “197

LIKE operator, 40 “41

line size , setting, 151

linear regression functions, 215, 233 “234

Linux

environment variables for Java, 477 “478

forward slash (/) for directories, 10, 433

LD_LIBRARY_PATH environment variable, 480

LIST command, 144

LOADBLOBFROMFILE() function, 464

LOADCLOBFROMFILE() function, 464 “466

LOADFROMFILE() function, 460 “464

LOB chunk space used to store LOB value, 455

LOB content, 430

LOB locator, 430

LOB types, 429 “430

LOB value

cutting shorter, 468 “469

getting the length of, 455 “456

reading part of, 467 “468

LOBs (large objects), 427 “474

appending data to, 469

appending source content to destination, 441 “442

checking for already opened, 459

checking whether temporary, 460

closing, 442 “443

comparing, 443 “445

copying from source to destination, 445 “447

creating tables containing, 430 “431

getting storage limit of, 455

introduced, 428

loading BFILE data into, 460 “464

opening, 466 “467

Oracle Database 10g enhancements to, 471 “473

parts of, 430

reading data from, 436 “439

removing all or part of, 449 “450

using from within PL/SQL, 434 “469

using from within SQL, 431 “434

writing data to, 439 “441

LOBs in a trigger, :new attribute when using, 473

lob_schema_10g.sql, 430, 471

lob_schema.sql, 430, 436 “469

LOCALTIMESTAMP() function, 128 “129

locking transactions, 264

locks (database), 264

logical operators, 42

logical unit of work, transaction as, 258, 262

LONG columns , using, 470 “471

LONG data type, 429, 470 “471, 554

LONG RAW columns, using, 470 “471

LONG RAW type, 429, 470 “471, 554

long_content table, 470

long_raw_content table, 470

looking up data sources, 484

loop variables, lower and upper bounds for, 336 “337

looping, 510

loops (PL/SQL), 335 “337

LOWER() function, 67

LPAD() function, 68, 197

LTRIM() function, 68