SQL Reference Guide

Index

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 Z

A
ABS function (ODBC compatible)
ABS scalar function
ACOS function (ODBC compatible)
ACOS scalar function
ADD_MONTHS function (extension)
ADD_MONTHS scalar function
Aggregate Functions
     AVG
     COUNT
     MAX
     MIN
     SUM
Aliases
ALTER INDEX
ALTER INDEX statement
ALTER SEQUENCE
     ALTER SEQUENCE
     CREATE SEQUENCE
     DROP SEQUENCE
ALTER TABLE
ALTER TABLE statement
ALTER VIEW
Approximate numeric data type
Approximate Numeric Data Types
ASCII function (ODBC compatible)
ASCII scalar function
ASIN function (ODBC compatible)
ASIN scalar function
Assign Values to Auto-Increment Fields in INSERT
ATAN function (ODBC compatible)
ATAN scalar function
ATAN2 function (ODBC compatible)
ATAN2 scalar function
AVG
AVG aggregate function
B
Basic Predicate
     Basic Predicate
     BETWEEN Predicate
     CONTAINS Predicate
     IN Predicate
     LIKE Predicate
     NULL Predicate
     Quantified Predicate
     Relational Operators
BETWEEN Predicate
BIGINT data type
BINARY data type
BIT data type
Bit String Data Types
BLOB
C
CALL
CALL statement
Cartesian product
CASE (SQL-92 Compatible)
     CASE (SQL-92 Compatible)
     Date Arithmetic Expressions
     DECODE function (extension)
CASE scalar function
CAST function (SQL-92 compatible)
CAST scalar function
CEILING function (ODBC compatible)
CEILING scalar function
CHAR function (ODBC compatible)
CHAR scalar function
Character Data Types
Character expressions
     concatenated
Character String Literals
     Character Data Types
     Character String Literals
     Concatenated Character Expressions
CHARTOROWID (extension)
CHARTOROWID scalar function
CHR function (extension)
CHR scalar function
CLOB
COALESCE (SQL-92 compatible)
COALESCE scalar function
Column Constraints
Column names, aliases
column_title
COMMIT WORK
COMMIT WORK statement
Common Table Expressions (CTE) and Recursive Queries
CONCAT function (ODBC compatible)
CONCAT scalar function
Concatenated Character Expressions
     Concatenated Character Expressions
     Expressions
Conditional Expressions
     CASE (SQL-92 Compatible)
     COALESCE (SQL-92 compatible)
     Conditional Expressions
     DECODE function (extension)
     Expressions
     NULLIF (SQL-92 compatible)
CONNECT
CONNECT statement
Constants
     character string
     date-time
     numeric
     timestamp
CONTAINS Predicate
Conventional Identifiers
     Conventional Identifiers
     FairCom DB SQL Identifiers
CONVERT function (extension)
     CONVERT function (extension)
     Date Arithmetic Expressions
CONVERT function (ODBC compatible)
     CAST function (SQL-92 compatible)
     CONVERT function (extension)
     CONVERT function (ODBC compatible)
CONVERT scalar function
Copyright Notice
COS function (ODBC compatible)
COS scalar function
COT SQL Scalar Function
COUNT
     COUNT
     COUNT_BIG
COUNT aggregate function
COUNT_BIG
CREATE FUNCTION
CREATE FUNCTION statement
CREATE INDEX
CREATE INDEX statement
CREATE PROCEDURE
CREATE PROCEDURE statement
CREATE SEQUENCE
     ALTER SEQUENCE
     CREATE SEQUENCE
     DROP SEQUENCE
CREATE SYNONYM
CREATE SYNONYM statement
CREATE TABLE
CREATE TABLE statement
CREATE TRIGGER
CREATE TRIGGER statement
CREATE VIEW
CREATE VIEW statement
Creating and Modifying Users and Groups
Cross Database Query
CURDATE function (ODBC compatible)
CURDATE scalar function
CURRENT_DATE SQL function
CURRENT_TIMESTAMP function
CURRENT_USER SQL Function
CURTIME function (ODBC compatible)
CURTIME scalar function
D
Data arithmetic expressions
Data types
     approximate numeric
     BIGINT
     BINARY
     BIT
     Concatenated Character Expressions
     CREATE PROCEDURE
     CREATE TABLE
     Data Types
     date-time
     DECIMAL
     DOUBLE PRECISION
     exact numeric
     FLOAT
     INTEGER
     LVARBINARY
     MONEY
     NUMERIC
     Numeric Arithmetic Expressions
     REAL
     TIMESTAMP
     TINYINT
     VARBINARY
