Category

ORACLE Functions

ALTIBASE HDB Functions

Comments

Numeric

ABS (n)

ABS (n)

Returns absolute number of given value n.

 

ACOS (n)

ACOS (n)

Returns the arc cosine of given value n.

 

ASIN (n)

ASIN (n)

Return the arc sine of given value n.

 

ATAN (n)

ATAN (n)

Returns the arc tangent of given value n.

 

ATAN2 (m, n)

ATAN2 (m, n)

Returns the arc tangent of m and n.

 

BITAND (m, n)

BITAND (m, n)

Returns AND operation of the bits of given m and n.
In the ALTIBASE HDB, BITAND function can only handle the bit data type while ORACLE BITAND function support the normal numeric type.

 

CEIL (n)

CEIL (n)

Returns smallest integer greater than or equal to given value n.

 

COS (n)

COS (n)

Returns the cosine of given value n.

 

COSH (n)

COSH (n)

Returns the hyperbolic cosine of given value n.

 

EXP (n)

EXP (n)

Returns e raised to the nth power.

 

FLOOR (n)

FLOOR (n)

Returns largest integer equal to or less then given value n.

 

LN (n)

LN (n)

Returns the natural logarithm of given value n..

 

LOG (m,n)

LOG (m,n)

Returns logarithm, base m of n.

 

MOD (m,n)

MOD (m,n)

Returns the remainder of m divided by n.

 

NANVL (m, n)

N/A

Returns n when m is NaN(Not a Number).
Only useful when you use BINARY_FLOAT , BINARY_DOUBLE.
ALTIBASE HDB does not support those types, so NANVL function is not supported.

 

POWER

POWER

Returns m raised to the nth power.

 

REMAINDER

MOD (m,n)

Returns the remainder of m divided by n.
This function is same as MOD() except that it uses FLOOR in its formula.
In the ALTIBASE HDB, please use MOD() instead.

 

ROUND (m, n)

ROUND (m, n)

Returns m rounded to n places to the right of decimal point.

 

SIGN (n)

SIGN (n)

Returns the sign of n.

 

SIN (n)

SIN (n)

Returns the sine of n.

 

SINH (n)

SINH (n)

Returns the hyperbolic sine of n.

 

SQRT (n)

SQRT (n)

Returns the square root of n.

 

TAN (n)

TAN (n)

Returns the tangent of n.

 

TANH (n)

TANH (n)

Returns the hyperbolic tangent of n.

 

TRUNC (m, n)

TRUNC (m, n)

Returns m truncated to n decimal places.

 

WIDTH_BUCKET (expr, min, max, n)

N/A

Construct equiwidth histogram. equiwidth
ALTIBASE HDB does not support this function.

Character

CHR (n)

CHR (n)

Returns the character having the binary equivalent to n.

 

CONCAT (char1,char2)

CONCAT (char1,char2)

Returns char1 concatenated with char2.

 

INITCAP (char)

INITCAP (char)

Returns char with the first letter of each word in uppercase.

 

LOWER (char)

LOWER (char)

Returns char with all letters lowercase.

 

LPAD (expr1,n, expr2)

LPAD (expr1,n, expr2)

Pads the left of expr1 with the sequence of characters in expr2, repeatedly if necessary, until the resultant string is n characters long.

 

LTRIM (char, set)

LTRIM (char, set)

Removes from the left end of char all of the characters contained in set.

 

NLS_INITCAP (char, nlsparam)

N/A

Same as INITCAP except that it supported National Language Support..

 

NLS_LOWER (char, nlsparam)

N/A

Same as LOWER except that it supported National Language Support.

 

NLSSORT (char, nlsparam)

N/A

Returns the string of bytes used to sort char.

 

NLS_UPPER (char, nlsparam)

N/A

Same as UPPER except that it supported National Language Support.

 

REGEXP_REPLACE

N/A

ALTIBASE HDB does not support regular expression.

 

REGEXP_SUBSTR

N/A

ALTIBASE HDB does not support regular expression.

 

REPLACE(char, str1, str2)

REPLACE(char, str1, str2)

