SQL Command and Function Reference

Table of Contents


 

Introduction

Who Should Read This Book ?
Information In This Book
Document Conventions
Syntax Diagrams

Data Types

BINARY
CHAR
DATE
DECIMAL
DOUBLE
FILE
FLOAT
INTEGER
LONG VARBINARY
LONG VARCHAR
OID
SMALLINT
SERIAL
TIME
TIMESTAMP
VARCHAR

SQL Commands

ABORT BACKUP
ADD TO GROUP
ALTER DATAFILE
ALTER PASSWORD
ALTER REPLICATION ADD REPLICATE
ALTER REPLICATION DROP REPLICATE
ALTER TABLE ADD COLUMN
ALTER TABLE DROP COLUMN
ALTER TABLE DROP FOREIGN KEY
ALTER TABLE DROP PRIMARY KEY
ALTER TABLE FOREIGN KEY
ALTER TABLE MODIFY COLUMN
ALTER TABLE PRIMARY KEY
ALTER TABLE SET OPTIONS
ALTER TABLESPACE
ALTER TRIGGER ENABLE
ALTER TRIGGER REPLACE
BEGIN BACKUP
BEGIN WORK
CHECK
CHECKPOINT
CLOSE LINK
COMMIT WORK
CONNECT
CREATE COMMAND
CREATE DB
CREATE DOMAIN
CREATE GROUP
CREATE INDEX
CREATE LINK
CREATE REPLICATION
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TEXT INDEX
CREATE TRIGGER
CREATE VIEW
DELETE
DISCONNECT
DROP COMMAND
DROP DOMAIN
DROP GROUP
DROP INDEX
DROP LINK
DROP REPLICATION
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT INDEX
DROP TRIGGER
DROP VIEW
END BACKUP
EXECUTE COMMAND
GRANT (Execute Privileges)
GRANT (Object Privileges)
GRANT (Security Privileges)
INSERT
KILL CONNECTION
LOAD STATISTICS
LOCK TABLE
REBUILD TEXT INDEX
REMOVE FROM GROUP
REVOKE (Execute Privileges)
REVOKE (Object Privileges)
REVOKE (Security Privileges)
ROLLBACK

SAVEPOINT
SELECT
START DB
TERMINATE DB
UNLOAD STATISTICS
UPDATE
UPDATE STATISTICS

Built-in Functions

ABS
ACOS
ADD_DAYS
ADD_MONTHS
ADD_YEARS
ADD_HOURS
ADD_MINS
ADD_SECS
ASCII
ASIN
ATAN
ATAN2
ATOF
CEILING
CHAR
CONCAT
COS
COSH
COT
CURDATE
CURTIME
DATABASE
DATE
DATEPART
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DAYS_BETWEEN
DEGREES
EXP
FILEEXIST
FILELEN
FILENAME
FIX
FLOOR
FREXPE
FREXPM
FTOA
HMS
HOUR
HYPOT
INSERT
INVDATE
INVTIME
INVTIMESTAMP
LAST_DAY
LCASE
LDEXP
LEFT
LENGTH
LOCATE
LOG
LOG10
LTRIM
MDY
MINUTE
MOD
MODFI
MODFM
MONTH
MONTHNAME
NEXT_DAY
NOW
PI
POW
QUARTER
RADIANS
RAND
REPEAT
REPLACE
RIGHT
RND
ROUND
RTRIM
SECOND
SECS_BETWEEN
SIGN
SIN
SINH
SPACE
SQRT
SUBSTRING
TAN
TANH
TIMEPART
TIMESTAMPADD
TIMESTAMPDIFF
UCASE
USER
WEEK
YEAR
Copyright 2002 SYSCOM Computer Engineering Co. All rights reserved.