Commands/Functions
DBS SQL COMMANDS:
ABORT
ALTER CONSTRAINT
ALTER FUNCTION
ALTER METHOD
ALTER PROCEDURE
ALTER REPLICATION GROUP
ALTER TABLE
ALTER TRIGGER
ALTER TYPE
ANALYSIS INSERT
BEGIN LOGGING
BEGIN QUERY CAPTURE
BEGIN QUERY LOGGING
BEGIN TRANSACTION
CALL
CHECKPOINT
COLLECT DEMOGRAPHICS
COLLECT STATISTICS
COMMENT
COMMIT
CREATE AUTHORIZATION
CREATE CAST
CREATE CONSTRAINT
CREATE DATABASE
CREATE FUNCTION
CREATE GLOP SET
CREATE HASH INDEX
CREATE INDEX
CREATE JOIN INDEX
CREATE MACRO
CREATE METHOD
CREATE ORDERING
CREATE PROCEDURE
CREATE PROFILE
CREATE REPLICATION GROUP
CREATE REPLICATION RULESET
CREATE ROLE
CREATE TABLE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DATABASE
DELETE
DELETE DATABASE
DELETE USER
DROP AUTHORIZATION
DROP CAST
DROP CONSTRAINT
DROP DATABASE
DROP FUNCTION
DROP GLOP SET
DROP INDEX
DROP JOIN INDEX
DROP MACRO
DROP METHOD
DROP ORDERING
DROP PROCEDURE
DROP PROFILE
DROP REPLICATION GROUP
DROP REPLICATION RULESET
DROP ROLE
DROP STATISTICS
DROP TABLE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
DROP VIEW
DUMP EXPLAIN
ECHO
END LOGGING
END QUERY CAPTURE
END QUERY LOGGING
END TRANSACTION
EXECUTE
EXPLAIN
FLUSH QUERY LOGGING
GIVE
GRANT
GRANT LOGON
HELP
HELP STATISTICS
INITIATE INDEX ANALYSIS
INITIATE PARTITION
INSERT EXPLAIN
LOCKING
MERGE
MODIFY DATABASE
MODIFY PROFILE
MODIFY USER
NEW
RENAME
REPLACE AUTHORIZATION
REPLACE CAST
REPLACE FUNCTION
REPLACE MACRO
REPLACE METHOD
REPLACE ORDERING
REPLACE PROCEDURE
REPLACE QUERY LOGGING
REPLACE REPLICATION RULESET
REPLACE TRANSFORM
REPLACE TRIGGER
REPLACE VIEW
RESTART INDEX ANALYSIS
REVOKE
REVOKE LOGON
ROLLBACK
SELECT
SET ROLE
SET SESSION
SHOW
SHOW DML
SHOW STATISTICS
UPDATE
USING
DBS SQL FUNCTIONS:
ABS
ACOS
ACOSH
ADD_MONTHS
ASCII
ASIN
ASINH
ATAN
ATAN2
ATANH
AVERAGE
BEGIN
BYTES
CASE_N
CAST
CHAR2HEXINT
CHAR_LENGTH
CHARACTERS
CHR
CONTAINS
CORR
COS
COSH
COUNT
COVAR_POP
COVAR_SAMP
CSUM
DECODE
EDITDISTANCE
EMPTY_BLOB
EMPTY_CLOB
END
EXP
EXTRACT
FLOOR
FORMAT
FROM_BYTES
GREATEST
HASHAMP
HASHBAKAMP
HASHBUCKET
HASHROW
INDEX
INITCAP
INSTR
INTERVAL
KURTOSIS
LAST
LAST_DAY
LEAST
LENGTH
LN
LOG
LOWER
LPAD
LTRIM
MAVG
MAXIMUM
MCHARACTERS
MDIFF
MEETS
MINDEX
MINIMUM
MLINREG
MONTHS_BETWEEN
MSUBSTR
MSUM
NAMED
NEXT
NEXT_DAY
NGRAM
NULLIFZERO
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
NVP
OADD_MONTHS
OCTET_LENGTH
OREPLACE
OTRANSLATE
P_INTERSECT
P_NORMALIZE
PERCENT_RANK
POSITION
POWER
PRECEDES
PRIOR
QUANTILE
RANDOM
RANGE_N
RANK
RDIFF
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SIMILAR
REGEXP_SUBSTR
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
ROUND
ROW_NUMBER
RPAD
RTRIM
SIGN
SIN
SINH
SKEW
SOUNDEX
SQRT
STDDEV_POP
STDDEV_SAMP
STRTOK
SUBSTR
SUCCEEDS
SUM
TAN
TANH
TITLE
TO_BYTES
TO_CHAR
TO_DATE
TO_DSINTERVAL
TO_NUMBER
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRANSLATE
TRANSLATE_CHK
TRIM
TRUNC
TRUNCATE
TYPE
UPPER
VAR_POP
VAR_SAMP
VARGRAPHIC
WIDTH_BUCKET
XMLAGG
XMLCOMMENT
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLFOREST
XMLPARSE
XMLPI
XMLQUERY
XMLSERIALIZE
XMLTABLE
XMLTEXT
XMLVALIDATE
Stored Procedure Definition:
{
CREATE PROCEDURE | REPLACE PROCEDURE }
[BEGIN]
[ { DECLARE } | { DECLARE CONDITION } ]
[ DECLARE CURSOR ]
[ DECLARE HANDLER ]
[ SPLStatements | COMPOUND STATEMENT]
[END]
CREATE PROCEDURE
REPLACE PROCEDURE
DECLARE
DECLARE CONDITION
DECLARE HANDLER
COMPOUND STATEMENT
SPL COMMANDS:
ALLOCATE
BEGIN REQUEST-END REQUEST
BEGIN-END
CASE
CLOSE
DEALLOCATE PREPARE
DECLARE CURSOR
EXECUTE
EXECUTE IMMEDIATE
FETCH
FOR
GET DIAGNOSTICS
IF
ITERATE
LEAVE
LOOP
OPEN
PREPARE
PRINT
REPEAT
RESIGNAL
SELECT AND CONSUME INTO
SELECT INTO
SET
SIGNAL
WHILE
No comments:
Post a Comment