Returns with every occurrence of str1 replaced with str2.

 

RPAD (expr1, n , expr2)

RPAD (expr1, n , expr2)

Pads the right end of expr1 with the sequence of characters in expr2, repeatedly if necessary, until the resultant string is n characters long.

 

RTRIM (char, set)

RTRIM (char, set)

Removes from the right end of char all of the characters that appeared in set.

 

SOUNDEX

N/A

ALTIBASE HDB does not support this function.

 

SUBSTR

SUBSTR

Returns a portion of string, beginning at character position, substring_length characters long.
There are 4 siblings in this function such as SUBSTRB, SUBSTRC, SUBSTR2 and SUBSTR4 in ORACLE.
But ALTIBASE HDB only supports SUBSTRB.

 

TRANSLATE (expr, str1, str2)

TRANSLATE (expr, str1, str2)

Returns expr with all occurrences of each character in str1 replaced by its corresponding character in str2.

 

TREAT

N/A

Changes the declared type of an expression.
ALTIBASE HDB does not support this function.

 

TRIM(expr1, expr2)

TRIM(expr1, expr2)

Returns a trimmed expr1 with expr2.
ALTIBASE HDB supports just BOTH mode while ORACLE support LEADING and TRAILING modes.

 

UPPER (char)

UPPER (char)

Returns char with uppercase.

 

ASCII (char)

ASCII (char)

Returns the decimal representation of the first character.

 

INSTR (string, substring, position, occurrence)

INSTR (string, substring, position, occurrence)

INSTR (string, substring, position, occurrence) returns an integer indicating the position of the character in string is the first character of this occurrence.
There are 4 siblings in this function such as INSTRB, INSTRC, INSTR2 and INSTR4 in ORACLE.
But ALTIBASE HDB only support INSTRB.

 

LENGTH(char)

LENGTH(char)

Returns the length of char.
There are 5 siblings in this function such as LENGTHB, LENGTHC, LENGTH2 and LENGTH4 in ORACLE.
But ALTIBASE HDB only supports LENGTHB.

 

REGEXP_INSTR

N/A

ALTIBASE HDB does not support regular expression.

Datetime

ADD_MONTH (date, integer)

ADD_MONTH (date, integer)

Returns the date plus integer months.

 

CURRENT_DATE

N/A

ALTIBASE HDB does not support this feature.

 

CURRENT_TIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

DBTIMEZONE

N/A

ALTIBASE HDB does not support this feature.

 

EXTRACT

EXTRACT

Extracts and returns the value of a specified datetime field from a datetime or interval value expression.

 

FROM_TZ

N/A

ALTIBASE HDB does not support this feature.

 

LAST_DAY

LAST_DAY

Returns the date of the last day of the month that contains date.

 

LOCALTIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

MONTHS_BETWEEN(date, date)

MONTHS_BETWEEN(date, date)

Subtracts a second date value from the first date and returns the result in months.
If a first date value is less than second date value, a negative number will be returned.

 

NEW_TIME

N/A

ALTIBASE HDB does not support this feature.

 

NEXT_DAY(date, char)

NEXT_DAY(date, char)

Returns the date of the first weekday named by char that is later than the date.

 

NUMTODSINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

NUMTOYMINTERVAL

N/A

ALTIBASE HDB does not support this feature..

 

ROUND (date, fmt)

ROUND (date, fmt)

Returns date rounded to the unit specified by the format model fmt.

 

SESSIONTIMEZONE

N/A

ALTIBASE HDB does not support this feature.

 

SYS_EXTRACT_UTC

N/A

ALTIBASE HDB does not support this feature.

 

SYSDATE

SYSDATE

Returns the current date and time set for the OS on which the database resides.

 

SYSTIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

TO_CHAR (datetime, fmt)

TO_CHAR (datetime, fmt)

Converts date, which is a date type value, to a VARCHAR type string having the datetime format specified using fmt.

 

TO_TIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

TO_TIMESTAMP_TZ

N/A

ALTIBASE HDB does not support this feature.

 

TO_DSINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

