Kline K.E. — SQL in a Nutshell :: Электронная библиотека попечительского совета мехмата МГУ

Главная Ex Libris Книги Журналы Статьи Серии Каталог Wanted Загрузка ХудЛит Справка Поиск по индексам Поиск Форум

Авторизация

Поиск по указателям

Kline K.E. — SQL in a Nutshell

Обсудите книгу на научном форуме

Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter

Название: SQL in a Nutshell

Автор: Kline K.E.

Аннотация:

This essential desktop reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It includes the command syntax (by vendor, if the syntax differs across implementations), a description, and practical examples. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format.

Язык:

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Издание: second edition

Год издания: 2004

Количество страниц: 710

Добавлена в каталог: 07.03.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID

Предметный указатель

intermediate table, defining
INTERSECT set operator
interval
INTERVAL datatype
INTERVAL DAY datatype
INTERVAL DAY TO SECOND datatype
Interval function
INTERVAL YEAR datatype
INTERVAL YEAR TO MONTH datatype
INTO
INTTOHEX
INTTOHEX function
INVALIDATE
IS
Is operator
ISCLOSED
ISCLOSED function (PostgreSQL)
ISDATE
IsDate function
isfinite
ISFINITE function (PostgreSQL)
ISNULL
ISNULL function
isnumeric
IsNumeric function
ISOPEN
ISOPEN function (PostgreSQL)
IS_FREE_LOCK
IS_FREE_LOCK function (MySQL)
IS_MEMBER
IS_MEMBER function
IS_SEC_SERVICE_ON
IS_SEC_SERVICE_ON function
IS_SRVROLEMEMBER
IS_SRVROLEMEMBER function
ITERATION_NUMBER
ITERATION_NUMBER function (Oracle)
Java
Java Virtual Machine (JVM) class loader
JDBC
JDBC (Java Database Connectivity)
JDBC ResultSet
Join
Join clause      2nd
JOIN subclause
JOIN syntax
JULIAN_DAY
JULIAN_DAY function (DB2)
KEYSET
keywords
keywords and parameters
Lag
LAG function (Oracle)
Language
last
LAST function (Oracle)
LAST_DAY
LAST_DAY function (Oracle)
LAST_INSERT_ID
LAST_INSERT_ID function (MySQL)
LAST_VALUE
LAST_VALUE function (Oracle)
LCase
LCASE function (MySQL)
lct_admin
lct_admin function
LDAP
LDAP (Lightweight Directory Access Protocol)
Lead
LEAD function (Oracle)
LEAST
LEAST function
Left
Left function
LEFT [OUTER] JOIN
LEN
Len function
Length
length function
LENGTHB
LENGTHB function (Oracle)
less than (<) operator
less than or equal to (<= ) operator
levels of system privileges
Library
LICENSE_ENABLED
LICENSE_ENABLED function
LIKE
LIKE operator
LIMIT
LINE datatype
LINKTYPE URL
Literals      2nd
ln
LN function
LNNVL
LNNVL function (Oracle)
LOAD_FILE
LOAD_FILE function (MySQL)
local
local index partitioning
LOCAL TEMPORARY
LOCALTIMESTAMP
LOCALTIMESTAMP function (Oracle)
locate
LOCATE function
LOCATE(substr,str,pos)
LOCK ANY TABLE
LOCKSIZE
LOG
LOG function
LOG10
Log10 function
log2
LOG2 function (MySQL)
LOGFILE      2nd
logfiles
logfiles (Oracle)
LOGGED
logging
logical operators      2nd
logical operators and
long datatype
LONG RAW datatype
LONG VARCHAR datatype
LONG VARCHAR FOR BIT DATA datatype
LONG VARGRAPHIC datatype
LONGBLOB datatype
LONGTEXT datatype
LONG_VARCHAR
LONG_VARCHAR function (DB2)
LONG_VARGRAPHIC
LONG_VARGRAPHIC function (DB2)
lower
LOWER function
LPAD
LPAD function
LSEG
LSEG datatype
LSEG function (PostgreSQL)
LTrim
LTRIM function
MACADDR datatype
MAKE_REF
MAKE_REF function (Oracle)
MAKE_SET
MAKE_SET function (MySQL)
MANAGE TABLESPACE
MANAGED BY
MANAGED STANDBY DATABASE

