- By
**ilar** - Follow User

- 116 Views
- Uploaded on

Numeric Functions. Purpose:- SIN returns the sine of n (an angle expressed in radians).

Download Presentation
## PowerPoint Slideshow about ' Numeric Functions' - ilar

**An Image/Link below is provided (as is) to download presentation**

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

### Numeric Functions

Purpose:-

SIN returns the sine of n (an angle expressed in radians).

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. If the argument is BINARY_FLOAT, then the function returns BINARY_DOUBLE. Otherwise the function returns the same numeric datatype as the argument.

ExamplesThe following example returns the sine of 30 degrees:

SELECT SIN(30 * 3.14159265359/180) "Sine of 30 degrees" FROM DUAL;

Sine of 30 degrees

------------------

.5

Purpose:-

COS returns the cosine of n (an angle expressed in radians).

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. If the argument is BINARY_FLOAT, then the function returns BINARY_DOUBLE. Otherwise the function returns the same numeric datatype as the argument.

- Examples:-The following example returns the cosine of 180 degrees:

SELECT COS(180 * 3.14159265359/180) "Cosine of 180 degrees" FROM DUAL;

- Cosine of 180 degrees

--------------------- -1

Purpose:-

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. The function returns the same datatype as the numeric datatype of the argument.

Examples:-The following example returns the largest integer equal to or less than 15.7:

- SELECT FLOOR(15.7) "Floor" FROM DUAL;

Floor

----------

15

Download Presentation

Connecting to Server..