TO_YMINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

TRUNC(date, fmt)

TRUNC(date, fmt)

Returns date with the time of the day truncated to the unit specified by the format model fmt.

 

TZ_OFFSET

N/A

ALTIBASE HDB does not support this feature.

Conversion

ASCIISTR (char)

ASCIISTR (char)

Returns an ASCII version of char.

 

BIN_TO_NUM (exp)

BIN_TO_NUM (exp)

Converts a bit vector to its equivalent number.

 

CAST

CAST

Converts build-in data types of one type into another built-in datatype.

 

CHARTOROWID

N/A

ALTIBASE HDB does not support this feature.

 

COMPOSE

N/A

ALTIBASE HDB does not support this feature.

 

CONVERT(char, dest_char_set, source_char_set)

CONVERT(char, dest_char_set, source_char_set)

Converts a character string from one character set to another.

 

DECOMPOSE

N/A

ALTIBASE HDB does not support this feature.

 

HEXTORAW

N/A

ALTIBASE HDB does not support this feature.

 

NUMTODSINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

NUMTOYMINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

RAWTOHEX

N/A

ALTIBASE HDB does not support this feature.

 

RAWTOHEX

N/A

ALTIBASE HDB does not support this feature.

 

RAWTONHEX

N/A

ALTIBASE HDB does not support this feature.

 

ROWIDTOCHAR

N/A

ALTIBASE HDB does not support this feature.

 

ROWIDTONCHAR

N/A

ALTIBASE HDB does not support this feature.

 

SCN_TO_TIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

TIMESTAMP_TO_SCN

N/A

ALTIBASE HDB does not support this feature.

 

TO_BINARY_DOUBLE

N/A

ALTIBASE HDB does not support this feature.

 

TO_BINARY_FLOAT

N/A

ALTIBASE HDB does not support this feature.

 

TO_CHAR (character)

TO_CHAR (character)

Returns character value of CHAR type.

 

TO_CHAR (number, fmt)

TO_CHAR (number, fmt)

Converts number to a value of VARCHAR type.

 

TO_DATE (char, fmt)

TO_DATE (char, fmt)

Converts char of string to a value of DATE type.

 

TO_DSINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

TO_LOB

N/A

ALTIBASE HDB does not support this feature.

 

TO_MULTI_BYTE

N/A

ALTIBASE HDB does not support this feature.

 

TO_NCHAR(character)

TO_NCHAR(character)

Converts a character string from database character set to national character set.

 

TO_NCHAR(datetime)

TO_NCHAR(datetime)

Converts a datetime of DATE data type from database character set to national character set.

 

TO_NCHAR(number)

TO_NCHAR(number)

Converts number to a string in the national character set.

 

TO_NUMBER(expr)

TO_NUMBER(expr)

Converts expr to a value of NUMBER datatype.

 

TO_DSINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

TO_SINGLE_BYTE

N/A

ALTIBASE HDB does not support this feature.

 

TO_TIMESTAMP

N/A

ALTIBASE HDB does not support this feature.

 

TO_TIMESTAMP_TZ

N/A

ALTIBASE HDB does not support this feature.

 

TO_YMINTERVAL

N/A

ALTIBASE HDB does not support this feature.

 

TRANSLATION ... USING

N/A

ALTIBASE HDB does not support this feature.

 

UNISTR(string)

UNISTR(string)

Converts the input character string to the national character set.

Collection

CARDINALITY

N/A

ALTIBASE HDB does not support this feature.

 

COLLECT

N/A

ALTIBASE HDB does not support this feature.

 

POWERMULTISET

N/A

ALTIBASE HDB does not support this feature.

 

POWERMULTISET_BY_CARDINALITY

N/A

ALTIBASE HDB does not support this feature.

 

SET

N/A

ALTIBASE HDB does not support this feature.

Encoding and Decoding

DECODE(expr, search, result)

DECODE(expr, search, result)

Compares expr to each search value one by one.

 

DUMP (expr)

DUMP (expr)

Returns the datatype code, length in byte, internal representation of expr.

 

