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