COVAR_SAMP function in Oracle

by

COVAR_SAMP is one of the vital Analytic functions of Oracle. It is used to get the sample covariance of a set of number pairs. The COVAR_SAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: COVAR_SAMP ( expr1, expr2 ) Parameters: … Read more

COVAR_POP function in Oracle

by

COVAR_POP is one of the vital Analytic functions of Oracle. It is used to get the population covariance of a set of number pairs. The COVAR_POP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: COVAR_POP ( expr1, expr2 ) Parameters: … Read more

COUNT function in Oracle

by

COUNT is one of the vital Numeric/Math functions of Oracle. It is used to get the Count of an expression. The COUNT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: To calculate simple count. SELECT COUNT (aggregate_expression) FROM tables WHERE … Read more

COS function in Oracle

by

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

CORR function in Oracle

by

CORR is one of the vital Analytic functions of Oracle. It is used to get the coefficient of correlation of a set of number pairs. The CORR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: CORR ( x, y ) … Read more

CONVERT function in Oracle

by

CONVERT is one of the vital string/char functions of Oracle. It is used to convert a string from one character set to another. The CONVERT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: CONVERT( string, char_set_to , char_set_from ) Parameters: … Read more

CONCAT function in Oracle

by

CONCAT is one of the vital string/char functions of Oracle. It is used to concatenate two strings together. The CONCAT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax 1: To concatenate two strings. CONCAT( string1, string2 ) Syntax 2: To … Read more

CONCAT with function in Oracle

by

CONCAT WITH || The || is an operator which is used to simplify the work of the CONCAT function and thus is used to concatenate two or more strings together. The || operator 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

COMPOSE function in Oracle

by

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 function in Oracle

by

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