CREATE VIEW The view is a virtual table in Oracle with no physical existence as such and thus it does not store any data. The view is saved in the data dictionary of the Oracle and when called, it can be simply executed. Syntax: CREATE VIEW name AS SELECT column_1, column_2, column_3,…… FROM table WHERE … Read more
CREATE TABLE AS To create a table from an existent table, the CREATE TABLE AS statement is used. It copies the columns of the existing table to the new table. Syntax: For creating a table by copying all columns of another table. CREATE TABLE current_table AS (SELECT * FROM existing_table); Syntax: For creating a table … Read more
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 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 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 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 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 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 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 || 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