Term: SIN

Definition:
In Oracle PL/SQL, SIN is a built in function used to determine sine of a numeric input. Its mathematical equivalent is SIN(N), where N is the angle in radian format.

Example Syntax:

SIN(radian)

Example Usage:

The SQL example below calculates the sine of 45 degrees. Note that the representation of 45 degrees is in radians.

SQL> SELECT SIN(45 * 3.1412857/180) FROM DUAL;



SIN(45*3.1412857/180)

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

           .707052517

Related Links:

Related Code Snippets:

WITH Clause: Single alias - The WITH query_name clause provides a way assign a name to a subquery ...
Date Functions: TO_DSINTERVAL - Converts a string to an INTERVAL DAY TO SECOND DataType.
Date Functions: NUMTODSINTERVAL - Converts a number to an INTERVAL DAY TO SECOND literal.
INSERT: Single Column Table Or View - Simple single table/column SELECT examples.
INSERT: Using A Record - Insert by Using RECORD Type Variable.
UPDATE: Single row - Update a single row of data in a single table.
NUMTODSINTERVAL - NUMTODSINTERVAL converts n to an INTERVAL DAY TO SECOND literal. The argument n ...
TO_DSINTERVAL - Converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an ...
TO_SINGLE_BYTE - Returns char with all of its multibyte characters converted to their correspondin...
SELECT: Using Functions - SELECT allows the use of functions within its scope, as shown by the use...
Using COMMIT in a PL/SQL loop - Oracle recommends that you COMMIT less frequently within a PL/SQL ...
INDEXES: Single Column Non-unique - Example of creating an index. Note that by default, Oracle cre...
TABLESPACE: Using Raw Devices - A raw device is a portion of a physical disk that Oracle uses for ...
TABLE: Using Select Statement With Data - Create Table Using a Select statement CREATE TABLE AS...
TABLESPACE: Permanent Tablespace Using A Raw Device - Example of creating permanent tablespace on ...