Tag: Oracle SQL

Oracle/PLSQL MONTHS_BETWEEN function returns the number of months between date1 and date2. Oracle/PLSQL syntax of MONTHS_BETWEEN function MONTHS_BETWEEN( date1_id, date2_id ) Parameters and...

Oracle/PLSQL LAST_DAY function returns the last day of the month based on the date value. Oracle/PLSQL syntax of LAST_DAY function LAST_DAY( date_id ) Parameters and function arguments...

The Oracle/PLSQL EXTRACT function extracts a value from a date or interval value. Oracle/PLSQL syntax of EXTRACT function EXTRACT ( { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND } | {...

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 ] )...

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...