-->

Spiga

Syntax for SQL functions

Page 1 :-

ABS

ABS(n)

ACOS
ACOS(n)

ADD_MONTHS
ADD_MONTHS(date, integer)

analytic_function
analytic_function([ arguments ]) OVER (analytic_clause)

APPENDCHILDXML
APPENDCHILDXML ( XMLType_instance, XPath_string, value_expr [, namespace_string ])

ASCII
ASCII(char)

ASCIISTR
ASCIISTR(char)

ASIN
ASIN(n)

ATAN
ATAN(n)

ATAN2
ATAN2(n1 { , | / } n2)

AVG
AVG([ DISTINCT | ALL ] expr) [ OVER(analytic_clause) ]

BFILENAME
BFILENAME('directory', 'filename')

BIN_TO_NUM
BIN_TO_NUM(expr [, expr ]... )

BITAND
BITAND(expr1, expr2)

CARDINALITY
CARDINALITY(nested_table)

CAST
CAST({ expr | MULTISET (subquery) } AS type_name)

CEIL
CEIL(n)

CHARTOROWID
CHARTOROWID(char)

CHR
CHR(n [ USING NCHAR_CS ])

CLUSTER_ID
CLUSTER_ID ( [ schema . ] model mining_attribute_clause )

CLUSTER_PROBABILITY
CLUSTER_PROBABILITY ( [ schema . ] model [ , cluster_id ] mining_attribute_clause )

CLUSTER_SET
CLUSTER_SET ( [ schema . ] model [ , topN [ , cutoff ] ] mining_attribute_clause ) COALESCE
COALESCE(expr [, expr ]...)


COLLECT
COLLECT (column)

COMPOSE
COMPOSE(char)

CONCAT
CONCAT(char1, char2)

CONVERT
CONVERT(char, dest_char_set[, source_char_set ])

CORR
CORR(expr1, expr2) [ OVER (analytic_clause) ]

CORR_K, CORR_S
{ CORR_K | CORR_S } (expr1, expr2 [, { COEFFICIENT | ONE_SIDED_SIG | ONE_SIDED_SIG_POS | ONE_SIDED_SIG_NEG | TWO_SIDED_SIG } ] )

There was an error in this gadget