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

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

NULLIF
NULLIF function
NUM datatype
NUMBER datatype
numeric
NUMERIC datatype
numeric datatype and unary operators
numeric functions
NUMERIC_ROUNDABORT
NUMSEGS
NUMTODSINTERVAL
NUMTODSINTERVAL function (Oracle)
NUMTOYMINTERVAL
NUMTOYMINTERVAL function (Oracle)
NVARACHAR( ) datatype
NVARACHAR( ) datatype (Sybase Adaptive Server)
NVARCHAR datatype
NVARCHAR2 datatype
NVARCHAR2( ) datatype
NVL
NVL function (Oracle)
NVL2
NVL2 function (Oracle)
OBJECT IDENTIFIER IS
object-type tables
OBJECTPROPERTY
OBJECTPROPERTY function
Objects
OBJECT_ID
OBJECT_ID function (SQL Server)
OBJECT_NAME
OBJECT_NAME function (SQL Server)
object_privilege
OCT
OCT function (MySQL)
OCTET_LENGTH
OCTET_LENGTH function
OdbcConnection
OF
OF XMLTYPE
offline
OID
OID datatype
OIDINDEX
OLAP functions
OLE-DB external table user-defined functions
OleDbConnection
ON
ON COMMIT
ON COMMIT REFRESH
on DB2 servers
ON DELETE keyword
ON file_definition
ON UPDATE keyword
open
Open function
Open source
Open statement
OPENDATASOURCE
OPENDATASOURCE function
Opening
OPENQUERY
OPENQUERY function
OPENROWSET
OPENROWSET function
Operator
Operator precedence
operator precedence and
Operators      2nd
operators and      2nd
OPERATORS, quick reference
OPTIMISTIC
optimizer_hint
Option
options
OR operator
OR REPLACE
Oracle
Oracle keywords
Oracle supported      [See Oracle functions]
Oracle syntax
ORA_HASH
ORA_HASH function (Oracle)
ord
ORD function (MySQL)
ORDER BY
ORDER BY clause
ORDER SIBLINGS BY
ordering clause
ORGANIZATION EXTERNAL
ORGANIZATION HEAP
ORGANIZATION HEAP clause
ORGANIZATION HEAP clause (Oracle)
ORGANIZATION INDEX
ORGANIZE BY
OUT
OUTLINE
OVERHEAD
Overlay
Overlay function
overriding
overview
Package
PACK_KEYS
PAD_INDEX
parallel
PARALLEL_ENABLE
parameter object types
parameter object types (ADO.NET)
PARAMETER STYLE
Parameters
parametrized statements
Parentheses
PARSENAME
PARSENAME function
Partition
PARTITION BY
partitioned and subpartitioned tables
partitioned outer joins
partitioned tables
partitioning clause
PARTITIONING KEY
partition_clause
partition_level_subpartition_clause
partition_storage_clause
PASSTHRU ON SERVER
Password
PASSWORD function (MySQL)
Path
PATH datatype
PATH function
PATINDEX
PATINDEX function
PCLOSE
PCLOSE function (PostgreSQL)
PCTFREE
PERCENTILE_CONT      2nd
PERCENTILE_CONT function      2nd
PERCENTILE_DISC      2nd
PERCENTILE_DISC function      2nd
PERCENT_RANK      2nd 3rd
PERCENT_RANK function      2nd 3rd
PERIOD_ADD
PERIOD_ADD function (MySQL)
PERIOD_DIFF
PERIOD_DIFF function (MySQL)
PERMISSIONS
PERMISSIONS function
physical_attributes_clause
physical_attributes_clause (Oracle)

