SQL in a Nutshell (In a Nutshell (OReilly))

     
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

LAG function (Oracle)

LAST function (Oracle)

LAST_DAY function (Oracle)

LAST_INSERT_ID function (MySQL)

LAST_VALUE function (Oracle)

LCASE function (MySQL)

lct_admin function

LDAP (Lightweight Directory Access Protocol)

        on DB2 servers

LEAD function (Oracle)

LEAST function

        MySQL

        Oracle

LEFT [OUTER] JOIN

LEFT function

        DB2

        MySQL

        SQL Server

LEN function

        SQL Server

LENGTH function

        DB2

        MySQL

        Oracle

        PostgreSQL

LENGTHB function (Oracle)

less than (<) operator

less than or equal to (<= ) operator

LICENSE_ENABLED function

LIKE operator 2nd

        DB2

        keywords

        MySQL

        Oracle

        platform support for

        PostgreSQL

        programming tips

        quick reference

        rules

        SQL Server

        SQL2003 syntax

LINE datatype

        platform comparison

        PostgreSQL

literals 2nd

LN function

LNNVL function (Oracle)

LOAD_FILE function (MySQL)

LOCALTIMESTAMP function (Oracle)

LOCATE function

        DB2

        MySQL

LOCATE(substr,str,pos)

LOG function

        DB2

        MySQL

        Oracle

        PostgreSQL

        SQL Server

LOG10 function

        DB2

        MySQL

        SQL Server

LOG2 function (MySQL)

logfiles (Oracle)

logical operators 2nd

LONG datatype

        Oracle

        platform comparison

LONG RAW datatype

        Oracle

        platform comparison

LONG VARCHAR datatype

        DB2

        platform comparison

LONG VARCHAR FOR BIT DATA datatype

        DB2

LONG VARGRAPHIC datatype

        DB2

        platform comparison

LONG_VARCHAR function (DB2)

LONG_VARGRAPHIC function (DB2)

LONGBLOB datatype

        MySQL

        platform comparison

LONGTEXT datatype

        MySQL

        platform comparison

LOWER function

LPAD function

        MySQL

        Oracle

        PostgreSQL

LSEG datatype

        platform comparison

        PostgreSQL

LSEG function (PostgreSQL)

LTRIM function

        DB2

        MySQL

        Oracle

        PostgreSQL

        SQL Server

 

Категории