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

ABS is one of the vital Numeric/Math functions of Oracle. It is used to get the absolute value of a number. The ABS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ABS ( number ) Parameters: number: It is used … Read more

BFILENAME is an advanced function that the Oracle database supports. It is used to get a BFILE locator for a physical LOB binary file. The BFILENAME function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: BFILENAME( ‘directory’, ‘filename’ ) Parameters: directory: … Read more