...

Classification | Oracle | Altibase | Description |
---|---|---|---|

Numeric Function | ABS | ABS | Return absolute value |

ACOS | ACOS | Return the arc cosine of n | |

ASIN | ASIN | Return the arc sine of n | |

ATAN | ATAN | Return the arctangent of n | |

ATAN2 | ATAN2 | Return the arc tangent of n/m | |

BITAND | BITAND | Return an integer by performing AND operation on the bits of argument 1 and 2 | |

BITNOT | BITNOT | Return the result fo NOT operation for the bits of bit_a | |

BITOR | BITOR | Return the result of OR operation for the bits of bit_a and bit_b | |

BITXOR | BITXOR | Return the XOR (exclusive OR) operation result for the bits of bit_a and bit_b | |

CEIL | CEIL | Round up the number specified in the argument and return an integer | |

COS | COS | Return the cosine value | |

COSH | COSH | Return the hyperbolic cosine | |

EXP | EXP | Return e to the power of n | |

FLOOR | FLOOR | Return the maximum value among integers less than or equal to a specified number | |

Not supported | ISNUMERIC | Determine whether the entered formula is valid as a numeric data type | |

LN | LN | Return the natural logarithm of the input | |

LOG | LOG | Return the logarithm of n with the base m in LOG(m,n) | |

MOD | MOD | Return the remainder of dividing n2 by n1 | |

NANVL | Not supported | If the input value n2 is Nan (non-numeric), the replacement value n1 is returned. If n2 is not NaN, return n2 | |

Not supported | NUMAND | Return the result of bitwise AND operation of BIGINT type bigint_a and bigint_a as BIGINT type result value | |

Not supported | NUMOR | Return the result of bitwise OR operation of BIGINT type bigint_a and bigint_a as BIGINT type result value | |

Not supported | NUMSHIFT | Return the result of shifting as many as n bits to bigint, which is a BIGINT type, as a result value of BIGINT type | |

Not supported | NUMXOR | Return the result of bitwise XOR operation of BIGINT type bigint_a and bigint_a as BIGINT type result value | |

POWER | POWER | Return the value of n2 to the power of n1 | |

Not supported | RAND | Generate a random number between 0 and less than 1 and return it as a double type value | |

dbms.random() | RANDOM | Return a pseudo-random integer value | |

REMAINDER | MOD | Return the remainder of n2 divided by n1 | |

ROUND (number) | ROUND (number) | Return n value after the decimal point is rounded to integer | |

SIGN | SIGN | Return the sign of n | |

SIN | SIN | Return the sine of n | |

SINH | SINH | Return the hyperbolic sine of n | |

SQRT | SQRT | Return the square root of n | |

TAN | TAN | Return the tangent of n | |

TANH | TANH | Returns the hyperbolic tangent of n | |

TRUNC (number) | TRUNC (number) | Truncate factor n1 to decimal place parameter n2 or less | |

WIDTH_BUCKET | Not supported | Create a histogram with the same area | |

Character functions that returns character values | Not supported | CHOSUNG | Extract and return only the first letter of each letter from the entered Hangul string |

CHR | CHR | Return the ASCII code corresponding to the decimal number n | |

CONCAT | CONCAT | Concatenate char1 and char2 and return | |

Not supported | DIGEST | Return the hash digest of expr as a VARCHAR type using a quasi-encrypted hash algorithm. | |

Not supported | DIGITS | Return input integer as a string | |

INITCAP | INITCAP | Convert the first letter of each word from the input string to uppercase and the rest to lowercase and return | |

LOWER | LOWER | Convert input string to lower case | |

LPAD | LPAD | Fill expr1 from the specified digit n, and fill expr1 in the remaining space on the left | |

LTRIM | LTRIM | Remove all characters specified by set from the left side of the character string char | |

NCHR | NCHR | Return Unicode character | |

NLS_INITCAP | Not supported | Return char by converting the first letter of each word to uppercase and the remaining letters to lowercase | |

NLS_LOWER | Not supported | Convert all characters to lowercase and return | |

NLS_UPPER | Not supported | Return the input string converted to all uppercase letters | |

NLSSORT | Not supported | Sort input string and return string | |

Not supported | RANDOM_STRING | Create an arbitrary string as long as the length in the format specified in the option | |

REGEXP_REPLACE | REGEXP_REPLACE | Replace the part that satisfies the specified regular expression with another specified string | |

