SQL in a Nutshell, 2nd Edition [Electronic resources] نسخه متنی

ADD

ALL

ALTER

AND

AS

ASC

BY

CHECK

COLUMN

CREATE

DATE

DEFAULT

DELETE

DESC

DROP

FOR

FROM

IN

INTO

IS

LIKE

NOT

NULL

ON

OR

ORDER

REVOKE

SELECT

SET

TABLE

THEN

TO

UNIQUE

UPDATE

WITH

ABSOLUTE

ACTION

ADD

ADMIN

AFTER

AGGREGATE

ALIAS

ALL

ALLOCATE

ALTER

AND

ANY

ARE

ARRAY

AS

ASC

ASSERTION

ASSERTION

AT

ATOMIC

AUTHORIZATION

BEFORE

BEGIN

BIGINT

BINARY

BIT

BLOB

BOOLEAN

BOTH

BREADTH

BY

CALL

CASCADE

CASCADED

CASE

CAST

CATALOG

CHAR

CHARACTER

CHECK

CLASS

CLOB

CLOSE

COLLATE

COLLATION

COLLECT

COLUMN

COMMIT

COMPLETION

CONDITION

CONNECT

CONNECTION

CONSTRAINT

CONSTRAINTS

CONSTRUCTOR

CONTAINS

CONTINUE

CORRESPONDING

CREATE

CROSS

CUBE

CURRENT

CURRENT_DATE

CURRENT_PATH

CURRENT_ROLE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

CYCLE

DATA

DATALINK

DATE

DAY

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DEFERRABLE

DELETE

DEPTH

DEREF

DESC

DESCRIPTOR

DESTRUCTOR

DIAGNOSTICS

DICTIONARY

DISCONNECT

DO

DOMAIN

DOUBLE

DROP

ELEMENT

END-EXEC

EQUALS

ESCAPE

EXCEPT

EXCEPTION

EXECUTE

EXIT

EXPAND

EXPANDING

FALSE

FIRST

FLOAT

FOR

FOREIGN

FREE

FROM

FUNCTION

FUSION

GENERAL

GET

GLOBAL

GOTO

GROUP

GROUPING

HANDLER

HASH

HOUR

IDENTITY

IF

IGNORE

IMMEDIATE

IN

INDICATOR

INITIALIZE

INITIALLY

INNER

INOUT

INPUT

INSERT

INT

INTEGER

INTERSECT

INTERSECTION

INTERVAL

INTO

IS

ISOLATION

ITERATE

JOIN

KEY

LANGUAGE

LARGE

LAST

LATERAL

LEADING

LEAVE

LEFT

LESS

LEVEL

LIKE

LIMIT

LOCAL

LOCALTIME

LOCALTIMESTAMP

LOCATOR

LOOP

MATCH

MEMBER

MEETS

MERGE

MINUTE

MODIFIES

MODIFY

MODULE

MONTH

MULTISET

NAMES

NATIONAL

NATURAL

NCHAR

NCLOB

NEW

NEXT

NO

NONE

NORMALIZE

NOT

NULL

NUMERIC

OBJECT

OF

OFF

OLD

ON

ONLY

OPEN

OPERATION

OPTION

OR

ORDER

ORDINALITY

OUT

OUTER

OUTPUT

PAD

PARAMETER

PARAMETERS

PARTIAL

PATH

PERIOD

POSTFIX

PRECEDES

PRECISION

PREFIX

PREORDER

PREPARE

PRESERVE

PRIMARY

PRIOR

PRIVILEGES

PROCEDURE

PUBLIC

READ

READS

REAL

RECURSIVE

REDO

REF

REFERENCES

REFERENCING

RELATIVE

REPEAT

RESIGNAL

RESTRICT

RESULT

RETURN

RETURNS

REVOKE

RIGHT

ROLE

ROLLBACK

ROLLUP

ROUTINE

ROW

ROWS

SAVEPOINT

SCHEMA

SCROLL

SEARCH

SECOND

SECTION

SELECT

SEQUENCE

SESSION

SESSION_USER

SET

SETS

SIGNAL

SIZE

SMALLINT

SPECIFIC

SPECIFICTYPE

SQL

SQLEXCEPTION

SQLSTATE

SQLWARNING

START

STATE

STATIC

STRUCTURE

SUBMULTISET

SUCCEEDS

SUM

SYSTEM_USER

TABLE

TABLESAMPLE

TEMPORARY

TERMINATE

THAN

THEN

TIME

TIMESTAMP

TIMEZONE_HOUR

TIMEZONE_MINUTE

TO

TRAILING

TRANSACTION

