ADD_MONTHS is one of the vital Date/Time functions of Oracle. It is used to get a date with a specified number of months added. The ADD_MONTHS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ADD_MONTHS ( date, number_months ) Parameters: … Read more
ACOS is one of the vital Numeric/Math functions of Oracle. It is used to get the arc cosine of a number. The ACOS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ACOS ( number ) Parameters: number: It is used … Read more
USERENV is an advanced function that the Oracle database supports. It is used to get the information about the current Oracle session. The USERENV function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: USERENV (parameter) Parameters: parameter: It is used to … Read more
SQLCODE function is used within the Exception Handling section of a code. It is used to get the error number. Here, the error number is associated with the most recently raised error exception. Syntax: SQLCODE Example: EXCEPTION WHEN OTHERS THEN Raise_application_error (-20001, ‘Error detected – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END;EXCEPTION WHEN OTHERS THEN Raise_application_error (-20001, ‘Error … Read more
SQLERRM function is used within the Exception Handling section of a code. It is used to get the error message. Here, the error message is associated with the most recently raised error exception. Syntax: SQLERRM Example: EXCEPTION WHEN OTHERS THEN Raise_application_error (-20001, ‘Error detected – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END;EXCEPTION WHEN OTHERS THEN Raise_application_error (-20001, ‘Error … Read more
CREATE TABLE To create a new table in the database, Oracle provides the Oracle CREATE TABLE statement. Syntax: CREATE TABLE schema_name.table_name ( column_1 data_type column_constraint, column_2 data_type column_constraint, … table_constraint ); Parameters: schema_name: It is used to specify the name of the schema to which the new table belongs. table_name: It is used to specify … Read more
WHAT IS ORACLE? Oracle database often called as Oracle RDBMS, OracleDB, or simply Oracle is a relational database management system, developed and marketed by the Oracle Corporation. The Oracle Corporation is a software company, also known as one of the biggest providers in the database business. It has earned its reputation because of various reasons. … Read more