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

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

DISTINCT
division (/) arithmetic operator
double
double datatype
DOUBLE function (DB2)
Double parameter object type (ADO.NET)
DOUBLE PRECISION datatype
double-pound symbol (##)
Drop
DROP ANY TABLE
DROP COLUMN
DROP CONSTRAINT
DROP DATABASE statement, quick reference
DROP DOMAIN statement, quick reference
DROP E
DROP FUNCTION statement, quick reference
DROP INDEX statement, quick reference
Drop method
DROP METHOD statement, quick reference
DROP PARTITION
DROP PUBLIC DATABASE LINK
DROP ROLE statement, quick reference
DROP statements
DROP TABLE statement, quick reference
DROP TRIGGER statement, quick reference
DROP TYPE statement, quick reference
DROP USER
DROP VIEW statement, quick reference
DROP_EXISTING
Dump
DUMP function (Oracle)
Dynamic
DYNAMIC RESULT SETS
else
ELT
ELT function (MySQL)
EMPTY_BLOB( )
EMPTY_BLOB( ) function (Oracle)
EMPTY_CLOB( )
EMPTY_CLOB( ) function (Oracle)
ENABLE
ENABLE BLOCK CHANGE TRACKING
ENABLE KEYS
ENABLE ROW MOVEMENT
ENABLE TABLE LOCK
ENABLE THREAD
ENABLE TRIGGER
Encode
ENCODE function (MySQL)
encrypt
ENCRYPT function
Encryption
ending
enhanced
ENUM datatype
equal to (=) comparison operator
Error handling
EVENT MONITOR
EVENT_MON_STATE
EVENT_MON_STATE function (DB2)
examples
EXCEPT set operator
EXCEPTIONS INTO
EXCHANGE PARTITION
EXECUTE ANY TYPE
EXECUTE ON
EXECUTE statement versus CALL statement
executing
executing statements
EXEMPT ACCESS POLICY
EXISTS operator      2nd
EXISTSNODE
EXISTSNODE function (Oracle)
EXP
Exp function
Explicit
explicit transactions
EXPORT_SET
EXPORT_SET function (MySQL)
Expressions
EXTEND USING
EXTENT MANAGEMENT      2nd
EXTENTSIZE
EXTERNAL NAME
external scalar user-defined functions
external stored procedure
external table user-defined functions
extract
extract function
EXTRACTVALUE
EXTRACTVALUE function (Oracle)
FAST_FORWARD
FENCED
FETCH statement
Field
FIELD function (MySQL)
FILE LINK CONTROL
FILEGROUPPROPERTY
FILEGROUPPROPERTY function
FILEGROUP_ID
FILEGROUP_ID function
FILEGROUP_NAME
FILEGROUP_NAME function
FILEPROPERTY
FILEPROPERTY function
FILE_ID
FILE_ID function
FILE_NAME
FILE_NAME function
FILLFACTOR
filtering checks
FINAL CALL
FIND_IN_SET
FIND_IN_SET function (MySQL)
first
FIRST function (Oracle)
FIRST_VALUE
FIRST_VALUE function (Oracle)
FLASHBACK
FLASHBACK ANY TABLE
flashback queries
flashback_query_clause
float
float datatype
float function
FLOAT4
FLOAT4 datatype
FLOAT4 function (PostgreSQL)
FLOAT8 datatype
FLOOR
Floor function
for
FOR LOAD
FOR REPLICATION
FOR UPDATE
FOR UPDATE OF
force
FORCE ANY TRANSACTION
FORCE LOGGING      2nd
FORCE TRANSACTION
Foreign key
foreign key constraint
FOREIGN KEY constraints
FOREIGN KEY keyword
FORMAT
FORMAT function (MySQL)
FORMATMESSAGE
FORMATMESSAGE function
FORWARD_ONLY
freeing resources

FREETEXT
FREETEXT function (SQL Server)
FREETEXTTABLE
FREETEXTTABLE function
from
FROM clause
FROM E USE INDEX
FROM_DAYS
FROM_DAYS function (MySQL)
FROM_TZ
FROM_TZ function (Oracle)
FROM_UNIXTIME      2nd
FROM_UNIXTIME function (MySQL)      2nd
FULL [OUTER] JOIN
FULLTEXTCATALOGPROPERTY
FULLTEXTCATALOGPROPERTY function
FULLTEXTSERVICEPROPERTY
FULLTEXTSERVICEPROPERTY function
Function
Function mapping
Functions
GENERATED
GENERATE_UNIQUE( )
GENERATE_UNIQUE( ) function (DB2)
get
GET DIAGNOSTIC statement
Get methods (ADO.NET DataReader)
Get methods (JDBC ResultSet)
GETANSINULL
GETANSINULL function
GETDATE( )
GETDATE( ) function (SQL Server)
GETHINT
GETHINT function (DB2)
GETUTCDATE( )
getutcdate( ) function
GET_LOCK
GET_LOCK function (MySQL)
global
GLOBAL QUERY REWRITE
GLOBAL TEMPORARY
global temporary table
GRANT ANY OBJECT PRIVILEGE
GRANT ANY PRIVILEGE
GRANT ANY ROLE
GRANT statement
Graphic
GRAPHIC datatype
GRAPHIC function (DB2)
greater than (>) operator
greater than or equal to (>=) operator
GREATEST
GREATEST function
Group
GROUP BY
GROUP BY clause      2nd
group clause
GROUPING
Grouping function
GROUPING_ID
GROUPING_ID function (Oracle)
GROUP_ID( )
GROUP_ID( ) function (Oracle)
guard
HASHEDVALUE
HASHEDVALUE function (DB2)
HAVING
HAVING clause
Height
HEIGHT function (PostgreSQL)
HEX
Hex function
HEXTOINT
HEXTOINT function
HEXTORAW
HEXTORAW function (Oracle)
HIGH_PRIORITY
Host
HOST function (PostgreSQL)
HOST_ID( )
HOST_ID( ) function (SQL Server)
HOST_NAME( )
HOST_NAME( ) function (SQL Server)
Hour
Hour function
IDENTIFIED BY
identifier rules
identifier size
Identifiers
Identity
Identity function
IDENTITY_VAL_LOCAL( )
IDENTITY_VAL_LOCAL( ) function (DB2)
IDENT_CURRENT
IDENT_CURRENT function
IDENT_INCR
IDENT_INCR function
IDENT_SEED
IDENT_SEED function
if
IF function (MySQL)
IF NOT EXISTS
IFNULL
IFNULL function (MySQL)
IGNORE INDEX
IGNORE SELECT_statement
IGNORE_DUP_KEY
IMAGE datatype
IMPLICIT
implicit transactions
IN
in FROM clause
IN operator      2nd
INCLUDE
INCLUDING TABLE DATA
INDEX
INDEX DIRECTORY
index-organized table (IOT)
Indexes
INDEXPROPERTY
INDEXPROPERTY function
IndexType
INDEXTYPE IS
INDEX_COL
INDEX_COL function (SQL Server)
INET datatype
INHERIT SPECIAL REGISTERS
INIT.ORA file
initcap
INITCAP function
INITCAP function (PostgreSQL)
INLINE LENGTH
inline_ref_constraint      2nd
inner join
INSENSITIVE
Insert
INSERT ANY TABLE
INSERT function
INSERT statement
INSERT_METHOD
InStr
InStr function
int datatype
Int parameter object type (ADO.NET)
INT2 datatype
INT4 datatype
INT8 datatype
INTEGER
integer datatype
INTEGER function

1 2 3 4 5 6 7 8

О проекте