TRANSLATION

TREAT

TRIGGER

TRUE

UESCAPE

UNDER

UNDO

UNION

UNIQUE

UNKNOWN

UNTIL

UPDATE

USAGE

USER

USING

VALUE

VALUES

VARCHAR

VARIABLE

VARYING

VIEW

WHEN

WHENEVER

WHERE

WHILE

WITH

WRITE

YEAR

ZONE

ACQUIRE

ADD

AFTER

ALIAS

ALL

ALLOCATE

ALLOW

ALTER

AND

ANY

AS

ASC

ASUTIME

AUDIT

AUTHORIZATION

AUXILIARY

AVG

BEFORE

BEGIN

BETWEEN

BINARY

BUFFERPOOL

BY

CALL

CALLED

CAPTURE

CASCADED

CASE

CAST

CCSID

CHAR

CHARACTER

CHECK

CLOSE

CLUSTER

COLLECTION

COLLID

COLUMN

COMMENT

COMMIT

CONCAT

CONDITION

CONNECT

CONNECTION

CONSTRAINT

CONTAINS

CONTINUE

COUNT

COUNT_BIG

CREATE

CROSS

CURRENT

CURRENT_DATE

CURRENT_LC_PATH

CURRENT_PATH

CURRENT_SERVER

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TIMEZONE

CURRENT_USER

CURSOR

DATA

DATABASE

DATE

DAY

DAYS

DB2GENERAL

DB2SQL

DBA

DBINFO

DBSPACE

DECLARE

DEFAULT

DELETE

DESC

DESCRIPTOR

DETERMINISTIC

DISALLOW

DISCONNECT

DISTINCT

DO

DOUBLE

DROP

DSSIZE

DYNAMIC

EDITPROC

ELSE

ELSEIF

END

END-EXEC

ERASE

ESCAPE

EXCEPT

EXCEPTION

EXCLUSIVE

EXECUTE

EXISTS

EXIT

EXPLAIN

EXTERNAL

FENCED

FETCH

FIELDPROC

FILE

FINAL

FOR

FOREIGN

FREE

FROM

FULL

FUNCTION

GENERAL

GENERATED

GO

GOTO

GRANT

GRAPHIC

GROUP

HANDLER

HAVING

HOUR

HOURS

IDENTIFIED

IF

IMMEDIATE

IN

INDEX

INDICATOR

INNER

INOUT

INSENSITIVE

INSERT

INTEGRITY

INTERSECT

INTO

IS

ISOBID

ISOLATION

JAVA

JOIN

KEY

LABEL

LANGUAGE

LC_CTYPE

LEAVE

LEFT

LIKE

LINKTYPE

LOCAL

LOCALE

LOCATOR

LOCATORS

LOCK

LOCKSIZE

LONG

LOOP

MAX

MICROSECOND

MICROSECONDS

MIN

MINUTE

MINUTES

MODE

MODIFIES

MONTH

MONTHS

NAME

NAMED

NHEADER

NO

NODENAME

NODENUMBER

NOT

NULL

NULLS

NUMPARTS

OBID

OF

ON

ONLY

OPEN

OPTIMIZATION

OPTIMIZE

OPTION

OR

ORDER

OUT

OUTER

PACKAGE

PAGE

PAGES

PARAMETER

PART

PARTITION

PATH

PCTFREE

PCTINDEX

PIECESIZE

PLAN

POSITION

PRECISION

PREPARE

PRIMARY

PRIQTY

PRIVATE

PRIVILEGES

PROCEDURE

PROGRAM

PSID

PUBLIC

QUERYNO

READ

READS

RECOVERY

REFERENCES

RELEASE

RENAME

REPEAT

RESET

RESOURCE

RESTRICT

RESULT

RETURN

RETURNS

REVOKE

RIGHT

ROLLBACK

ROW

ROWS

RRN

RUN

SCHEDULE

SCHEMA

SCRATCHPAD

SECOND

SECONDS

SECQTY

SECURITY

SELECT

SET

SHARE

SIMPLE

SOME

SOURCE

SPECIFIC

SQL

STANDARD

STATIC

STATISTICS

STAY

STOGROUP

STORES

STORPOOL

STYLE

SUBPAGES

SUBSTRING

SUM

SYNONYM

TABLE

TABLESPACE

THEN

TO

TRANSACTION

TRIGGER

TRIM

TYPE

UNDO

UNION

UNIQUE

UNTIL

UPDATE

USAGE

USER

USING

VALIDPROC

VALUES

VARIABLE

VARIANT

VCAT

VIEW

VOLUMES

WHEN

