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)

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



SIN(45*3.1412857/180)

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

           .707052517

• Oracle Numeric Functions: SIN
• Native Compilation: Example using SIN

• 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 ...
• TABLESPACE: Permanent Tablespace Using A Raw Device - Example of creating permanent tablespace on ...