[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]
OBJECT_ID function (SQL Server)
OBJECT_NAME function (SQL Server)
OBJECTPROPERTY function
SQL Server
objects
OCT function (MySQL)
OCTET_LENGTH function
OdbcConnection
connection string attributes for
OID datatype
platform comparison
PostgreSQL
OLAP functions
OleDbConnection
connection string attributes for
OPEN function
SQL Server
OPEN statement
DB2
keywords
MySQL
Oracle
platform support for
PostgreSQL
programming tips
quick reference
rules
SQL Server
SQL2003 syntax
OPENDATASOURCE function
SQL Server
OPENQUERY function
SQL Server
OPENROWSET function
SQL Server
operator precedence
operators 2nd
string
OPERATORS, quick reference
OR operator
ORA_HASH function (Oracle)
Oracle
allowed characters in identifiers
ALTER INDEX syntax
ALTER TABLE statement
ALTER TABLE syntax
altering a partitioned table
basics
beginning identifier character
CALL statement
column_constraint_clause
COMMIT statement
compressed tables
CONNECT statement
connecting using JDBC
CREATE INDEX syntax
CREATE/ALTER DATABASE statements
ACTIVATE
ADD LOGFILE
ADD SUPPLEMENTAL LOG DATA
ALLOW
ARCHIVELOG 2nd
AUTOMATIC
BACKUP CONTROLFILE TO
BEGIN BACKUP
BIGFILE
CANCEL
CHARACTER SET
CLEAR LOGFILE
CONTINUE
CONTROLFILE REUSE
CREATE DATAFILE
CREATE STANDBY CONTROLFILE AS
DATABASE
DATAFILE 2nd
DEFAULT TABLESPACE
DEFAULT TEMPORARY TABLESPACE
ENABLE BLOCK CHANGE TRACKING
ENABLE THREAD
EXTENT MANAGEMENT 2nd
FLASHBACK
FOR
FORCE LOGGING 2nd
GUARD
LOGFILE 2nd
MANAGED STANDBY DATABASE
MAXDATAFILES
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MOUNT
NATIONAL CHARACTER SET
OPEN
PARALLEL
RECOVER
REGISTER
RENAME FILE
RENAME GLOBAL_NAME TO
SET DEFAULT TABLESPACE
SET STANDBY
SET TIME_ZONE
SMALLFILE
STANDBY
START LOGICAL STANDBY APPLY
SYSAUX DATAFILE
TABLESPACE
TEST
UNDO TABLESPACE
UNTIL
USER SYS IDENTIFIED BY
USER SYSTEM IDENTIFIED BY
CREATE/ALTER FUNCTION/PROCEDURE statements
AGGREGATE
ALTER
AS
AUTHID
code_block
COMPILE
CREATE
IN
IS
LANGUAGE
NOCOPY
OUT
PARALLEL_ENABLE
PIPELINED
CREATE/ALTER INDEX statements
ALLOCATE EXTENT
alter_index_partitioning_clause
ASC
BITMAP
CLUSTER
COALESCE
COMPRESS
COMPUTE
DEALLOCATE UNUSED
DESC
ENABLE
GLOBAL
INDEXTYPE IS
LOCAL
LOGGING
MONITORING USAGE
NOSORT
PARALLEL
PARAMETERS
physical_attributes_clause
rebuild_clause
RENAME TO
REVERSE
SHRINK SPACE
TABLESPACE DEFAULT
UNUSABLE
UPDATE BLOCK REFERENCES
CREATE/ALTER METHOD statements
CREATE/ALTER ROLE statements
CREATE/ALTER SCHEMA statements
CREATE/ALTER TABLE statements
ADD É
ADD PARTITION
ALLOCATE EXTENT
AS object_type
AS subquery
CACHE
CLUSTER
COALESCE
COALESCE PARTITION
COMPRESS
constraint_state clause
DEALLOCATE UNUSED
DROP É
DROP PARTITION
ENABLE ROW MOVEMENT
ENABLE TABLE LOCK
EXCHANGE PARTITION
foreign key constraint
GROUP
inline_ref_constraint 2nd
LOGGING
MERGE PARTITION
MINIMIZE RECORDS_PER_BLOCK
MODIFY DEFAULT ATTRIBUTES
MODIFY É
MODIFY PARTITION
MODIFY SUBPARTITION
MONITORING
MOVE É
MOVE PARTITION
OBJECT IDENTIFIER IS
OF XMLTYPE
OIDINDEX
ON COMMIT
ORGANIZATION EXTERNAL
ORGANIZATION HEAP
ORGANIZATION INDEX
PARALLEL
parameters
partition_clause
partition_level_subpartition_clause
partition_storage_clause
physical_attributes_clause
PROJECT COLUMN
RENAME É
RENAME PARTITION
ROWDEPENDENCIES
SET SUBPARTITION TEMPLATE
SET UNUSED É
SHRINK SPACE
SPLIT PARTITION
storage_clause 2nd
SUBSTITUTABLE AT ALL LEVELS
table_constraint_clause
table_partition_description clause
table_ref_constraint 2nd
TABLESPACE
TRUNCATE PARTITION
update_index_clause
UPGRADE INCLUDING DATA
xml_schema_spec
XMLTYPE
CREATE/ALTER TRIGGER statements
CREATE/ALTER TYPE statements
ADD
AS OBJECT
AS TABLE OF
AS VARRAY
AUTHID
BODY
CASCADE
COMPILE
compiler_directives 2nd
CONVERT TO SUBSTITUTABLE
datatype
DEBUG
DROP
EXCEPTIONS INTO
EXTERNAL NAME
FORCE
INCLUDING TABLE DATA
INVALIDATE
MEMBER
MODIFY
MODIFY ELEMENT TYPE
MODIFY LIMIT
OID
OR REPLACE
OVERRIDING
REPLACE AS OBJECT
REUSE SETTINGS
SPECIFICATION
STATIC
UNDER
CREATE/ALTER VIEW statements
datatypes
DECLARE CURSOR command
default database user accounts
DELETE statement
DISCONNECT statement
DROP statements
[PUBLIC] DATABASE LINK
[PUBLIC] SYNONYM
CLUSTER
CONTEXT
DATABASE
DIMENSION
DIRECTORY
FUNCTION
INDEX
INDEXTYPE
JAVA
LIBRARY
MATERIALIZED VIEW
OPERATOR
OUTLINE
PACKAGE
PROCEDURE
PROFILE
ROLE
ROLLBACK SEGMENT
SEQUENCE
SNAPSHOT
TABLE
TABLESPACE
TRIGGER
TYPE
USER
VIEW
EXCEPT set operator
FETCH statement
functions
ACOS
ADD_MONTHS
ASCII
ASCIISTR
ASIN
ATAN
ATAN2
BFILENAME
BIN_TO_NUM
BITAND
CARDINALITY
CHARTOROWID
CHR
COALESCE
COLLECT
COMPOSE
CONCAT
CONVERT
CORR_K
COS
COSH
CV
DBTIMEZONE
DECODE
DECOMPOSE
DEPTH
DEREF
DUMP
EMPTY_BLOB( )
EMPTY_CLOB( )
EXISTSNODE
EXTRACT
EXTRACTVALUE
FIRST
FIRST_VALUE
FROM_TZ
GREATEST
GROUP_ID( )
GROUPING
GROUPING_ID
HEXTORAW
INITCAP
INSTR
ITERATION_NUMBER
LAG
LAST
LAST_DAY
LAST_VALUE
LEAD
LEAST
LENGTH
LENGTHB
LNNVL
LOCALTIMESTAMP
LOG
LPAD
LTRIM
MAKE_REF
MEDIAN
MONTHS_BETWEEN
NANVL
NCHAR
NEW_TIME
NEXT_DAY
NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID
NLS_CHARSET_NAME
NLS_INITCAP
NLS_LOWER
NLS_UPPER
NLSSORT
NTILE
NULLIF
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
ORA_HASH
PATH
POWERMULTISET
PRESENTNNV
PRESENTV
PREVIOUS
RATIO_TO_REPORT
RAWTOHEX
REF
REFTOHEX
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REMAINDER
REPLACE
ROUND
ROWIDTOCHAR
RPAD
RTRIM
SCN_TO_TIMESTAMP
SESSIONTIMEZONE
SET
SIGN
SIN
SINH
SOUNDEX
STATS_BINOMIAL_TEST
STDDEV
STDDEV_SAMP
STDEV_POP
SUBSTR
SUBSTRB
SYS_CONNECT_BY_PATH
SYS_CONTEXT
SYS_DBURIGEN
SYS_EXTRACT_UTC
SYS_GUID( )
SYS_TYPEID
SYS_XMLAGG
SYS_XMLGEN
SYSDATE
SYSTIMESTAMP
TAN
TANH
TIMESTAMP_TO_SCN
TO_BINARY_DOUBLE
TO_BINARY_FLOAT
TO_CHAR 2nd
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_LOB
TO_MULTI_BYTE
TO_NCHAR
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRANSLATE 2nd
TREAT
TRUNC 2nd
TZ_OFFSET
UID
UNISTR
UPDATEXML
USERENV
VALUE
VAR_POP
VAR_SAMP
VARIANCE
VSIZE
XMLAGG
XMLCOLATTVAL
XMLCONCAT
XMLELEMENT
XMLFOREST
XMLSEQUENCE
XMLTRANSFORM
global temporary table
GRANT statement
IDENTIFIED BY
object_privilege
ON
role
system_privilege
TO
identifier size
index-organized table (IOT)
indexes
INIT.ORA file
INSERT statement
ALL
conditional multitable
ELSE
FIRST
INSERT
subquery
TABLE
table_name
unconditional multitable
VALUES
WHEN
INTERSECT set operator
JOIN subclause
keywords
LIKE operator
local index partitioning
logfiles
MERGE statement
nested tables
object-type tables
OPEN statement
ORDER BY clause
ORGANIZATION HEAP clause
partitioned and subpartitioned tables
altering
physical_attributes_clause
primary databases
RELEASE SAVEPOINT statement
reserved identifiers
RETURN statement
REVOKE statement
ROLLBACK statement
SAVEPOINT statement
schema addressing
SELECT statement
[CROSS] JOIN
ALL
AS
DISTINCT
flashback queries
flashback_query_clause
FOR UPDATE
FROM
FULL [OUTER] JOIN
INNER JOIN
INTO
JOIN
LEFT [OUTER] JOIN
MODEL clause
NATURAL
ON
optimizer_hint
ORDER SIBLINGS BY
PARTITION
PARTITION BY
partitioned outer joins
RIGHT [OUTER] JOIN
SAMPLE
select_item
SUBPARTITION
subquery
TABLE
UNIQUE
USING
VERSIONS BETWEEN
WHERE É
WITH query_name AS
SET CONNECTION statement
SET CONSTRAINT statement
SET PATH statement
SET ROLE statement
SET SCHEMA statement
SET SESSION AUTHORIZATION statement
SET statement
SET TIME ZONE statement
SET TRANSACTION statement
special rules
standby databases
START TRANSACTION statement
storage_clause and LOBs
stored procedures
SUBQUERY substatement
syntax for object table
syntax for XMLType table
syntax to alter existing database
syntax to create new database
system privileges
{ALTER | DROP} ANY ROLE
{CREATE | ALTER | DROP | EXECUTE} ANY PROCEDURE
{CREATE | ALTER | DROP | SELECT} ANY SEQUENCE
{CREATE | ALTER | DROP} ANY CLUSTER
{CREATE | ALTER | DROP} ANY DIMENSION
{CREATE | ALTER | DROP} ANY INDEX
{CREATE | ALTER | DROP} ANY MATERIALIZED VIEW
{CREATE | ALTER | DROP} ANY SNAPSHOT
{CREATE | ALTER | DROP} ANY TYPE
{CREATE | ALTER | DROP} PROFILE
{CREATE | ALTER | DROP} ROLLBACK SEGMENT
{CREATE | ALTER | DROP} TABLESPACE
{CREATE | DROP | ALTER} ANY OUTLINE
{CREATE | DROP | EXECUTE } ANY INDEXTYPE
{CREATE | DROP | EXECUTE} ANY OPERATOR
{CREATE | DROP } ANY DIRECTORY
{CREATE | DROP} ANY CONTEXT
{CREATE | DROP} ANY LIBRARY
{CREATE | DROP} ANY SYNONYM
{CREATE | DROP} ANY TRIGGER
{CREATE | DROP} ANY VIEW
{CREATE | DROP} PUBLIC SYNONYM
ADMINISTER DATABASE TRIGGER
ALTER ANY TABLE
ALTER ANY TRIGGER
ALTER DATABASE
ALTER RESOURCE COST
ALTER SESSION
ALTER SYSTEM
ALTER USER
ANALYZE ANY
AUDIT ANY
AUDIT SYSTEM
BACKUP ANY TABLE
BECOME USER
COMMENT ANY TABLE
CREATE ANY TABLE
CREATE CLUSTER
CREATE DATABASE LINK
CREATE DIMENSION
CREATE INDEXTYPE
CREATE MATERIALIZED VIEW
CREATE OPERATOR
CREATE PROCEDURE
CREATE PUBLIC DATABASE LINK
CREATE ROLE
CREATE SEQUENCE
CREATE SESSION
CREATE SNAPSHOT
CREATE SYNONYM
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DEBUG ANY PROCEDURE
DEBUG CONNECT SESSION
DELETE ANY TABLE
DROP ANY TABLE
DROP PUBLIC DATABASE LINK
DROP USER
EXECUTE ANY TYPE
EXEMPT ACCESS POLICY
FLASHBACK ANY TABLE
FORCE ANY TRANSACTION
FORCE TRANSACTION
GLOBAL QUERY REWRITE
GRANT ANY OBJECT PRIVILEGE
GRANT ANY PRIVILEGE
GRANT ANY ROLE
INSERT ANY TABLE
LOCK ANY TABLE
MANAGE TABLESPACE
ON COMMIT REFRESH
QUERY REWRITE
RESTRICTED SESSION
RESUMABLE
SELECT ANY DICTIONARY
SELECT ANY OUTLINE
SELECT ANY TABLE
SYSDBA
SYSOPER
UNDER ANY TYPE
UNDER ANY VIEW
UNLIMITED TABLESPACE
UPDATE ANY TABLE
TRUNCATE TABLE statement
UDFs
UNION set operator
UPDATE statement
WHERE clause
window syntax
XMLType tables
Oracle keywords
ORD function (MySQL)
ORDER BY clause 2nd 3rd
DB2
keywords
MySQL
Oracle
platform support for
PostgreSQL
programming tips
quick reference
rules
SQL Server
SQL2003 syntax
ordering clause
ORGANIZATION HEAP clause (Oracle)
OVERLAY function
|