DATABASE (ODBC compatible)
Database Names and Filesystem Names
DATABASE scalar function
DATALENGTH function
Date Arithmetic Expressions
     Date Arithmetic Expressions
     Expressions
Date Format Strings
     Date Format Strings
     Date-Time Data Types
     TO_CHAR function (extension)
Date Literals
     Date Literals
     TO_DATE function (extension)
DATEADD function
DATEDIFF function
Date-time
     data type
     format strings
     literals
Date-Time Data Types
Date-Time Format Strings
Date-Time Literals
DAYNAME function (ODBC compatible)
DAYNAME scalar function
DAYOFMONTH function (ODBC compatible)
DAYOFMONTH scalar function
DAYOFWEEK function (ODBC compatible)
DAYOFWEEK scalar function
DAYOFYEAR function (ODBC compatible)
DAYOFYEAR scalar function
DB_NAME (extension)
DB_NAME scalar function
DECIMAL data type
DECODE function (extension)
DECODE scalar function
DEGREES function (ODBC compatible)
DEGREES scalar function
DELETE
DELETE statement
Delimited Identifiers
     Conventional Identifiers
     Delimited Identifiers
DIFFERENCE function (ODBC compatible)
DIFFERENCE scalar function
DISCONNECT
DISCONNECT statement
DOUBLE PRECISION data type
DROP FUNCTION
DROP FUNCTION statement
DROP INDEX
DROP INDEX statement
DROP PROCEDURE
DROP PROCEDURE statement
DROP SEQUENCE
     ALTER SEQUENCE
     CREATE SEQUENCE
     DROP SEQUENCE
DROP SYNONYM
DROP SYNONYM statement
DROP TABLE
DROP TABLE statement
DROP TRIGGER
DROP TRIGGER statement
DROP VIEW
DROP VIEW statement
E
Equi-joins
Escape field name matching reserved words in c-tree expressions
Exact Numeric Data Types
EXISTS Predicate
EXP function (ODBC compatible)
EXP scalar function
EXPLAIN PLAN
Expressions
     conditional
     data arithmetic
     Expressions
     numeric arithmetic
     SELECT
EXTRACT SQL Function
F
FairCom DB SQL Built-in Stored Procedures
FairCom DB SQL Identifiers
     FairCom DB SQL Identifiers
     Users, Schemas and Roles
FairCom DB SQL Reserved Words
FairCom Typographical Conventions
fc_add_db( )
     FairCom DB SQL Built-in Stored Procedures
     fc_add_db( )
fc_check_file_tran_state( )
     FairCom DB SQL Built-in Stored Procedures
     fc_check_file_tran_state( )
fc_create_db( )
fc_create_user( )
     FairCom DB SQL Built-in Stored Procedures
     fc_create_user( )
