| [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] CALL statement DB2 keywords MySQL Oracle platform support for programming tips quick reference rules SQL Server SQL2003 syntax versus EXECUTE statement candidate key CARDINALITY function (Oracle) CASE function CAST function 2nd catalogs CBRT function (PostgreSQL) CEIL function CENTER function (PostgreSQL) Chaos isolation level (Transaction object (ADO.NET)) CHAR datatype DB2 MySQL Oracle platform comparison PostgreSQL SQL Server CHAR FOR BIT DATA datatype DB2 platform comparison CHAR function DB2 MySQL PostgreSQL SQL Server CHAR VARYING datatype DB2 Oracle platform comparison SQL Server CHAR( ) datatype SQL Server Sybase adaptive server CHAR_LENGTH function 2nd PostgreSQL CHARACTER datatype DB2 MySQL Oracle platform comparison PostgreSQL SQL Server character sets character string literals CHARACTER VARYING datatype DB2 Oracle platform comparison PostgreSQL SQL Server CHARINDEX function (SQL Server) CHARTOROWID function (Oracle) CHECK constraints CHECKSUM function SQL Server CHECKSUM_AGG function SQL Server CHR function DB2 Oracle CIDR datatype platform comparison PostgreSQL CIRCLE datatype platform comparison PostgreSQL CIRCLE function (PostgreSQL) CLOB datatype DB2 Oracle platform comparison CLOB function (DB2) CLOSE CURSOR statement DB2 keywords platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax clusters COALESCE function DB2 MySQL Oracle PostgreSQL SQL Server Codd, E. F. COL_LENGTH function (SQL Server) COL_NAME function (SQL Server) collations COLLECT function (Oracle) column-level constraints column_constraint_clause (Oracle) columns COMMIT statement DB2 keywords MySQL Oracle platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax COMMIT TO SWITCHOVER TO COMPARE function comparison operators 2nd COMPOSE function (Oracle) COMPRESS function (MySQL) compressed tables in Oracle CONCAT function DB2 Oracle CONCAT_WS function (MySQL) concatenation operator CONNECT statement DB2 keywords Oracle platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax CONNECTION_ID( ) function (MySQL) connections (database) closing opening ADO.NET JDBC connectivity, establishing constraints CHECK FOREIGN KEY PRIMARY KEY scope syntax UNIQUE CONTAINS function SQL Server CONTAINSTABLE function SQL Server CONV function (MySQL) CONVERT function Oracle SQL Server CORR function 2nd CORR_K function (Oracle) correlated subqueries Correlated subquery in WHERE/HAVING clause COS function DB2 MySQL Oracle PostgreSQL SQL Server COSH function DB2 Oracle COT function DB2 MySQL PostgreSQL 2nd SQL Server COUNT function 2nd COUNT_BIG function COVAR_POP function 2nd COVAR_SAMP function 2nd CREATE/ALTER DATABASE statements DB2 [See DB2, CREATE/ALTER DATABASE statements] MySQL Oracle [See Oracle, CREATE/ALTER DATABASE statements] platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server [See SQL Server, CREATE/ALTER DATABASE statements] CREATE/ALTER DOMAIN statements, quick reference CREATE/ALTER FUNCTION/PROCEDURE statements DB2 [See DB2, CREATE/ALTER FUNCTION/PROCEDURE statements] keywords CALL ON NULL INPUT CASCADE code_block CONTAINS SQL CREATE DETERMINISTIC DYNAMIC RESULT SETS IN LANGUAGE MODIFIES SQL DATA NAME NO SQL OUT PARAMETER STYLE READS SQL DATA RESTRICT RETURN NULL ON NULL INPUT RETURNS SPECIFIC STATIC DISPATCH MySQL Oracle [See Oracle, CREATE/ALTER FUNCTION/PROCEDURE statements] platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server [See SQL Server, CREATE/ALTER FUNCTION/PROCEDURE statements] SQL2003 syntax CREATE/ALTER INDEX statements common vendor syntax DB2 [See DB2, CREATE/ALTER INDEX statements] keywords MySQL Oracle [See Oracle, CREATE/ALTER INDEX statements] platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server [See SQL Server, CREATE/ALTER INDEX statements] CREATE/ALTER METHOD statements DB2 keywords MySQL Oracle platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server SQL2003 syntax CREATE/ALTER ROLE statements DB2 keywords MySQL Oracle platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax CREATE/ALTER SCHEMA statements DB2 keywords MySQL Oracle platform support for PostgreSQL programming tips quick reference rules SQL Server SQL2003 syntax CREATE/ALTER TABLE statements DB2 [See DB2, CREATE/ALTER TABLE statements] keywords ADD 2nd ALTER CASCADE column_name CONSTRAINT DROP COLUMN DROP CONSTRAINT GLOBAL TEMPORARY LIKE LOCAL TEMPORARY OF ON COMMIT REF IS RESTRICT MySQL [See MySQL, CREATE/ALTER TABLE statements] Oracle [See Oracle, CREATE/ALTER TABLE statements] platform support for PostgreSQL [See PostgreSQL, CREATE/ALTER TABLE statements] programming tips quick reference rules SQL Server [See SQL Server, CREATE/ALTER TABLE statements] SQL2003 syntax CREATE/ALTER TRIGGER statements DB2 keywords MySQL Oracle [See Oracle, CREATE/ALTER TRIGGER statements] platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server (SQL Server, CREATE/ALTER TRIGGER statements) SQL2003 syntax CREATE/ALTER TYPE statements DB2 [See DB2, CREATE/ALTER TYPE statements] keywords MySQL Oracle [See Oracle, CREATE/ALTER TYPE statements] platform support for PostgreSQL [See PostgreSQL, CREATE/ALTER TYPE statements] programming tips quick reference 2nd rules SQL Server SQL2003 syntax CREATE/ALTER VIEW statements DB2 [See DB2, CREATE/ALTER VIEW statements] keywords MySQL Oracle [See Oracle, CREATE/ALTER VIEW statements] platform support for PostgreSQL programming tips quick reference 2nd rules SQL Server SQL2003 syntax CROSS JOIN CUME_DIST function 2nd 3rd CURDATE( ) function (MySQL) Currency parameter object type (ADO.NET) CURSOR datatype platform comparison SQL Server cursors [See CLOSE CURSOR statement DECLARE CURSOR command] CURTIME( ) function (MySQL) CV function (Oracle) |