I’ve grouped all of these functions into a single article because they are quite similar and are related functions.
Purpose of the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions
The purpose of these functions is to:
- ASIN – return the arc sine of a number
- ACOS – return the arc cosine of a number
- ATAN – return the arc tangent of a number
- ATAN2 – returns the arc tangent of two numbers.
- COSH – returns the hyperbolinc cosine of a number.
Now, if you need to use these functions, then you probably know what these terms (like arc sine) mean. I don’t remember what they mean (it’s been a while since I did high school maths), but you can find the definitions of them here: (LINK)
The syntax of these three functions is similar.
The ASIN function syntax is:
ASIN ( number)
The ACOS function syntax is:
ACOS ( number )
The ATAN function syntax is:
ATAN ( number )
The COSH function syntax is:
COSH ( number )
However, the ATAN2 syntax is slightly different:
ATAN2 ( number1 [/|,] number2 )
For the ATAN2 function, it can be written as either number1,number2 or number1/number2. Both formats produce the same results.
The parameters of four of functions are all the same:
- number (mandatory): The number to convert to either an ASIN, ACOS, ATAN, or COSH value.
For ATAN2, the parameters are:
- number1 (mandatory): The first number to use in the arc tangent calculation.
- number2 (mandatory): The second number to use in the arc tangent calculation.
There are some things to note about these parameters:
- For ASIN, ACOS, and ATAN, the function returns the same data type as the input data type (unless the input is a BINARY_FLOAT, then the function returns a BINARY_DOUBLE).
- For ATAN2, the function returns NUMBER (unless either of the inputs is a BINARY_FLOAT, then the function returns a BINARY_DOUBLE).
- For COSH, the function returns a DECIMAL value.
- For ASIN and ACOS, the number must be in the range of -1 to 1.
Examples of the ASIN, ACOS, ATAN, ATAN2, and COSH Functions
Here are some examples of these functions. I find that examples are the best way for me to learn about code, even with the explanation above.
Example 1 – ASIN
This is an example of the ASIN function.
SELECT ASIN(-0.4) AS asin_value FROM dual;
Example 2 – ACOS
This is an example of the ACOS function.
SELECT ACOS(0.31) AS acos_value FROM dual;
Example 3 – ATAN
This is an example of the ATAN function.
SELECT ATAN(1.1) AS atan_value FROM dual;
Example 4 – ATAN2
This is an example of the ATAN2 function.
SELECT ATAN2(3, 1.6) AS atan2_value FROM dual;
Example 5 – COSH
This is an example of the COSH function.
SELECT COSH(5) AS cosh_value FROM dual;
Other than each of the functions mentioned in this article, some functions which are similar to these functions are:
- SIN – Returns the sine of a number.
- COS – Returns the cosine of a number.
- TAN – Returns the tangent of a number.
You can find a full list of Oracle SQL functions here.
Lastly, if you enjoy the information and career advice I’ve been providing, sign up to my newsletter below to stay up-to-date on my articles. You’ll also receive a fantastic bonus. Thanks!