REGEXP_SUBSTR | REGEXP_SUBSTR | Return a substring that satisfies the specified regular expression | |

REPLACE | REPLACE | In the first string given as a parameter, all the second strings are replaced with the third-string and the result is returned | |

Not supported | REPLICATE | Return a string repeated expr n times | |

Not supported | REVERSE_STR | Return the result of inverting the character order of expr | |

RPAD | RPAD | To the right of the argument expr1, the character specified by the argument expr2 is repeated as long as n is necessary | |

RTRIM | RTRIM | Remove all characters specified by set from the right end of the argument char | |

Not supported | SIZEOF | Return the size of a string or the size allocated to it | |

SOUNDEX | Not supported | Return a string with the phonetic representation of char | |

Not supported | STUFF | Remove length from the position specified by start and return a string with expr2 inserted in that position | |

SUBSTR | SUBSTR SUBSTRING | Return a string of length from the start character in expr | |

SUBSTRB | SUBSTRB | Determine position and length in bytes, not characters | |

TRANSLATE | TRANSLATE | Each character in from_string is replaced with the corresponding character in to_string and expr is returned | |

TREAT | Not supported | Change the declaration type of the argument | |

TRIP | TRIMp | Remove leading or trailing (both sides) characters from the string | |

UPPER | UPPER | Conver all letters to uppercase | |

Character functions that return numeric values | ASCII | ASCII | Return the decimal value corresponding to the ASCII value of the first character of a given char |

Not supported | DATE_TO_UNIX | Convert expr of DATE type to a value in seconds based on 1970-01-01 00:00:00 (UTC +00:00 time zone) and return | |

INSTR | INSTR | Return the position of the first occurrence of the specified character in a string as a number | |

Not supported | INSTRB | Return the position of the specified string in bytes rather than characters | |

LENGTH | CHAR_LENGTH CHARACTER_LENGTH LENGTH | Return the length of the argument char | |

Not supported | LENGTHB | Return the length of the input string in bytes | |

Not supported | OCT_TO_NUM | Convert expr to octal | |

Not supported | PKCS7PAD16 | Fit the total byte length of expr to a multiple of 16 | |

Not supported | PKCS7UNPAD16 | Restore a multiple of 16 byte string created using the KCS7PAD16() function to the data before padding | |

Not supported | POSITION | Find substring in input expr string and return the position of the first character of the substring | |

REGEXP_COUNT | REGENX_COUNT | Return the number of times the pattern is bright in a string | |

REGEXP_INSTR | REGEXP_INSTR | Return the first position (what character) of the part that satisfies the specified condition (regular expression) | |

NLS character function | NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME | Not supported | Return DB charset ID and name |

Collation function | COLLATION NLS_COLLATION_ID NLS_COLLATION_NAME | Not supported | Return information about collation settings |

Datetime function | ADD_MONTHS | ADD_MONTHS | Return the value of the date plus a specific number of months integer |

Not supported | CONV_TIMEZONE | Convert expr based on src_tz time zone to dest_tz time zone | |

CURRENT_DATE | CURRENT_DATE | Return the date information of the current session as Date data type | |

CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | Return the date and time information of the current session | |

+, - operation | +, -, DATEADD | Return the result by increasing the date_field_name part of date by the number | |

Not supported | DATEDIFF | Return the value of enddate minus startdate (i.e. enddate-startdate) in the unit specified in date_field_name | |

Not supported | DATENAME | Return the name of the month or weekday of the specified date according to the input date_field_name | |

DBTIMEZONE | DB_TIMEZONE | Return the value of the database time zone | |

EXTRACT (datetime) | DATEPART EXTRACT (datetime) | Return only the value corresponding to date_field_name in the input date | |

FROM_TZ | Not supported | Convert timestamp data type and time zone data type to TIMESTAMP WITH TIME ZONE data type | |

LAST_DAY | LAST_DAY | Return the last day of the month in which the date belongs | |

LOCALTIMESTAMP | Not supported | Output the current date and time of timestamp | |

MONTHS_BETWEEN | MONTHS_BETWEEN | Calculate the month between date date1 and date2 | |

NEW_TIME | Not supported | Output the Zone1 time in zone2 time | |

NEXT_DAY | NEXT_DAY | Convert the next date of the specified weekday based on that day | |

NUMTODSINTERVAL | Not supported | Change n to INTERVAL DAY TO SECOND character | |

NUMTOYMINTERVAL | Not supported | Change n to INTERVAL YEAR TO MONTH character | |

