Index

L

LANGUAGE clause, 248

languages

declarative, 5

procedural, 5

wrapping SQL, 7

LAST_INSERT_ID function, 440

LCASE function

see LOWER function.

LEFT function

Access, 125

DB2, 123

MySQL, 124

Oracle, 122

SQL Server, 121

string manipulation, 120

LEFT OUTER JOIN keyword, 189

left outer joins, 181

LEN/LENGTH function, 120

LIKE keyword

complex pattern matching, 61

escaping reserved characters, 59

multiple row subqueries, 153

pattern matching, 57

ProductCatalog database, 443

LIMIT keyword, 97

DELETE statement, 80

ProductCatalog database, 409, 411

UPDATE statement, 78

LOCAL scope, cursors, 236

locking

see also transaction isolation levels.

deadlocks, 297

lock type related cursor options, 236

transactions, 285

log files, transactions, 269

TRUNCATE statement, 332

LOG function, 112

logging in

see authentication.

long data type

Access, 537

Oracle, 533

long raw data type, 533

longbinary data type, 537

longblob data type, 535

longtext data type, 535

loops

FOR loop, 239

implicit cursors, 239

stored procedures, 233

WHILE loop, 233

LOWER function, 120