ORA_HASH

N/A

ALTIBASE HDB does not support this feature.

 

VSIZE

N/A

ALTIBASE HDB does not support this feature.

General Comparison

GREATEST (expr)

GREATEST (expr)

Returns the greatest of the list of one or more expression.

 

LEAST (expr)

LEAST (expr)

Returns the least of the list of one or more expression.

Large Object

BFILENAME

N/A

ALTIBASE HDB does not support this feature.

 

EMPTY_BLOB / EMPTY_CLOB

N/A

ALTIBASE HDB does not support this feature.

Model

CV

N/A

ALTIBASE HDB does not support this feature.

 

ITERATION_NUMBER

N/A

ALTIBASE HDB does not support this feature.

 

PRESENTNNV

N/A

ALTIBASE HDB does not support this feature.

 

PRESENTV

N/A

ALTIBASE HDB does not support this feature.

 

PREVIOUS

N/A

ALTIBASE HDB does not support this feature.

NLS Character

NLS_CHARSET_DECL_LEN

N/A

ALTIBASE HDB does not support this feature.

 

NLS_CHARSET_ID

N/A

ALTIBASE HDB does not support this feature.

 

NLS_CHARSET_NAME

N/A

ALTIBASE HDB does not support this feature.

 

SYS_CONNECT_BY_PATH

N/A

ALTIBASE HDB does not support this feature.

 

SYS_CONTEXT

N/A

ALTIBASE HDB does not support this feature.

 

SYS_GUID

N/A

ALTIBASE HDB does not support this feature.

 

UID

N/A

ALTIBASE HDB does not support this feature. 

 

USER

N/A

ALTIBASE HDB does not support this feature.

 

USERENV

N/A

ALTIBASE HDB does not support this feature.

NUL-Related

COALESCE

N/A

ALTIBASE HDB does not support this feature.

 

LNNVL

N/A

ALTIBASE HDB does not support this feature.

 

NULLIF

N/A

ALTIBASE HDB does not support this feature. 

 

NVL(expr1, expr2)

NVL(expr1, expr2)

Checks expr1 is null and returns expr2. 

 

NVL2(expr1, expr2, expr3)

NVL2(expr1, expr2, expr3)

Checks expr1 is null and returns expr2. if not, returns expr3.

Object Reference

DEREF

N/A

ALTIBASE HDB does not support this feature.

 

MAKE_REF

N/A

ALTIBASE HDB does not support this feature.

 

REF

N/A

ALTIBASE HDB does not support this feature.

 

REFTOHEX

N/A

ALTIBASE HDB does not support this feature.

 

VALUE

N/A

ALTIBASE HDB does not support this feature.

XML

DEPTH

N/A

ALTIBASE HDB does not support this feature.

 

EXISTSNODE

N/A

ALTIBASE HDB does not support this feature. 

 

EXTRACT

N/A

ALTIBASE HDB does not support this feature.

 

EXTRACTVALUE

N/A

ALTIBASE HDB does not support this feature.

 

PATH

N/A

ALTIBASE HDB does not support this feature.

 

SYS_XMLAGG

N/A

ALTIBASE HDB does not support this feature. 

 

SYS_XMLGEN

N/A

ALTIBASE HDB does not support this feature.

 

SYS_DBURIGEN

N/A

ALTIBASE HDB does not support this feature. 

 

UPDATEXML

N/A

ALTIBASE HDB does not support this feature. 

 

XMLTRANSFORM

N/A

ALTIBASE HDB does not support this feature. 

 

XMLAGG

N/A

ALTIBASE HDB does not support this feature.

 

XMLCOLATTVAL

N/A

ALTIBASE HDB does not support this feature.

 

XMLCONCAT

N/A

ALTIBASE HDB does not support this feature.

 

XMLFOREST

N/A

ALTIBASE HDB does not support this feature.

 

XMLSEQUENCE

N/A

ALTIBASE HDB does not support this feature.

 

XMLTRANSFORM

N/A

ALTIBASE HDB does not support this feature.

Group

* AVG (var)

* AVG (var)

