Contents

Copyright Notice FairCom Typographical Conventions SQL Language Elements c-treeACE SQL Identifiers Conventional Identifiers Delimited Identifiers Data Types Character Data Types Exact Numeric Data Types Approximate Numeric Data Types Date-Time Data Types Bit String Data Types Query Expressions Inner Joins Outer Joins Search Conditions Logical Operators: OR, AND, NOT Relational Operators Basic Predicate Quantified Predicate BETWEEN Predicate NULL Predicate LIKE Predicate CONTAINS Predicate EXISTS Predicate IN Predicate Outer Join Predicate Expressions Concatenated Character Expressions Numeric Arithmetic Expressions Date Arithmetic Expressions Conditional Expressions Literals Numeric Literals Character String Literals Date-Time Literals Date Literals Time Literals Timestamp Literals Date-Time Format Strings Date Format Strings Time Format Strings Functions Aggregate Functions AVG COUNT MAX MIN SUM Scalar Functions ABS function (ODBC compatible) ACOS function (ODBC compatible) ADD_MONTHS function (extension) ASCII function (ODBC compatible) ASIN function (ODBC compatible) ATAN function (ODBC compatible) ATAN2 function (ODBC compatible) CASE (SQL-92 Compatible) CAST function (SQL-92 compatible) CEILING function (ODBC compatible) CHAR function (ODBC compatible) CHARTOROWID (extension) CHR function (extension) COALESCE (SQL-92 compatible) CONCAT function (ODBC compatible) CONVERT function (extension) CONVERT function (ODBC compatible) COS function (ODBC compatible) COT SQL Scaler Function CURDATE function (ODBC compatible) CURRENT_DATE SQL function CURRENT_TIMESTAMP function CURRENT_USER SQL Function CURTIME function (ODBC compatible) DATABASE (ODBC compatible) DAYNAME function (ODBC compatible) DAYOFMONTH function (ODBC compatible) DAYOFWEEK function (ODBC compatible) DAYOFYEAR function (ODBC compatible) DB_NAME (extension) DECODE function (extension) DEGREES function (ODBC compatible) DIFFERENCE function (ODBC compatible) EXP function (ODBC compatible) EXTRACT SQL Function FLOOR function (ODBC compatible) GREATEST function (extension) HOUR function (ODBC compatible) IFNULL function (ODBC compatible) INITCAP function (extension) INSERT function (ODBC compatible) INSTR function (extension) LAST_DAY function (extension) LAST_IDENT function (extension) LCASE function (ODBC compatible) LEAST function (extension) LEFT function (ODBC compatible) LENGTH function (ODBC compatible) LOCATE function (ODBC compatible) LOCALTIME SQL Function LOCALTIMESTAMP SQL Function LOG SQL Scaler Function LOG10 function (ODBC compatible) LOWER function (SQL-92 compatible) LPAD function (extension) LTRIM function (ODBC compatible) MINUTE function (ODBC compatible) MOD function (ODBC compatible) MONTHNAME function (ODBC compatible) MONTH function (ODBC compatible) MONTHS_BETWEEN function (extension) NEXT_DAY function (extension) NOW function (ODBC compatible) NULLIF (SQL-92 compatible) NVL function (extension) OBJECT_ID function (extension) OCTET_LENGTH SQL Function OVERLAY SQL Function PI function (ODBC compatible) POSITION SQL Function POWER function (ODBC compatible) PREFIX function (extension) QUARTER function (ODBC compatible) RADIANS function (ODBC compatible) RAND function (ODBC compatible) REPEAT function (ODBC compatible) REPLACE function (ODBC compatible) RIGHT function (ODBC compatible) ROWID (extension) ROWIDTOCHAR (extension) RPAD function (extension) RTRIM function (ODBC compatible) SECOND function (ODBC compatible) SESSION_USER SQL Function SIGN function (ODBC compatible) SIN function (ODBC compatible) SOUNDEX function (ODBC compatible) SPACE function (ODBC compatible) SQRT function (ODBC compatible) SUBSTR function (extension) SUBSTRING SQL Function (SQL-99 compatible) SUBSTRING function (ODBC compatible) SUFFIX function (extension) SUSER_NAME function (extension) SYSDATE function (extension) SYSTIME function (extension) SYSTIMESTAMP function (extension) TAN function (ODBC compatible) TIMESTAMPADD function (ODBC compatible) TIMESTAMPDIFF function (ODBC compatible) TO_CHAR function (extension) TO_DATE function (extension) TO_NUMBER function (extension) TO_TIME function (extension) TO_TIMESTAMP function (extension) TRANSLATE function (extension) TRIM SQL Function UCASE function (ODBC compatible) UID function (extension) UPPER function (SQL-92 compatible) USER function (ODBC compatible) USER_NAME function (extension) WEEK function (ODBC compatible) YEAR function (ODBC compatible) SQL Statements Syntax Conventions ALTER TABLE CALL COMMIT WORK CONNECT CREATE FUNCTION CREATE INDEX CREATE PROCEDURE CREATE SYNONYM CREATE TABLE Column Constraints Table Constraints CREATE TRIGGER CREATE VIEW DELETE DISCONNECT DROP FUNCTION DROP INDEX DROP PROCEDURE DROP SYNONYM DROP TABLE DROP TRIGGER DROP VIEW EXPLAIN PLAN GET DIAGNOSTICS GRANT INSERT ORDER BY CLAUSE RENAME REVOKE ROLLBACK WORK SELECT SET CONNECTION SET TRANSACTION ISOLATION SET SCHEMA TRUNCATE TABLE UPDATE UPDATE STATISTICS c-treeACE SQL Reserved Words c-treeACE SQL Reserved Words V9 Error Messages Overview c-treeACE SQL Error Codes, SQLSTATE Values, Messages System Catalog Tables Overview System Catalog Tables Definitions System Limits Maximum Values for c-treeACE SQL Attributes Glossary Index