fc_get_cachestats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_cachestats()
fc_get_connstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_connstats()
fc_get_dblist( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_dblist( )
fc_get_fcproclist( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_fcproclist( )
fc_get_filestats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_filestats()
fc_get_hosttablename()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_hosttablename()
fc_get_iostats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_iostats()
fc_get_isamstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_isamstats()
fc_get_lockstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_lockstats()
fc_get_memstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_memstats()
fc_get_min_card( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_min_card( )
fc_get_partbounds()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_partbounds()
fc_get_priority( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_priority( )
fc_get_replstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_replstats()
fc_get_selectivity( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_selectivity( )
fc_get_server_version( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_server_version( )
fc_get_sqlstats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_sqlstats()
fc_get_sysconfig()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_sysconfig()
fc_get_taskid( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_taskid( )
fc_get_transtats()
     FairCom DB SQL Built-in Stored Procedures
     fc_get_transtats()
fc_get_userlist( )
     FairCom DB SQL Built-in Stored Procedures
     fc_get_userlist( )
fc_ptadmin_num()
     FairCom DB SQL Built-in Stored Procedures
     fc_ptadmin_num()
fc_purge_db()
fc_set_blockinglock( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_blockinglock( )
fc_set_debug( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_debug( )
fc_set_file_tran_state( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_file_tran_state( )
fc_set_impersonation( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_impersonation( )
fc_set_min_card( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_min_card( )
fc_set_nodename( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_nodename( )
fc_set_priority( )
fc_set_rowid_visible()
fc_set_selectivity( )
     FairCom DB SQL Built-in Stored Procedures
     fc_set_selectivity( )
fc_set_sysconfig()
     FairCom DB SQL Built-in Stored Procedures
     fc_set_sysconfig()
FLOAT data type
FLOOR function (ODBC compatible)
FLOOR scalar function
Format strings
     date-time
Full Text Predicate
Functions
     ABS
     ACOS
     ADD_MONTHS
     aggregate
     ASCII
     ASIN
     ATAN
     ATAN2
     AVG
     CASE
     CAST
     CEILING
     CHAR
     CHARTOROWID
     CHR
     COALESCE
     CONCAT
     CONVERT
     COS
     COUNT
     CURDATE
     CURTIME
     DATABASE
     DAYNAME
     DAYOFMONTH
     DAYOFWEEK
     DAYOFYEAR
     DB_NAME
     DECODE
     DEGREES
     DIFFERENCE
     EXP
     Expressions
     FLOOR
     Functions
     GREATEST
     HOUR
     IFNULL
     INITCAP
     INSERT
     INSTR
     LAST_DAY
     LCASE
     LEAST
     LEFT
     LENGTH
     LOCATE
     LOG10
     LOWER
     LPAD
     LTRIM
     MAX
     MIN
     MINUTE
     MOD
     MONTH
     MONTHNAME
     MONTHS_BETWEEN
     NEXT_DAY
     NOW
     NULLIF
     NVL
     OBJECT_ID
     PI
     POWER
     PREFIX
     QUARTER
     RADIANS
     RAND
     REPLACE
     RIGHT
     ROWID
     ROWIDTOCHR
     RPAD
     RTRIM
     SECOND
     SIGN
     SIN
     SOUNDEX
     SPACE
     SQRT
     SUBSTR
     SUBSTRING
     SUFFIX
     SUM
     SUSER_NAME
     SYSDATE
     SYSTIME
     SYSTIMESTAMP
     TAN
     TIMESTAMPADD
     TIMESTAMPDIFF
     TO_CHAR
     TO_DATE
     TO_NUMBER
     TO_TIME
     TO_TIMESTAMP
     TRANSLATE
     UCASE
     UPPER
     USER
     USER_NAME
     WEEK
     YEAR
G
GET DIAGNOSTICS
GET DIAGNOSTICS statement
GETDATE function (ODBC compatible)
Glossary
GRANT
GRANT statement
GREATEST function (extension)
GREATEST scalar function
H
HOUR function (ODBC compatible)
HOUR scalar function
I
Identifiers
     conventional
     delimited
     SQL
IFNULL function (ODBC compatible)
     IFNULL function (ODBC compatible)
     ISNULL function
IFNULL scalar function
IN Predicate
INITCAP function (extension)
INITCAP scalar function
Inner Joins
     Basic Predicate
     Inner Joins
     Query Expressions
INSERT
INSERT function (ODBC compatible)
INSERT scalar function
INSERT statement
INSTR function (extension)
INSTR scalar function
INTEGER data type
ISNULL function
ISNUMERIC function
J
Joining tables
     Cartesian product
     equi-joins
     inner joins
     outer joins
     self joins
L
LAST_DAY function (extension)
LAST_DAY scalar function
LAST_IDENT function (extension)
LAST_ROWID function
LCASE function (ODBC compatible)
LCASE scalar function
LEAST function (extension)
LEAST scalar function
LEFT function (ODBC compatible)
LEFT scalar function
LEN function (ODBC compatible)
LENGTH function (ODBC compatible)
     LEN function (ODBC compatible)
     LENGTH function (ODBC compatible)
LENGTH scalar function
LIKE Predicate
Literals
     character string
     date-time
     Expressions
     Literals
     numeric
     timestamp
LOCALTIME SQL Function
LOCALTIMESTAMP SQL Function
LOCATE function (ODBC compatible)
LOCATE scalar function
LOCK TABLE
LOG SQL Scalar Function
LOG10 function (ODBC compatible)
LOG10 scalar function
Logical operators
Logical Operators: OR, AND, NOT
LOWER function (SQL-92 compatible)
LOWER scalar function
LPAD function (extension)
LPAD scalar function
LTRIM function (ODBC compatible)
LTRIM scalar function
LVARBINARY data type
M
MAX
MAX aggregate function
MIN
MIN aggregate function
MINUTE function (ODBC compatible)
MINUTE scalar function
MOD function (ODBC compatible)
MOD scalar function
MONEY data type
MONTH function (ODBC compatible)
MONTH scalar function
MONTHNAME function (ODBC compatible)
MONTHNAME scalar function
MONTHS_BETWEEN function (extension)
MONTHS_BETWEEN scalar function
N
NEXT_DAY function (extension)
NEXT_DAY scalar function
NOW function (ODBC compatible)
     GETDATE function (ODBC compatible)
     NOW function (ODBC compatible)
NOW scalar function
NULL Predicate
NULLIF (SQL-92 compatible)
NULLIF scalar function
Numeric Arithmetic Expressions
     Expressions
     Numeric Arithmetic Expressions
NUMERIC data type
Numeric data types
Numeric Literals
     Approximate Numeric Data Types
     Date-Time Data Types
     Exact Numeric Data Types
     Numeric Arithmetic Expressions
     Numeric Literals
NVL function (extension)
NVL scalar function
O
OBJECT_ID function (extension)
OBJECT_ID scalar function
OCTET_LENGTH SQL Function
Operators
     logical
     relational
ORDER BY
ORDER BY CLAUSE statement
Outer join predicate
Outer Join Predicate
Outer Joins
     Outer Join Predicate
     Outer Joins
     Query Expressions
OVERLAY SQL Function
P
PI function (ODBC compatible)
PI scalar function
POSITION SQL Function
POWER function (ODBC compatible)
POWER scalar function
Predicates
     basic
     between
     contains
     exists
     in
     like
     null
     outer join
     quantified
PREFIX function (extension)
PREFIX scalar function
Q
Quantified Predicate
     Quantified Predicate
     Relational Operators
QUARTER function (ODBC compatible)
QUARTER scalar function
Query Expressions
     authorization
     basic predicate
     between predicate
     contains predicate
     exists predicate
     in predicate
     like predicate
     null predicate
     outer join predicate
     quantified predicate
     search conditions
R
RADIANS function (ODBC compatible)
RADIANS scalar function
RAND function (ODBC compatible)
RAND scalar function
REAL data type
Relational Operators
     Basic Predicate
     Quantified Predicate
     Relational Operators
RENAME
RENAME statement
REPEAT function (ODBC compatible)
REPLACE function (ODBC compatible)
REPLACE scalar function
result table
REVOKE
REVOKE statement
RIGHT function (ODBC compatible)
RIGHT scalar function
ROLLBACK WORK
ROLLBACK WORK statement
ROUND function
ROWID (extension)
ROWID scalar function
ROWIDTOCHAR (extension)
ROWIDTOCHAR scalar function
RPAD function (extension)
RPAD scalar function
RTRIM function (ODBC compatible)
RTRIM scalar function
S
Scalar functions
     ABS
     ABS function (ODBC compatible)
     ACOS
     ADD_MONTHS
     ASCII
     ASIN
     ATAN
     ATAN2
     CASE
     CAST
     CEILING
     CHAR
     CHARTOROWID (extension)
     CHR
     COALESCE
     CONCAT
     Conditional Expressions
     CONVERT
     COS
     CURDATE
     CURTIME
     DATABASE
     DAYNAME
     DAYOFMONTH
     DAYOFWEEK
     DAYOFYEAR
     DB_NAME
     DECODE
     DEGREES
     DIFFERENCE
     EXP
     FLOOR
     GREATEST
     HOUR
     IFNULL
     INITCAP
     INSERT
     INSTR
     LAST_DAY
     LCASE
     LEAST
     LEFT
     LENGTH
     LOCATE
     LOG10
     LOWER
     LPAD
     LTRIM
     MINUTE
     MOD
     MONTH
     MONTHNAME
     MONTHS_BETWEEN
     NEXT_DAY
     NOW
     NULLIF
     NVL
     OBJECT_ID
     PI
     POWER
     PREFIX
     QUARTER
     RADIANS
     RAND
     REPLACE
     RIGHT
     ROWID
     ROWIDTOCHAR
     RPAD
     RTRIM
     Scalar Functions
     SECOND
     SIGN
     SIN
     SOUNDEX
     SPACE
     SQRT
     SUBSTR
     SUBSTRING
     SUFFIX
     SUSER_NAME
     SYSDATE
     SYSTIME
     SYSTIMESTAMP
     TAN
     TIMESTAMPADD
     TIMESTAMPDIFF
     TO_CHAR
     TO_DATE
     TO_NUMBER
     TO_TIME
     TO_TIMESTAMP
     TRANSLATE
     UCASE
     UPPER
     USER
     USER_NAME
     WEEK
     YEAR
Scalar Sub-query Expressions
     Expressions
     Scalar Sub-query Expressions
     SELECT
     UPDATE
Search Conditions
     EXISTS Predicate
     Query Expressions
     Search Conditions
SECOND function (ODBC compatible)
SECOND scalar function
SELECT
     Query Expressions
     SELECT
SELECT statement
Self joins
Sequence Values
SESSION_USER SQL Function
SET CONNECTION statement
SET IDENTITY_INSERT
SET SCHEMA
SET SCHEMA statement
SET TRANSACTION ISOLATION
SET TRANSACTION ISOLATION statement
SIGN function (ODBC compatible)
SIGN scalar function
SIN function (ODBC compatible)
SIN scalar function
SOUNDEX function (ODBC compatible)
SOUNDEX scalar function
SPACE function (ODBC compatible)
SPACE scalar function
SQL - Create [if not exists] and Drop [if exists]
SQL Error Messages
SQL full-text search examples using PORTER English stemming tokenizer
SQL full-text search examples using SIMPLE tokenizer
SQL identifiers
SQL Language Elements
SQL names
SQL Statements
SQRT function (ODBC compatible)
SQRT scalar function
Statements
      CREATE FUNCTION
      CREATE INDEX
      DROP FUNCTION
     ALTER INDEX
     ALTER TABLE
     CALL
     COMMIT WORK
     CONNECT
     CREATE INDEX
     CREATE PROCEDURE
     CREATE SYNONYM
     CREATE TABLE
     CREATE TRIGGER
     CREATE VIEW
     DELETE
     DISCONNECT
     DROP INDEX
     DROP PROCEDURE
     DROP SYNONYM
     DROP TABLE
     DROP TRIGGER
     DROP VIEW
     GET DIAGNOSTICS
     GRANT
     INSERT
     ORDER BY CLAUSE
     RENAME
     REVOKE
     ROLLBACK WORK
     SELECT
     SET CONNECTION
     SET SCHEMA
     SET TRANSACTION ISOLATION
     UPDATE
     UPDATE STATISTICS
Storage Attributes
SUBSTR function (extension)
SUBSTR scalar function
SUBSTRING function (ODBC compatible)
SUBSTRING scalar function
SUBSTRING SQL Function (SQL-99 compatible)
SUFFIX function (extension)
SUFFIX scalar function
SUM
SUM aggregate function
SUSER_NAME function (extension)
SUSER_NAME scalar function
Syntax Conventions
SYSDATE function (extension)
SYSDATE scalar function
System Catalog Tables
System Catalog Tables Definitions
System Limits
SYSTIME function (extension)
SYSTIME scalar function
SYSTIMESTAMP function (extension)
SYSTIMESTAMP scalar function
T
Table Constraints
Table Valued Functions
TAN function (ODBC compatible)
TAN scalar function
Time Format Strings
     Date-Time Data Types
     Time Format Strings
     TO_CHAR function (extension)
Time Literals
     Time Literals
     TO_TIME function (extension)
TIMESTAMP data type
Timestamp Literals
     Timestamp Literals
     TO_TIMESTAMP function (extension)
TIMESTAMPADD function (ODBC compatible)
     DATEADD function
     TIMESTAMPADD function (ODBC compatible)
TIMESTAMPADD scalar function
TIMESTAMPDIFF function (ODBC compatible)
     DATEDIFF function
     TIMESTAMPDIFF function (ODBC compatible)
TIMESTAMPDIFF scalar function
TINYINT data type
TO_CHAR function (extension)
TO_CHAR scalar function
TO_DATE function (extension)
TO_DATE scalar function
TO_NUMBER function (extension)
TO_NUMBER scalar function
TO_TIME function (extension)
TO_TIME scalar function
TO_TIMESTAMP function (extension)
TO_TIMESTAMP scalar function
TRANSLATE function (extension)
TRANSLATE scalar function
TRIM SQL Function
TRUNCATE function
TRUNCATE TABLE
U
UCASE function (ODBC compatible)
UCASE scalar function
UPDATE
UPDATE statement
UPDATE STATISTICS
UPDATE STATISTICS statement
UPPER function (SQL-92 compatible)
UPPER scalar function
User Defined Scalar Function
     CREATE FUNCTION
     DROP FUNCTION
USER function (ODBC compatible)
USER scalar function
USER_NAME function (extension)
USER_NAME scalar function
Users, Schemas and Roles
V
VARBINARY data type
W
WEEK function (ODBC compatible)
WEEK scalar function
Y
YEAR function (ODBC compatible)
YEAR scalar function