1. decode函数 Purpose DECODE compares expr to each search value one by one. If expr is equal to a search, then Oracle Database returns the corresponding result. If no match is found, then Oracle returns&nb...(more)
二者可以实现同样的功能
语法:
Join(sourceArray, [delimiter])
Implode(sourceArray, [delimiter])
Concatenates all members of an Array of Strings and returns a string. Elements of the Array are separated by a delimiter, if provided, or the space cha...(more)
CREATE OR REPLACE FUNCTION TMPGETNUMS(F_string VARCHAR(128))RETURNS VARCHAR(128)LANGUAGE SQLSPECIFIC TMPGETNUMSCONTAINS SQLRETURN WITH TMP_STR(POSITION, NUMBERS) AS (VALUES (0, CAST('' AS VARCHAR(128))) UNION...(more)
Ceiling
Returns a number rounded to the next
highest integer.
Syntax
ceiling (numeric_exp)
Examples
ceiling (-1.23)
Returns the result: -1
ceiling (1.23)
Returns the result: 2
Floor
Returns a number rounded to the next
lowest integer.
Synt...(more)