Numeric functions
Download
1 / 4

Numeric Functions - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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

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


  • Sin:-

    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


Floor:-

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


ad