yuanlnet的博客

In Oracle, you can create your own functions.

The SQLERRM function returns the error message associated with the most recently raised error exception.

The SQLCODE function returns the error number associated with the most recently raised error exception.

In Oracle/PLSQL, the to_char function converts a number or date to a string.

In Oracle/PLSQL, the systimestamp function returns the current system date and time (including fractional seconds and time zone) on your local database.

In Oracle/PLSQL, the tz_offset function returns the time zone offset of a value.

In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure.

In Oracle/PLSQL, the sysdate function returns the current system date and time on your local database.

In Oracle/PLSQL, the sessiontimezone function returns the current session's time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.

In Oracle/PLSQL, the round function returns a date rounded to a specific unit of measure.

In Oracle/PLSQL, the next_day function returns the first weekday that is greater than a date.

In Oracle/PLSQL, the new_time function returns a date in time zone1 to a date in time zone2.

In Oracle/PLSQL, the months_between function returns the number of months between date1 and date2.

In Oracle/PLSQL, the localtimestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP value.

In Oracle/PLSQL, the last_day function returns the last day of the month based on a date value.

In Oracle/PLSQL, the from_tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.

In Oracle/PLSQL, the dbtimezone function returns the database time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.

In Oracle/PLSQL, the current_timestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP WITH TIME ZONE value.

In Oracle/PLSQL, the current_date function returns the current date in the time zone of the current SQL session as set by the ALTER SESSION command.S

In Oracle/PLSQL, the add_months function returns a date plus n months.

In Oracle/PLSQL, the variance function returns the variance of a set of numbers.

In Oracle/PLSQL, the var_samp function returns the sample variance of a set of numbers.

In Oracle/PLSQL, the var_pop function returns the population variance of a set of numbers.

In Oracle/PLSQL, the trunc function returns a number truncated to a certain number of decimal places.

In Oracle/PLSQL, the tanh function returns the hyperbolic tangent of n.

In Oracle/PLSQL, the tan function returns the tangent of n.

The SQL SUM function returns the summed value of an expression.

In Oracle/PLSQL, the stddev function returns the standard deviation of a set of numbers.The stddev function can be used two ways - as an Aggregate function or as an Analytic function.

In Oracle/PLSQL, the sqrt function returns the square root of n.

In Oracle/PLSQL, the rawtohex function converts a raw value into a hexadecimal value. One of our viewers says that this function comes in handy to move a varchar value to a blob field.

In Oracle/PLSQL, the sinh function returns the hyperbolic sine of n.

In Oracle/PLSQL, the sin function returns the sine of n.

In Oracle/PLSQL, the sign function returns a value indicating the sign of a number.

In Oracle/PLSQL, the round function returns a number rounded to a certain number of decimal places.

In Oracle/PLSQL, the remainder function returns the remainder of m divided by n.

In Oracle/PLSQL, the rank function returns the rank of a value in a group of values. It is very similar to the dense_rank function.

In Oracle/PLSQL, the power function returns m raised to the nth power.

In Oracle/PLSQL, the mod function returns the remainder of m divided by n.

In Oracle/PLSQL, the median function returns the median of an expression.

In Oracle/PLSQL, the log function returns the logarithm of n base m.