WHERE

WHILE

WITH

WLM

WORK

WRITE

YEAR

YEARS

ACTION

ADD

AFTER

AGGREGATE

ALL

ALTER

AND

AS

ASC

AUTO_INCREMENT

AVG

AVG_ROW_LENGTH

BETWEEN

BIGINT

BINARY

BIT

BLOB

BOOL

BOTH

BY

CASCADE

CASE

CHANGE

CHAR

CHARACTER

CHECK

CHECKSUM

COLUMN

COLUMNS

COMMENT

CONSTRAINT

CREATE

CROSS

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

DATA

DATABASE

DATABASES

DATE

DATETIME

DAY

DAY_HOUR

DAY_MINUTE

DAY_SECOND

DAYOFMONTH

DAYOFWEEK

DAYOFYEAR

DEC

DECIMAL

DEFAULT

DELAY_KEY_WRITE

DELAYED

DELETE

DESC

DESCRIBE

DISTINCT

DISTINCTROW

DOUBLE

DROP

ELSE

ENCLOSED

END

ENUM

ESCAPE

ESCAPED

EXISTS

EXPLAIN

FIELDS

FILE

FIRST

FLOAT

FLOAT4

FLOAT8

FLUSH

FOR

FOREIGN

FROM

FULL

FUNCTION

GLOBAL

GRANT

GRANTS

GROUP

HAVING

HEAP

HIGH_PRIORITY

HOSTS

HOUR

HOUR_MINUTE

HOUR_SECOND

IDENTIFIED

IF

IGNORE

IN

INDEX

INFILE

INNER

INSERT

INSERT_ID

INT

INT1

INT2

INT3

INT4

INT8

INTEGER

INTERVAL

INTO

IS

ISAM

JOIN

KEY

KEYS

KILL

LAST_INSERT_ID

LEADING

LEFT

LENGTH

LIKE

LIMIT

LINES

LOAD

LOCAL

LOCK

LOGS

LONG

LONGBLOB

LONGTEXT

LOW_PRIORITY

MATCH

MAX

MAX_ROWS

MEDIUMBLOB

MEDIUMINT

MEDIUMTEXT

MIDDLEINT

MIN_ROWS

MINUTE

MINUTE_SECOND

MODIFY

MONTH

MONTHNAME

MYISAM

NATURAL

NO

NOT

NULL

NUMERIC

ON

OPTIMIZE

OPTION

OPTIONALLY

OR

ORDER

OUTER

OUTFILE

PACK_KEYS

PARTIAL

PASSWORD

PRECISION

PRIMARY

PRIVILEGES

PROCEDURE

PROCESS

PROCESSLIST

READ

REAL

REFERENCES

REGEXP

RELOAD

RENAME

REPLACE

RESTRICT

RETURNS

REVOKE

RLIKE

ROW

ROWS

SECOND

SELECT

SET

SHOW

SHUTDOWN

SMALLINT

SONAME

SQL_BIG_RESULT

SQL_BIG_SELECTS

SQL_BIG_TABLES

SQL_LOG_OFF

SQL_LOG_UPDATE

SQL_LOW_PRIORITY_UPDATES

SQL_SELECT_LIMIT

SQL_SMALL_RESULT

SQL_WARNINGS

STARTING

STATUS

STRAIGHT_JOIN

STRING

TABLE

TABLES

TEMPORARY

TERMINATED

TEXT

THEN

TIME

TIMESTAMP

TINYBLOB

TINYINT

TINYTEXT

TO

TRAILING

TYPE

UNIQUE

UNLOCK

UNSIGNED

UPDATE

USAGE

USE

USING

VALUES

VARBINARY

VARCHAR

VARIABLES

VARYING

WHEN

WITH

WRITE

ZEROFILL

ACCESS

ADD

ALL

ALTER

AND

ANY

AS

ASC

AUDIT

BETWEEN

BY

CHAR

CHECK

CLUSTER

COLUMN

COMMENT

COMPRESS

CONNECT

CREATE

CURRENT

DATE

DECIMAL

DEFAULT

DELETE

DESC

DISTINCT

DROP

ELSE

EXCLUSIVE

EXISTS

FILE

FLOAT

FOR

FROM

GRANT

GROUP

HAVING

IDENTIFIED

IMMEDIATE

IN

INCREMENT

INDEX

INITIAL

INSERT

INTEGER

INTERSECT

INTO

IS

LEVEL

LIKE

LOCK

LONG

MAXEXTENTS

MINUS

MODE

MODIFY

MSLABEL

NOAUDIT

NOCOMPRESS

NOT

NOWAIT