ORA_DST_AFFECTED | Not supported | ||

ORA_DST_CONVERT | Not supported | ||

ORA_DST_ERROR | Not supported | ||

ROUND (date) | ROUND (date) | Return the date rounded to the unit specified by the format model fmt | |

SESSIONTIMEZONE | SESSION_TIMEZONE | Reflect the time zone of the current session | |

SYS_EXTRACT_UTC | Not supported | Return Coordinated Universal Time—formerly Greenwich Mean Time (UTC) | |

SYSDATE | SYSDATE | Return the date and time of the OS where the database is located | |

SYSTIMESTAMP | SYSTIMESTAMP | Return the system date | |

TRUNC (date) | TRUNC (date) | Round or cut dates based on year, month, and day | |

TZ_OFFSET | Not supported | Return the time zone offset corresponding to the argument based on the date the statement was executed | |

Not supported | UNIX_DATE | Output the current date and time of the operating system based on the UTC +00:00 time zone | |

Not supported | UNIX_TIMESTAMP | Output the current date and time of the operating system based on the UTC +00:00 time zone | |

Not supported | UNIX_TO_DATE | Convert expr to DATE type and return | |

Comparison function | CASE | CASE, CASE2 | Convert expr to DATE type and return |

GREATEST | GREATEST | Return the largest value among one or more arguments | |

LEAST | LEAST | Return the smallest value among the list of arguments EXPR | |

Conversion function | ACSIISTR | ASCIISTR | Return the ASCII string of a string |

Not supported | BASE64_DECODE | Decode the input string of VARBYTE type encoded in base64 format and return the original data of VARBYTE type | |

Not supported | BASE64_DECODE_64 | VARBYTE type value is encoded in base64 format and VARBYTE type string is returned | |

Not supported | BASE64_ENCODE_STR | Return the result of base64-encoded hexadecimal input string as a VARCHAR type string. | |

Not supported | BINARY_LENGTH | Return the data length of binary data types such as BLOB, BYTE, and NIBBLE | |

BIN_TO_NUM | BIN_TO_NUM | Convert bit (binary) vector to equivalent number (decimal) | |

CAST | CAST | Convert data type or collection type to another data type or collection type | |

CHARTOROWID | Not supported | Convert character type value to ROWID type | |

COMPOSE | Not supported | Return Unicode in normalized form | |

CONVERT | CONVERT | Convert character set to another character set | |

DECOMPOSE | Not supported | Return the UNICODE string after decomposition into the same character set as the input | |

Not supported | HEX_DECODE | Convert hexadecimal string to ASCII string and return | |

Not supported | HEX_ENCODE | Convert ASCII string to hexadecimal string corresponding to each character and return | |

Not supported | HEX_TO_NUM | convert expr to decimal | |

HEXTORAW | Not supported | Convert hexadecimal to raw value | |

RAWTOHEX | Not supported | Convert RAW to hexadecimal characters | |

RAWTONHEX | Not supported | Convert RAW TO NVARCHAR2 hexadecimal number | |

Not supported | RAW_CONCAT | Concatenate and return values of multiple input VARBYTE data types that are not NULL | |

Not supported | RAW_SIZEOF | Return the actual size of the data space allocated to the input expr | |

Not supported | RAW_TO_FLOAT | Convert the value converted to VARBYTE data type to NUMERIC or FLOAT data type using TO_RAW function and return | |

Not supported | RAW_TO_INTEGER | Return the value converted to VARBYTE as INTEGER data type by using TO_RAW function | |

Not supported | RAW_TO_NUMERIC | Convert the value converted to VARBYTE data type to NUMERIC or FLOAT data type using TO_RAW function and return | |

Not supported | RAW_TO_VARCHAR | Convert VARCHAR type data to VARCHAR type data converted VARBYTE type value using the TO_RAW function | |

ROWIDTOCHAR | Not supported | Convert rowid value to VARCHAR2 format | |

ROWIDTOONCHAR | Not supported | Convert rowid value to NVARCHAR2 format | |

ROWNUM | ROWNUM | Order the value of a selected row, not supported in DML | |

SCN_TO_TIMESTAMP | Not supported | Take a number evaluated as a system change number (SCN) as an argument and return the nearest timestamp related to the SCN | |

TIMESTAMP_TO_SCN | Not supported | Return system change number (SCN) related to timestamp | |

Not supported | TO_BIN | Convert n to binary | |

TO_BiNARY_DOUBLE | Not supported | Return double-precision floating point | |