Returns the average value of var. 

 

* COUNT (var)

* COUNT (var)

Returns the count of var.

 

CUBE

N/A

ALTIBASE HDB does not support this feature.

 

GROUP_ID

N/A

ALTIBASE HDB does not support this feature.

 

GROUPING

N/A

ALTIBASE HDB does not support this feature.

 

GROUPING_ID

N/A

ALTIBASE HDB does not support this feature.

 

GROUPING SETS

N/A

ALTIBASE HDB does not support this feature.

 

* MIN (var)

* MIN (var)

Returns the minimum value of var.

 

* MAX(var)

* MAX(var)

Returns the maximum value of var.

 

ROLLUP

N/A

ALTIBASE HDB does not support this feature.

 

* SUM(var)

* SUM(var)

Returns the summation of var.

Window

CORR

N/A

ALTIBASE HDB does not support this feature.

 

CORR_*

N/A

ALTIBASE HDB does not support this feature.

 

COVAR_POP

N/A

ALTIBASE HDB does not support this feature.

 

COVAR_SAMP

N/A

ALTIBASE HDB does not support this feature.

 

CUME_DIST

N/A

ALTIBASE HDB does not support this feature.

 

DENSE_RANK

DENSE_RANK

Is used to assign rank values to the members of a result set or partition.
However, DENSE_RANK does not leave a gap in the sequence after the occurrence of duplicate values("tie" values).

 

FIRST

N/A

ALTIBASE HDB does not support this feature.

 

FIRST_VALUE

N/A

ALTIBASE HDB does not support this feature.

 

LAST

N/A

ALTIBASE HDB does not support this feature.

 

LAST_VALUE

N/A

ALTIBASE HDB does not support this feature.

 

MEDIAN

N/A

ALTIBASE HDB does not support this feature.

 

NTILE

N/A

ALTIBASE HDB does not support this feature.

 

PERCENTILE_CONT

N/A

ALTIBASE HDB does not support this feature.

 

PERCENTILE_DISC

N/A

ALTIBASE HDB does not support this feature.

 

PERCENT_RANK

N/A

ALTIBASE HDB does not support this feature.

 

RANK

RANK

The RANK function is used to assign rank values to the members of the result set (or partition).
And it leaves a gap in the sequence after duplicate values ("tie" values).

 

RATIO_TO_REPORT

N/A

ALTIBASE HDB does not support this feature.

 

REGR_*

N/A

ALTIBASE HDB does not support this feature.

 

ROW_NUMBER

ROW_NUMBER

Is used to sequentially assign unique numbers to the members of a result set or partition.
The numbers are assigned starting from 1 in the order determined by the ORDER BY expression.

 

STATS_BINOMIAL_TEST

N/A

ALTIBASE HDB does not support this feature.

 

STATS_CROSSTAB

N/A

ALTIBASE HDB does not support this feature.

 

STATS_F_TEST

N/A

ALTIBASE HDB does not support this feature.

 

STATS_KS_TEST

N/A

ALTIBASE HDB does not support this feature.

 

STATS_MODE

N/A

ALTIBASE HDB does not support this feature.

 

STATS_MW_TEST

N/A

ALTIBASE HDB does not support this feature.

 

STATS_ONE_WAY_ANOVA

N/A

ALTIBASE HDB does not support this feature.

 

STATS_T_TEST_*

N/A

ALTIBASE HDB does not support this feature.

 

STATS_WSR_TEST

N/A

ALTIBASE HDB does not support this feature.

 

* STDDEV(var)

STDDEV(var)

Returns the sample standard deviation of var.

 

STDDEV_POP

N/A

ALTIBASE HDB does not support this feature.

 

STDDEV_SAMP

N/A

ALTIBASE HDB does not support this feature.

 

VAR_POP

N/A

ALTIBASE HDB does not support this feature.

 

VAR_SAMP

N/A

ALTIBASE HDB does not support this feature.

 

VARIANCE

VARIANCE

Returns the variance of the input expressions.

The aggregation functions marked with asterisk (*) support Analytic function feature in the ALTIBASE HDB.