NULL

NUMBER

OF

OFFLINE

ON

ONLINE

OPTION

OR

ORDER

PCTFREE

PRIOR

PRIVILEGES

PUBLIC

RAW

RENAME

RESOURCE

REVOKE

ROW

ROWID

ROWNUM

ROWS

SELECT

SESSION

SET

SHARE

SIZE

SMALLINT

START

SUCCESSFUL

SYNONYM

SYSDATE

TABLE

THEN

TO

TRIGGER

UID

UNION

UNIQUE

UPDATE

USER

VALIDATE

VALUES

VARCHAR

VARCHAR2

VIEW

WHENEVER

WHERE

WITH

ABORT

ADD

ALL

ALLOCATE

ALTER

ANALYZE

AND

ANY

ARE

AS

ASC

ASSERTION

AT

AUTHORIZATION

AVG

BEGIN

BETWEEN

BINARY

BIT

BIT_LENGTH

BOTH

BY

CASCADE

CASCADED

CASE

CAST

CATALOG

CHAR

CHAR_LENGTH

CHARACTER

CHARACTER_LENGTH

CHECK

CLOSE

CLUSTER

COALESCE

COLLATE

COLLATION

COLUMN

COMMIT

CONNECT

CONNECTION

CONSTRAINT

CONTINUE

CONVERT

COPY

CORRESPONDING

COUNT

CREATE

CROSS

CURRENT

CURRENT_DATE

CURRENT_SESSION

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

DATE

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DELETE

DESC

DESCRIBE

DESCRIPTOR

DIAGNOSTICS

DISCONNECT

DISTINCT

DO

DOMAIN

DROP

ELSE

END

ESCAPE

EXCEPT

EXCEPTION

EXEC

EXECUTE

EXISTS

EXISTS

EXPLAIN

EXTEND

EXTERNAL

EXTRACT

FALSE

FETCH

FIRST

FLOAT

FOR

FOREIGN

FOUND

FROM

FULL

FULL

GET

GLOBAL

GO

GOTO

GRANT

GROUP

HAVING

IDENTITY

IN

INDICATOR

INNER

INPUT

INSERT

INTERSECT

INTERVAL

INTO

IS

JOIN

LAST

LEADING

LEFT

LIKE

LISTEN

LOAD

LOCAL

LOCK

LOWER

MAX

MIN

MODULE

MOVE

NAMES

NATIONAL

NATURAL

NCHAR

NEW

NO

NONE

NOT

NOTIFY

NULL

NULLIF

NUMERIC

OCTET_LENGTH

OFFSET

ON

OPEN

OR

ORDER

OUTER

OUTPUT

OVERLAPS

PARTIAL

POSITION

PRECISION

PREPARE

PRESERVE

PRIMARY

PRIVILEGES

PROCEDURE

PUBLIC

REFERENCES

RESET

REVOKE

RIGHT

ROLLBACK

ROWS

SCHEMA

SECTION

SELECT

SESSION

SESSION_USER

SET

SETOF

SHOW

SIZE

SOME

SQL

SQLCODE

SQLERROR

SQLSTATE

SUBSTRING

SUM

SYSTEM_USER

TABLE

TEMPORARY

THEN

TO

TO

TRAILING

TRANSACTION

TRANSLATE

TRANSLATION

TRIM

TRUE

UNION

UNIQUE

UNIQUE

UNKNOWN

UNLISTEN

UNTIL

UPDATE

UPPER

USAGE

USER

USING

VACUUM

VALUE

VALUES

VARCHAR

VARYING

VERBOSE

VIEW

WHEN

WHENEVER

WHERE

WITH

WORK

WRITE

ADD

ALL

ALTER

AND

ANY

AS

ASC

AUTHORIZATION

BACKUP

BEGIN

BETWEEN

BREAK

BROWSE

BULK

BY

CASCADE

CASE

CHECK

CHECKPOINT

CLOSE

CLUSTERED

COALESCE

COLLATE

COLUMN

COMMIT

COMPUTE

CONSTRAINT

CONTAINS

CONTAINSTABLE

CONTINUE

CONVERT

CREATE

CROSS

CURRENT

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

DATABASE

DBCC

DEALLOCATE

DECLARE

DEFAULT

DELETE

DENY

DESC

DISK

DISTINCT

DISTRIBUTED

DOUBLE

DROP

DUMMY

DUMP

ELSE

END

ERRLVL

EXCEPT

EXEC

EXECUTE

EXISTS

EXIT

FETCH

FILE

FILLFACTOR

FOR

FOREIGN

FREETEXT

FREETEXTTABLE