TO_BINARY_FLOAT | Not supported | Return a single-precision floating-point number | |

TO_BLOB (bfile) | Not supported | Convert BFILE to BLOB | |

TO_BLOB (raw) | Not supported | Convert RAW to BLOB | |

TO_CHAR (bfile|blob) | Not supported | Convert BFILE and BLOB to database charset | |

TO_CHAR (character) | Not supported | Convert to database character set | |

TO_CHAR (datetime) | TO_CHAR (datetime) | Convert to VARCHAR data type value of specified format | |

TO_CHAR (number) | TO_CHAR (number) | Convert to VARCHAR data type value | |

TO_CLOB (bfile|blob) | Not supported | Convert NCLOB value to CLOB value | |

TO_CLOB (character) | Not supported | Convert character value to CLOB | |

TO_DATE | TO_DATE | Convert char to date data type value | |

TO_DSINTERVAL | Not supported | Convert INTERVAR DAY TO SECOND value | |

Not supported | TO_HEX | Convert n to hexadecimal | |

Not supported | TO_INTERVAL (NUMTODSINTERVAL) | Convert n to interval_unit unit and return | |

TO_LOB | Not supported | Convert LONG or LONG ROW value to LOB value | |

TO_MULTI_BYTE | Not supported | Return the character converted from a multibyte character to the corresponding single-byte character | |

TO_NCHAR (character) | TO_NCHAR (character) | Convert to national character set | |

TO_NCHAR (number) | TO_NCHAR (number) | Covert n to national character set | |

TO_NCHAR (datetime) | TO_NCHAR (datetime) | Convert to national character set | |

TO_NCLOB | Not supported | Convert CLOB value to NCLOB value | |

TO_NUMBER | TO_NUMBER | Convert expr to a value of data type NUMBER | |

Not supported | TO_OCT | Convert n to octal | |

Not supported | TO_RAW | Convert all data type values entered in n into VARBYTE type and return | |

TO_SINGLE_BYTE | Not supported | Convert multibyte characters into corresponding single-byte characters and return char | |

TO_TIMESTAMP | TO_DATE | Convert char to value of TIMESTAMP data type | |

TO_TIMESTAMP_TZ | Not supported | Convert char to TIMESTAMP WITH TIME ZONE data type | |

TO_YMINTERVAL | Not supported | Change string to INTERVAL YEAR TO MONTH format | |

TRANSLATE ... USING | Not supported | Convert char to the specified character set for conversion between the database character set and national character cents | |

UNISTR | UNISTR | Take a text string as an argument and return it as a national language character set | |

VALIDATE_CONVERSION | Not supported | Determine whether expr can be converted to the specified data type | |

Large Object (LOB) function | BFILENAME | Not supported | Return the BFILE locator associated with the physical LOB binary file of the server file system |

EMPTY_BLOB | EMPTY_BLOB | Initialize lob variable and return the location of empty lob | |

EMPTY_CLOB | EMPTY_CLOB | Initialize lob variable and return the location of empty lob | |

Collection functions related to nested tables | CARDINALITY COLLECT POWERMULTISET POWERMULTISET_BY_CARDINALITY SET | Not supported | Functions related to nested tables |

Hierarchical function | SYS_CONNECT_BY_PATH | SYS_CONNECT_BY_PATH | Return the column value Path from root to node |

Data mining functions | CLUSTER_DETAILS CLUSTER_DISTANCE CLUSTER_ID CLUSTER_PROBABILITY CLUSTER_SET FEATURE_COMPARE FEATURE_DETAILS FEATURE_ID FEATURE_SET FEATURE_VALUE ORA_DM_PARTITION_NAME PREDICTION PREDICTION_BOUNDS PREDICTION_COST PREDICTION_DETAILS PREDICTION_PROABILITY PREDICTION_SET | Not supported | Data mining related functions |

XML functions | APPRENDCHILDXML DELETEXML DEPTH EXISTSNODE EXTRACT (XML) EXTRACTVALUE INSERTCHILDXML INSERTCHILDXMLAFTER INSERTCHILDXMLBEFORE INSERTXMLAFTER INSERTXMLBEFORE PATH SYS_DBURIGEN SYS_XMLAGG SYS_XMLGEN UPDATEXML XMLAGG XMLCAST XMLCDATA XMLCOLATTAVAL XMLCOMMENT XMLCONCAT XMLDIFF XMELEMENT XMLEXISTS XMLFOREST XMLISVALID XMLPARSE XMLPATCH XMLPI XMLQUERY XMLROOT XMLSEQUENCE XMLSERIALIZE XMLTABLE XMLTRANSFORM
| Not supported | XML related functions |

