COMPOSE is another vital string/char functions of Oracle. It is used to return the UNICODE String for the desired string. The COMPOSE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: COMPOSE( string ) Parameters: string: It is used to specify the string, … Read more
COALESCE is an advanced function that the Oracle database supports. It is used to get the first non-null expression in the list. The COALESCE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: COALESCE( expr_1, expr_2, … expr_n ) Parameters: expr_1, expr_2, … … Read more
CHR is another vital string/char functions of Oracle. It is used to return the actual character or symbol for the desired ASCII code. The CHR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: CHR( code ) Parameters: code: It is … Read more
CHARTOROWID is one of the vital Conversion functions of Oracle. It is used to convert a char, nchar, varchar2, or nvarchar2 to a rowid. The CHARTOROWID function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: CHARTOROWID ( value ) Parameters: value: … Read more
CEIL is one of the vital Numeric/Math functions of Oracle. It is used to get the smallest integer value which is either greater than or equal to the mentioned number. The CEIL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: … Read more
CAST is one of the vital Conversion functions of Oracle. It is used to convert a datatype to another. The CAST function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: CAST ( {expression | ( subquery ) | MULTISET ( subquery ) } … Read more
CASE is an advanced function that the Oracle database supports. It is used to serve as an IF-THEN-ELSE statement. The CASE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 … … Read more
CARDINALITY is an advanced function that the Oracle database supports. It is used to get the number of elements in a nested table. The CARDINALITY function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g and Oracle 10g. Syntax: CARDINALITY( column ) Parameters: column: It is used to specify the … Read more
BITAND is one of the vital Numeric/Math functions of Oracle. It is used to perform an AND operation on the bits of two expressions. The result is an integer value. The BITAND function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: … Read more
BIN_TO_NUM is one of the vital Conversion functions of Oracle. It is used to convert a bit vector to a number. The BIN_TO_NUM function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: BIN_TO_NUM ( expr1, expr2, … expr_n ) Parameters: expr1, expr2, … … Read more