Managing
MASKLEN
MASKLEN function (PostgreSQL)
MATCH keyword
Materialized view
MAX      2nd
max function      2nd
MAXDATAFILES
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAX_ROWS
MD5
MD5 function (MySQL)
Median
MEDIAN function (Oracle)
MEDIUMBLOB datatype
MEDIUMINT datatype
MEDIUMTEXT datatype
Member
MERGE PARTITION
MERGE statement
Metadata
method
METHODS
MICROSECOND
MICROSECOND function (DB2)
Microsoft SQL Server
Microsoft SQL Server keywords
MID
MID function (MySQL)
MIDNIGHT_SECONDS
MIDNIGHT_SECONDS function (DB2)
MIN      2nd
min function      2nd
MINIMIZE RECORDS_PER_BLOCK
MINPCTUSED
Minute
Minute function
MIN_ROWS
MOD
MOD function
MODE DB2OPTIONS
MODE DB2SQL
MODEL clause
MODIFIES SQL DATA
Modify
MODIFY DEFAULT ATTRIBUTES
MODIFY E
MODIFY ELEMENT TYPE
MODIFY FILE
MODIFY FILEGROUP
MODIFY LIMIT
MODIFY NAME
MODIFY PARTITION
MODIFY SUBPARTITION
modula (%) arithmetic operator (SQLServer)
MONEY datatype
Monitoring
MONITORING USAGE
Month
Month function
MONTHNAME
MonthName function
MONTHS_BETWEEN
MONTHS_BETWEEN function (Oracle)
mount
MOVE E
MOVE PARTITION
multiplication (*) arithmetic operator
MULTIPLY_ALT
MULTIPLY_ALT function (DB2)
MULTI_USER
MUT_EXCL_ROLES
MUT_EXCL_ROLES function
MySQL
MySQL supported      [See MySQL functions]
NAME
naming conventions
NANVL
NANVL function (Oracle)
NATIONAL CHAR datatype
NATIONAL CHAR VARYING datatype
NATIONAL CHARACTER datatype
NATIONAL CHARACTER SET
NATIONAL CHARACTER VARYING datatype
NATIONAL TEXT datatype
Natural
NATURAL [INNER | {LEFT | RIGHT}[ OUTER] ] JOIN
nchar
NCHAR datatype
NCHAR function
NCHAR VARYING datatype
NCHAR( ) datatype
NCLOB datatype
Nested
nested and operator precedence
nested parentheses and operator precedence
nested table
nested tables
nested triggers
Netmask
NETMASK function (PostgreSQL)
Network
NETWORK function (PostgreSQL)
new features
NEWID( )
NewId( ) function
NEW_TIME
NEW_TIME function (Oracle)
NEXT_DAY
NEXT_DAY function (Oracle)
Nickname
NLINE LENGTH
NLSSORT
NLSSORT function (Oracle)
NLS_CHARSET_DECL_LEN
NLS_CHARSET_DECL_LEN function (Oracle)
NLS_CHARSET_ID
NLS_CHARSET_ID function (Oracle)
NLS_CHARSET_NAME
NLS_CHARSET_NAME function (Oracle)
NLS_INITCAP
NLS_INITCAP function (Oracle)
NLS_LOWER
NLS_LOWER function (Oracle)
NLS_UPPER
NLS_UPPER function (Oracle)
NO ACTION keyword
NO LINK CONTROL
NO SQL
NOCOPY
nondeterministic
nondeterministic functions
NOSORT
not equal to (!=) operator      2nd 3rd
NOT FOR REPLICATION
not greater than (!>) operator
not less than (!<) operator
NOT LOGGED INITIALLY
NOT operator
NOW( )
NOW( ) function (MySQL)
NPOINTS
NPOINTS function (PostgreSQL)
NTEXT datatype
NTILE
NTILE function (Oracle)
NULL values

1 2 3 4 5 6 7 8

О проекте