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
AVG is one of the vital Numeric/Math functions of Oracle. It is used to get the average value of an expression. The AVG 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 average. SELECT AVG (aggregate_expression) FROM tables … Read more
ATAN2 is one of the vital Numeric/Math functions of Oracle. It is used to get the arc TANGENT of two numbers. The ATAN2 function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ATAN2 ( x, y ) Parameters: x, y: It … Read more
ATAN is one of the vital Numeric/Math functions of Oracle. It is used to get the arc TANGENT of a number. The ATAN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ATAN ( number ) Parameters: number: It is used … Read more
ASIN is one of the vital Numeric/Math functions of Oracle. It is used to get the arc sine of a number. The ASIN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ASIN ( number ) Parameters: number: It is used … Read more
ASCIISTR is also one of the vital string/char functions of Oracle. It is used to return the ASCII code for a string in any character set. It uses the database character set. The ASCIISTR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: … Read more
ASCII is one of the vital string/char functions of Oracle. It is used to return the ASCII code for the desired character or symbol. The ASCII function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: ASCII( character ) Parameters: character: It … Read more
ANTI JOIN Anti-join is used to return one copy of those rows from a table where no matches are found in the values with the other mentioned table, and to serve this purpose, NOT EXISTS or NOT IN constructs are used instead of any JOIN keyword. The main advantage of this kind of Join query … Read more
ALTER TABLE To add, modify, drop or delete columns in a table ALTER TABLE statement is used. Along with all these, it is also used to rename a table. The ALTER TABLE statement allow the users to Add one or more columns, to Modify column definition, to Drop one or more columns, to Rename columns … Read more