REQUEST COMPLIMENTARY SQLS*PLUS LICENCE
Numerical / mathematical Oracle PL/SQL functions
Oracle Tutorials: Numric/Math Functions
| Function | Description |
| ABS | The Oracle/PLSQL function of ABS returns the absolute value of the number. |
| ACOS | The Oracle/PLSQL function ACOS returns the number arcosine. |
| ASIN | The Oracle/PLSQL function ASIN returns the number’s arxynus. |
| ATAN | The Oracle/PLSQL function ATAN returns the arctangance of a number. |
| ATAN2 | Oracle/PLSQL function ATAN2 returns the arctangance n and m. |
| AVG | The Oracle/PLSQL function AVG returns the average value of the expression. |
| BITAND | The Oracle/PLSQL function BITAND returns an integer number representing the bitwise operation AND over the bits expr1 and expr2. |
| CEIL | The Oracle/PLSQL function CEIL returns the smallest integer number that is greater than or equal to number. |
| COS | The Oracle/PLSQL function COS returns a cosine number. |
| BITAND | The Oracle/PLSQL function BITAND returns an integer number representing the bitwise operation AND over the bits expr1 and expr2. |
| CEIL | The Oracle/PLSQL function CEIL returns the smallest integer number that is greater than or equal to number. |
| COS | The Oracle/PLSQL function COS returns a cosine number. |
| COSH | The Oracle/PLSQL function COSH returns a hyperbolic cosine number. |
| COUNT | The Oracle/PLSQL function COUNT returns the number of rows returned by the query. |
| EXP | Oracle/PLSQL function EXP returns e elevated to n-th degree where e = 2.71828183. |
| FLOOR | The Oracle/PLSQL function FLOOR returns the largest integer value equal to or less than a number. |
| GREATEST | Oracle/PLSQL function GREATEST returns the highest value in the list of expressions. |
| LEAST | Oracle/PLSQL function LEAST returns the smallest value in the expression list. |
| LN | The Oracle/PLSQL function LN returns the natural logarithm of a number. |
| LOG | The Oracle/PLSQL LOG function returns the logarithm n at the base m. |
| MAX | The Oracle/PLSQL function MAX returns the maximum value of the expression. |
| MEDIAN | The Oracle/PLSQL function MEDIAN returns the expression median. |
| MIN | Oracle/PLSQL The MIN function returns the minimum value of the expression. |
| MOD | Oracle/PLSQL function MOD returns the residue from division m by n. |
| POWER | The Oracle/PLSQL function POWER elevates m to degree n. |
| REGEXP_COUNT | Function Oracle/PLSQL REGEXP_COUNT 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 occurs in a string using a regular expression pattern matching. |
| REMAINDER | Oracle/PLSQL function REMAINDER returns the residue from division m by n. |
| ROUND (FOR NUMBERS) | The Oracle/PLSQL function ROUND returns a number rounded to a certain number of digits after the decimal point. |
| SIGN | The Oracle/PLSQL function SIGN returns a value that defines a number sign. |
| SIN | The Oracle/PLSQL function SIN returns the sinus number. |
| SINH | The Oracle/PLSQL function SINH returns the hyperbolic sinus number. |
| SQRT | The Oracle/PLSQL SQRT function extracts the square root from the number. |
| SUM | The Oracle/PLSQL function SUM returns the total value of the expression. |
| TAN | The Oracle/PLSQL function TAN returns the number tangent. |
| TANH | The Oracle/PLSQL function TANH returns the hyperbolic tangent of a number. |
| TRUNC (FOR NUMBERS) | The Oracle/PLSQL function TRUNC returns a number truncated to a certain number of digits after the decimal point. |
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
MORE NEWS
PreambleNoSql is not a replacement for SQL databases but is a valid alternative for many situations where standard SQL is not the best approach for...
PreambleMongoDB Conditional operators specify a condition to which the value of the document field shall correspond.Comparison Query Operators $eq...
5 Database management trends impacting database administrationIn the realm of database management systems, moreover half (52%) of your competitors feel...
The data type is defined as the type of data that any column or variable can store in MS SQL Server. What is the data type? When you create any table or...
PreambleMS SQL Server is a client-server architecture. MS SQL Server process starts with the client application sending a query.SQL Server accepts,...
First the basics: what is the master/slave?One database server (“master”) responds and can do anything. A lot of other database servers store copies of all...
PreambleAtom Hopper (based on Apache Abdera) for those who may not know is an open-source project sponsored by Rackspace. Today we will figure out how to...
PreambleMongoDB recently introduced its new aggregation structure. This structure provides a simpler solution for calculating aggregated values rather...
FlexibilityOne of the most advertised features of MongoDB is its flexibility. Flexibility, however, is a double-edged sword. More flexibility means more...
PreambleSQLShell is a cross-platform command-line tool for SQL, similar to psql for PostgreSQL or MySQL command-line tool for MySQL.Why use it?If you...
PreambleWriting an application on top of the framework on top of the driver on top of the database is a bit like a game on the phone: you say “insert...
PreambleOracle Coherence is a distributed cache that is functionally comparable with Memcached. In addition to the basic function of the API cache, it...
PreambleIBM pureXML, a proprietary XML database built on a relational mechanism (designed for puns) that offers both relational ( SQL / XML ) and...
What is PostgreSQL array? In PostgreSQL we can define a column as an array of valid data types. The data type can be built-in, custom or enumerated....
PreambleIf you are a Linux sysadmin or developer, there comes a time when you need to manage an Oracle database that can work in your environment.In this...
PreambleStarting with Microsoft SQL Server 2008, by default, the group of local administrators is no longer added to SQL Server administrators during the...