PI( )
PI( ) function
PIPELINED
PL/pgSQL
PL/SQL
platform comparison
platform comparisons
platform differences
platform support for
Point
POINT datatype
POINT function (PostgreSQL)
Polygon
POLYGON datatype
POLYGON function (PostgreSQL)
POPEN
POPEN function (PostgreSQL)
POSITION
Position function
POSSTR
POSSTR function (DB2)
PostgreSQL
PostgreSQL keywords
pound symbol (#)
pow
Pow function
Power
Power function
POWERMULTISET
POWERMULTISET function (Oracle)
predicates
PREFETCHSIZE
prefixes
PreparedStatement set methods
PreparedStatement set methods (JDBC)
preparing and executing
PRESENTNNV
PRESENTNNV function (Oracle)
PRESENTV
PRESENTV function (Oracle)
previous
PREVIOUS function (Oracle)
primary databases
primary databases (Oracle)
Primary key
PRIMARY KEY constraints
procedural programming
Procedure
PROCEDURE, quick reference
processadmin
PROCESSADMIN (SQL Server system role)
PROC_ROLE
PROC_ROLE function
Profile
PROGRAM TYPE
programming databases
programming tips
PROJECT COLUMN
QUARTER
QUARTER function
QUERY REWRITE
Quick Reference
quoted
quoted identifier symbol
quoted identifiers
QUOTED_IDENTIFIER
RADIANS
RADIANS function
RADIUS
RADIUS function (PostgreSQL)
RAID_CHUNKS
RAID_CHUNKSIZE
RAID_TYPE
RAISE_ERROR
RAISE_ERROR function (DB2)
rand
rand function
RAND( )
RAND( ) function (MySQL)
Rank      2nd
Rank function      2nd
RANK( )
RANK( ) function
RATIO_TO_REPORT
RATIO_TO_REPORT function (Oracle)
RAW datatype
RAWTOHEX
RAWTOHEX function (Oracle)
RDBMSs (Relational Database Management System)
re-executing
ReadCommitted isolation level (Transaction object (ADO.NET))
READS SQL DATA
ReadUncommitted isolation level (Transaction object (ADO.NET))
READ_ONLY
REAL
REAL datatype
REAL function (DB2)
rebuild_clause
REC2XML
REC2XML function (DB2)
RECOMPILE
Records
Recover
Recovery
recursive triggers
RECURSIVE_TRIGGERS
Ref
REF function (Oracle)
REF IS
REFERENCES keyword
REFTOHEX
REFTOHEX function (Oracle)
REGEXP_INSTR
REGEXP_INSTR function (Oracle)
REGEXP_REPLACE
REGEXP_REPLACE function (Oracle)
REGEXP_SUBSTR
REGEXP_SUBSTR function (Oracle)
register
REGR family of functions
REGR_AVGX      2nd 3rd 4th 5th 6th 7th 8th 9th 10th
REGR_AVGX function      2nd 3rd 4th 5th 6th 7th 8th 9th 10th
REGR_AVGY      2nd 3rd 4th 5th 6th 7th 8th 9th
REGR_AVGY function      2nd 3rd 4th 5th 6th 7th 8th 9th
REGR_COUNT      2nd 3rd 4th 5th 6th 7th 8th
REGR_COUNT function      2nd 3rd 4th 5th 6th 7th 8th
REGR_INTERCEPT      2nd 3rd 4th 5th 6th 7th
REGR_INTERCEPT function      2nd 3rd 4th 5th 6th 7th
REGR_R2      2nd 3rd 4th 5th 6th
REGR_R2 function      2nd 3rd 4th 5th 6th
REGR_SLOPE      2nd 3rd 4th 5th
REGR_SLOPE function      2nd 3rd 4th 5th
REGR_SXX      2nd 3rd 4th
REGR_SXX function      2nd 3rd 4th
REGR_SXY      2nd 3rd
REGR_SXY function      2nd 3rd
REGR_SYY      2nd
REGR_SYY function      2nd
Relational Database Management Systems (RDBMSs)
relational databases, principles of
RELEASE SAVEPOINT statement
RELEASE_LOCK
RELEASE_LOCK function (MySQL)
RELTIME
RELTIME function (PostgreSQL)
Remainder
REMAINDER function (Oracle)
REMOVE FILE
REMOVE FILEGROUP
rename

1 2 3 4 5 6 7 8

О проекте