JSON functions | JSON_ARRAY JSON_ARRAYAGG JSON_DATAGUIDE JSON_OBJECT JSON_OBJECTAGG JSON_QUERY JSON_TABLE JSON_VALUE | Not supported | JSON related functions |

Encoding/Decoding functions | DECODE | DECODE | Same as CASE WHEN where simple_case_expr is used |

DUMP | DUMP | Return the location and length of specified data in a specified format | |

ORA_HASH | Not supported | Calculate a hash value for a given expression | |

STANDARD_HASH | Not supported | Calculate standard hash value | |

VSIZE | OCTET_LENGTH | Return the length of the input string in bytes | |

NULL functions | COALESCE | COALESCE | Returns the first non-NULL argument |

LNNVL | LNNVL | If the result of the condition is FALSE or NULL, TRUE is returned, and if the condition is TRUE, FALSE is returned | |

NULLIF | NULLIF | If expr1 and expr2 is the same, return NULL value | |

NVL | NVL | Replace NULL values with blanks in the query result | |

NVL2 | NVL2 | If expr1 is not NULL, NVL2 returns expr2. If it is NULL, expr3 is returned. | |

Environment and identifier functions | Not supported | HOST_NAME | Return the name of the currently connected host |

CON_DBID_TO_ID CON_GUID_TO_ID CON_NAME_TO_ID CON_UID_TO_ID ORA_INVOKING_USER ORA_INVOKING_USERID | Not supported | ||

Not supported | SENDMSG | Send message to ip=address, port as Socket datagram | |

SYS_CONTEXT | SYS_CONTEXT | Return the result value of related parameters using the environment information (context) connected to the current session as a namespace | |

SYS_GUID | SYS_GUID_STR | Create and return a globally unique identifier (RAW value) consisting of 16 bytes. Create a globally unique identifier of 16 bytes and returns it as a 32 hexadecimal string | |

SYS_TYPEID | Not supported | Return the typeid of the identifier | |

UID | USER_ID | Return an integer that uniquely identifies the session user | |

USER | USER_NAME | Return the name of the session user | |

USERENV | SESSION_ID | USERENV returns information about the session. SESSION_ID returns the user's SESSION_ID | |

Approxiamtion functions | APPROX_COUNT_DISTINCT APPROX_COUNT_DISTINCT_AGG APPROX_COUNT_DISTINCT_DETAIL APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_AGG APPROX_PERCENTILE_DETAIL | Not supported | |

GROUP_ID | Not supported | Distinguish duplicate groups from the specified GROUP BY result | |

GROUPING | GROUPING | When a column described in the GROUPING function is grouped by using it with the ROLLUP or CUBE operator. In other words, a function that shows whether it was used in ROLLUP or CUBE operation. | |

GROUPING_ID | GROUPING_ID | Return the number corresponding to the GROUPING bit vector associated with the row | |

MEDIAN | Not supported | Returns the median or interpolated value after sorting of values | |

STAT_BINOMIAL_TEST | Not supported | An exact probability test used for dichotomous variables where only two valid values exist (variables with two exclusive values) | |

STATS_CROSSTAB | Not supported | Analyze two nominal variables | |

STATS_F_TEST | Not supported | Test whether there is a significant difference between the two variances | |

STATS_KS_TEST | Not supported | The Kolmogorov-Smirnov function that tests whether two samples belong to the same population or that they belong to a population with the same distribution | |

STATS_MODE | Not supported | Return the value with the largest frequency | |

STATS_MW_TEST | Not supported | A Mann-Whitney test compares two independent samples. | |

STATS_ONE_WAY_ANOVA | STATS_ONE_WAY_ANOVA | The one-way analysis of variance function (STATS_ONE_WAY_ANOVA) verifies the significant difference in the mean (for a group or variable) for statistical significance by comparing two other estimates of variance | |

STAT_T_TEST_(STATS_T_TEST_ONE, STAT_T_TEST_PAIRED, STATS_T_TEST_INDEP and STATS_T_TEST_INDEPU) | Not supported | In t-test, the significance of the difference between the mean values is measured | |

STATS_WSR_TEST | Not supported | Wilcox sign ranking test of paired pairs is performed, and the difference between samples is tested whether there is a significant difference from zero | |

