Tag: SQL

The Oracle/PLSQL DBTIMEZONE function returns the time zone of the database as an offset of the time zone (in the following format: '[+|-]TZH:TZM') or the time zone name. Oracle/PLSQL syntax of...

 Oracle/PLSQL CURRENT_TIMESTAMP function returns the current date and time in the time zone of the current SQL session as set with the ALTER SESSION command. It returns the date/time...

Oracle/PLSQL CURRENT_DATE function returns the current date in the time zone of the current SQL session as set with the ALTER SESSION command. Oracle/PLSQL syntax of function...

The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Oracle/PLSQL syntax of ADD_MONTHS function ADD_MONTHS( date1_id, n_id ) Parameters and function argumentsdate1_id -...

Oracle Tutorials: Numric/Math FunctionsFunction DescriptionABS The Oracle/PLSQL function of ABS returns the absolute value of the number.ACOS The Oracle/PLSQL function ACOS...

The Oracle/PLSQL TRUNC function returns a number truncated to a certain number of digits after the decimal point. Oracle/PLSQL syntax of TRUNC function TRUNC( number_id, [ decimal_places_id ] )...

Enabling profiling is an affordable way to get an accurate estimate of the time the request has been executed. First you need to enable profiling and call show profiles to get an accurate...

The Oracle/PLSQL SUM function returns the total value of the expression. Oracle/PLSQL syntax of SUM function SELECT SUM(aggregate_expression_id) FROM tabs [WHERE conds]OR syntax for SUM...

The Oracle/PLSQL SQRT function extracts the square root from the number. Syntax of the Oracle/PLSQL SQRT function SQRT( number_id ) Parameters and function argumentsnumber_id - is a...

The Oracle/PLSQL SINH function returns the hyperbolic sinus number. Oracle/PLSQL syntax of the SINH function SINH( number_id ) Parameters and function argumentsnumber_id - number.The...

The Oracle/PLSQL SIN function returns the sinus number. Oracle/PLSQL syntax of the SIN function SIN( number_id ) Parameters and function argumentsnumber_id - is a number, coal sinus in...

The Oracle/PLSQL SIGN function returns a value that defines a number sign. The Oracle/PLSQL syntax of the SIGN function SIGN( number_id ) Parameters and function argumentsa number_id -...

The Oracle/PLSQL ROUND function returns a number rounded to a certain number of digits after the decimal point. Syntax of Oracle/PLSQL function ROUND (for numbers) ROUND( number_id, [...

Oracle/PLSQL REMAINDER function returns the residue from division m by n. Oracle/PLSQL syntax of REMAINDER function REMAINDER( m, n ) Parameters and function argumentsm - is the numeric...

Oracle/PLSQL REGEXP_COUNT function calculates the number of occurrences of the template in the string. This function, introduced in Oracle 11g, allows you to count the number of times a substring...

The Oracle/PLSQL POWER function elevates m to degree n. Oracle/PLSQL syntax of the POWER function POWER( m, n ) Parameters or argumentsm - is the base. n - is an indicator.The...