SQL in a Nutshell, 2nd Edition [Electronic resources]

Kevin E. Kline

نسخه متنی -صفحه : 78/ 73
نمايش فراداده

[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]

TABLE datatype

platform comparison

SQL Server

table subqueries

nested

table-level constraints

TABLE_NAME function (DB2)

TABLE_SCHEMA function (DB2)

tables

TABLESAMPLE clause

TAN function

DB2

MySQL

Oracle

PostgreSQL

SQL Server

TANH function

DB2

Oracle

testing expressions against range of values

TEXT datatype

MySQL

platform comparison

PostgreSQL

SQL Server

TEXT function (PostgreSQL)

TEXTPTR function (SQL Server)

TEXTVALID function (SQL Server)

TIME datatype

DB2

platform comparison

PostgreSQL

TIME function (DB2)

TIME_FORMAT function (MySQL)

TIME_TO_SEC function (MySQL)

TIMESPAN datatype

platform comparison

PostgreSQL

TIMESTAMP datatype

DB2

Oracle

platform comparison

PostgreSQL

SQL Server

Sybase adaptive server

TIMESTAMP function

DB2

PostgreSQL

TIMESTAMP_FORMAT function (DB2)

TIMESTAMP_ISO function (DB2)

TIMESTAMP_TO_SCN function (Oracle)

TIMESTAMPDIFF function (DB2)

TIMETZ datatype

platform comparison

PostgreSQL

TINYINT datatype

platform comparison

SQL Server

TO_BINARY_DOUBLE function (Oracle)

TO_BINARY_FLOAT function (Oracle)

TO_CHAR function

DB2

Oracle 2nd

PostgreSQL

TO_CLOB function (Oracle)

TO_DATE function

DB2

Oracle

PostgreSQL

TO_DAYS function (MySQL)

TO_DSINTERVAL function (Oracle)

TO_LOB function (Oracle)

TO_MULTI_BYTE function (Oracle)

TO_NCHAR function (Oracle)

TO_NCLOB function (Oracle)

TO_NUMBER function

Oracle

PostgreSQL

TO_SINGLE_BYTE function (Oracle)

TO_TIMESTAMP function

Oracle

PostgreSQL

TO_TIMESTAMP_TZ function (Oracle)

TO_UNICHAR function

TO_YMINTERVAL function (Oracle)

Transact-SQL

Transaction object

ADO.NET

JDBC

TRANSACTION_NONE isolation level (Transaction object (JDBC))

TRANSACTION_READ_COMMITTED isolation level (Transaction object (JDBC))

TRANSACTION_READ_UNCOMMITTED isolation level (Transaction object (JDBC))

TRANSACTION_REPEATABLE_READ isolation level (Transaction object (JDBC))

TRANSACTION_SERIALIZABLE isolation level (Transaction object (JDBC))

transactions

beginning 2nd

ADO.NET

JDBC

closing and making permanent

committing

ending

explicit

implicit

managing

rolling back

TRANSLATE function

DB2

Oracle 2nd

PostgreSQL

TREAT function (Oracle)

TRIM function

TRUNC function

DB2

Oracle 2nd

PostgreSQL

TRUNCATE function

DB2

MySQL

TRUNCATE TABLE statement

DB2

defacto standard syntax

keywords

MySQL

Oracle

platform support for

PostgreSQL

programming tips

rules

SQL Server

TSEQUEL function

Twelve Principles of Relational Databases

TYPE_ID function (DB2)

TYPE_NAME function (DB2)

TYPE_SCHEMA function (DB2)

TYPEPROPERTY function

SQL Server

TZ_OFFSET function (Oracle)