SYS_OP_ZONE_ID | Not supported | Take a rowid as an argument and return the area ID | |

TO_APPROX_COUNT_DISTINCT | Not supported | ||

TO_APPROX_PERCENTILE | NOt supported | ||

Analysis functions | FIRST_VALUE | FIRST_VALUE | Return the first value in an ordered set of values |

Not supported | FIRST_VALUE_IGNORE_NULLS | Get the value of the first row excluding null values | |

LAG | LAG | Refer to the previous value relative to the current row | |

Not supported | LAG_IGNORE_NULLS | Calculate the value of the first non-NULL row from the offset th after the current row | |

NTH_VALUE | NTH_VALUE | Find the value of the offset th row | |

Not supported | NTH_VALUE_IGNORE_NULLS | Find the value of the offset th row excluding null values | |

NTILE | NTILE | Divide the output result by the number of groups specified by the user and output it | |

RATIO_TO_REPORT | RATIO_TO_REPORT | Calculate the ratio of a value to the sum of a set of values | |

ROW_NUMBER | ROW_NUMBER | Give a ranking for the results sorted by division | |

Aggregation/analysis function | AVG | AVG | Return the average of the rows that satisfy the conditions for the specified column, excluding nulls |

CORR | CORR | Return the correlation coefficient for a pair of numbers | |

CORR_ (CORR_S, CORR_K) | Not supported | (See CORR) Calculate Pearson's correlation coefficient | |

COUNT | COUNT | Return the number of rows returned by the query | |

COVAR_POP | COVAR_POP | Return the population covariance of a set of number combinations | |

COVAR_SAMP | COVAR_SAMP | Return the sample covariance of a set of number pairs | |

CUME_DIST | CUME_DIST | Compute the cumulative distribution of values in a group of values | |

DENSE_RANK | DENSE_RANK | Rank is given to the column or expression used in the ORDER BY clause. Unlike RANK(), the rank after the same rank returns a value that is increased by 1 regardless of the number of the same rank. | |

FIRST | FIRST | Operate on a set of values from a set of rows by ranking as FIRST or LAST for a given sort specification | |

Not supported | GROUP_CONCAT | Return the string concatenated with non-NULL expr1 in each group | |

LAST | LAST | The last row is extracted by sequencing the rows | |

LISTAGG | LISTAGG | Return a single string by concatenating a string and a separator for all rows in a group | |

MAX | MAX | Return the maximum value among arguments | |

MIN | MIN | Return the minimum value among arguments | |

PERCENT_RANK | PERCENT_RANK | Return the rank percentage of a value for the number of groups | |

PERCENTILE_CONT | PERCENTILE_CONT | Inverse distribution function assuming a continuous distribution model | |

PERCENTILE_DISK | PERCENTILE_DISC | Inverse distribution function assuming a discrete distribution model | |

RANK | RANK | Calculate the rank of values in a group of values | |

REGR_ (Linear Regression) Functions | Not supported | The linear regression function fits a normal least squares regression line to a set of numeric pairs | |

STDDEV | STDDEV | Return the sample standard deviation of expr, which is a combination of numbers | |

STDDEV_POP | STDDEV_POP | Calculate the population standard deviation and return the square root of the population variance | |

STDDEV_SAMP | STDDEV_SAMP | Calculate the cumulative sample standard deviation and returns the square root of the sample variance | |

SUM | SUM | Return the sum of the values of expr | |

VAR_POP | VAR_POP | Return the population variance of a set of Numbers after removing null values | |

VAR_SAMP | VAR_SAMP | Return the sampling variance of a set of numbers after removing nulls. | |

VARIANCE | VARIANCE | Return the variance of expr | |

Object reference functions | DEREF MAKE_REF REF REFTOHEX VALUE | Not supported | Object reference functions |

Model functions | CV ITERATION_NUMBER PRESENTNNV PRESENTV PREVIOUS | Not supported | Available only in Model_clause of Select statement |

OLAP function | CUBE_TABLE | Not supported | Convert 3D data to 2D data |

Data cartridge function | DATAOBJ_TO_MAT_PARTITION DATAOBJ_TO_PARTITION | Not supported | Useful for data cartridge development |

Encryption | DBMS_CRYPTO | AESDECRYPT AESENCRYPT DESDECRYPT DESENCRYPT TDESDECRYPT TRIPLE_DESDECRYPT TDESENCRYPT TRIPLE_DESENCRYPT |

...